export function writeOperations ( ) { Excel . run ( function ( context ) { var currentWorksheet = context . workbook . worksheets . getActiveWorksheet ( ) ; var expensesTable = currentWorksheet . tables . add ( "A1:D1" , true ) ; expensesTable . name = "ExpensesTable" ; expensesTable . getHeaderRowRange ( ) . values = [ [ "Date" , "Merchant" , "Category" , "Amount" ] ] ; expensesTable . rows . add ( undefined , [ [ "1/1/2017" , "The Phone Company" , "Communications" , "120" ] , [ "1/2/2017" , "Northwind Electric Cars" , "Transportation" , "142.33" ] , [ "1/5/2017" , "Best For You Organics Company" , "Groceries" , "27.9" ] , [ "1/10/2017" , "Coho Vineyard" , "Restaurant" , "33" ] , [ "1/11/2017" , "Bellows College" , "Education" , "350.1" ] , [ "1/15/2017" , "Trey Research" , "Other" , "135" ] , [ "1/15/2017" , "Best For You Organics Company" , "Groceries" , "97.88" ] ] ) ; return context . sync ( ) ; } ) ; } export function readOperations ( ) { Excel . run ( function ( context ) { var currentWorksheet = context . workbook . worksheets . getActiveWorksheet ( ) ; var expensesTable = currentWorksheet . tables . getItemAt ( 0 ) ; var expenseValues = expensesTable . getHeaderRowRange ( ) . values ; return context . sync ( ) ; } ) ; }