newStreamingXlsx

(Version 2+)

Returns a new XML spreadsheet workbook object which uses memory-efficient streaming while being populated.

newStreamingXlsx( [sheetName [, streamingWindowSize] ] );

Optional arguments

• sheetName string: name to give the default sheet in the new workbook.
• streamingWindowSize integer default=100: (positive integer greater than 0) the maximum number of rows that are kept in memory at once while populating the sheet, before being flushed to disk.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.newStreamingXlsx( streamingWindowSize=10 );