SpreadsheetSplitter

SpreadsheetSplitter class

Splits spreadsheet file into multiple parts.

class SpreadsheetSplitter;

Methods

MethodDescription
isNull()Checks whether the implementation object is null.
static process(string, string)Splits given template file into multiple parts.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;

process(string, string)

Splits given template file into multiple parts.

static process(templateFile: string, resultFile: string) : void;

Parameters:

ParameterTypeDescription
templateFilestringThe template file to be split
resultFilestringThe resultant file(name pattern)

Remarks

The output files will be build from the specified resultant file by appending sequence number of the sheet and split part. For example, if the specified output file is Split.xlsx, then the generated files will be Split_0_0.xlsx, Split_0_1.xlsx, …, Split_1_0.xlsx, …