Class SpreadsheetSplitter

public class SpreadsheetSplitter

Inheritance

object ← SpreadsheetSplitter

Inherited Members

• object.GetType(),
• object.MemberwiseClone(),
• object.ToString(),
• object.Equals(object?),
• object.Equals(object?, object?),
• object.ReferenceEquals(object?, object?),
• object.GetHashCode()

Examples

[C#]
LoadOptions loadOptions = new LoadOptions();
loadOptions.InputFile = "Template.xlsx";
SpreadsheetSaveOptions saveOptions = new SpreadsheetSaveOptions();
SpreadsheetSplitter.Process(loadOptions, saveOptions);

Methods

Process(LoadOptions, SplitterSaveOptions)

public static void Process(LoadOptions loadOptions, SplitterSaveOptions saveOptions)

Parameters

• loadOptions LoadOptions: Options for input and loading:
• saveOptions SplitterSaveOptions: Options for output and saving

Remarks

If the save options has specified Stream as output, then all split parts will be saved to the same Stream. Otherwise, the output files will be build from the specified output 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, …

Process(LoadOptions, SplitterSaveOptions, AbstractSaveOptionsProvider)

public static void Process(LoadOptions loadOptions, SplitterSaveOptions saveOptions, AbstractSaveOptionsProvider provider)

Parameters

• loadOptions LoadOptions: Options for input and loading:
• saveOptions SplitterSaveOptions: Options for saving. Its output(Sheetize.SaveOptions.OutputFile or Sheetize.SaveOptions.OutputStream): takes no effect because all outputs will be specified by the “provider” parameter:
• provider AbstractSaveOptionsProvider: Provider of save options for saving split parts