ExcelWritableWorkbook

The ExcelWritableWorkbook is returned by the ExcelWorkbook.loadWritable functions.
 It should not be instantiated.

Functions

getWorkbookFile()

Write the Excel workbook as a binary. The binary can be used for file attachmments or Downloads.

example:
data = xls.getWorkbookFile(); // data is a file attachment

@return: The binary

getNumberOfSheets()

Get the number of sheets in the Workbook

@return: The number of sheets as an integer

createSheet(sheetName, position)

Create a new Sheet in the Workbook

• sheetName
• position

@return: A Writable Sheet

copySheet(sourceSheetName, targetSheetName, position)

Copy a sheet into another sheet

• sourceSheetName
• targetSheetName
• position

@return: A Writable Sheet

getSheetByName(sheetName)

Get a Sheet in the Workbook by its name

• sheetName

@return: A Writable Sheet

getSheetByPosition(position)

Get a sheet by position

• position

@return: A Writable Sheet