CopySpreadsheetTableToDocument.js

/*global SpreadsheetApp: false, Browser: false, DocumentApp: false, Logger: false*/

/* 
 * Written by: mick@javascript-spreadsheet-programming.com
 * 
 * Date: 2013-07-05
 * 
 * Passed by JSLint
 */

/**
 * Copy array values to a document table
 * 
 * Given a document name and an array of arrays, creates the document table.
 * Highlights the first row (header) in bold.
 * Checks for two arguments, the first must be a string and the second an array.
 * 
 * @param {type} docName
 * @param {type} values
 * @returns {undefined}
 */
function writeTableToDocument(docName, values) {
    "use strict";
    var doc,
        table,
        headerRow,
        styles = {};
    if (typeof docName !== 'string') {
        throw {name: 'TypeError',
            message: 'Function writeTableToDocument() ' +
                    'expects a string name for the new ' +
                    'document as its first argument!'};
    }
    if (!Array.isArray(values)) {
        throw {name: 'TypeError',
            message: 'Function writeTableToDocument() ' +
                    'expects an array of values as its second argument.'};
    }
    try {
        doc = DocumentApp.create(docName);
        table = doc.getBody().appendTable(values);
        headerRow = table.getRow(0);
        styles[DocumentApp.Attribute.BOLD] = true;
        headerRow.setAttributes(styles);
        doc.saveAndClose();
    } catch (ex) {
        throw ex;
    }
}

/**
 * Return the cell values of a named range
 * checks that the given argument is type string.
 * Uses this name to reference a spreadsheet range.
 * If the range name does not exists, it will return 'undefined'
 * 
 * @param rngName string
 * @returns array
 */
function getRangeNameValues(rngName) {
    "use strict";
    var ss = SpreadsheetApp.getActiveSpreadsheet(),
        namedRng,
        namedRngValues = [];
    if (typeof rngName !== 'string') {
        throw {name: 'TypeError',
            message: 'Function getRangeNameValues() ' +
                    'expects a single string argument for the ' +
                    'name of the target range!'};
    }
    try {
        namedRng = ss.getRangeByName(rngName);
        namedRngValues = namedRng.getValues();
        return namedRngValues;
    } catch (ex) {
        throw ex;
    }
}


/**
 * Runs the copying code
 * 
 * @returns {undefined}
 */
function main() {
    "use strict";
    var rngName = "ContactDetails",
        docName = rngName,
        rngValues;
    try {
        rngValues = getRangeNameValues(rngName);
        writeTableToDocument(docName, rngValues);
        Browser.msgBox('New file created');
    } catch (ex) {
        Browser.msgBox('There has been an error, check the log');
        Logger.log('ERROR:');
        Logger.log(ex.message);
        throw ex;
    }
}