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

Tags:
Created by Maurice Gasco on 2018/06/07 16:46
     
This wiki is licensed under a Creative Commons 2.0 license
XWiki Enterprise 9.11.5 - Documentation