/*global SpreadsheetApp: false, Browser: false, DocumentApp: false, Logger: false*/ /* * Written by: [email protected] * * 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; } }