Skip to content

Instantly share code, notes, and snippets.

@zlatko-michailov
zlatko-michailov / excel.js
Last active March 29, 2017 09:39
Excel JavaScript API Niceties
function createAndPopulateTable(context, worksheetName, rangeAddress, hasHeaderRow, headerValues, bodyFormulas, tableCustomizer) {
var worksheet = context.workbook.worksheets.getItem(worksheetName);
// Calculate table-, body-, and header- ranges
var tableRange = worksheet.getRange(rangeAddress);
var bodyRange = tableRange;
if (hasHeaderRow) {
bodyRange = tableRange.getResizedRange(-1, 0).getOffsetRange(1, 0);
if (headerValues) {
// Set header values