Class SpreadsheetMerger

Class SpreadsheetMerger

Merges multiple template files into one.
public class SpreadsheetMerger

Inheritance

object ← SpreadsheetMerger

Inherited Members

Examples 

[C#]
LoadOptions loadOptions = new LoadOptions();
list.Add(new LoadOptions() { InputFile = "template1.xlsx" });
list.Add(new LoadOptions() { InputFile = "template2.xlsx" });
SpreadsheetSaveOptions saveOptions = new SpreadsheetSaveOptions();
saveOptions.OutputFile = "merged.xlsx";
SpreadsheetMerger.Process(loadOptions, saveOptions,
    new string[] { "template2.xlsx", "template2.xlsx", });

Methods

Process(LoadOptions, SaveOptions, string[]) 

public static void Process(LoadOptions loadOptions, SaveOptions saveOptions, string[] files)

Parameters

  • loadOptions LoadOptions : Options for input and loading. Its input(Sheetize.LoadOptions.InputFile or Sheetize.LoadOptions.InputStream): takes no effect because all inputs will be specified by “files” parameter.
  • saveOptions SaveOptions : Options for output and saving:
  • files string []: All template files to be merged

Process(LoadOptions, SaveOptions, AbstractLoadOptionsProvider) 

public static void Process(LoadOptions loadOptions, SaveOptions saveOptions, AbstractLoadOptionsProvider provider)

Parameters

  • loadOptions LoadOptions : Options for loading. Its input(Sheetize.LoadOptions.InputFile or Sheetize.LoadOptions.InputStream): takes no effect because all inputs will be specified by “provider” parameter.
  • saveOptions SaveOptions : Options for output and saving:
  • provider AbstractLoadOptionsProvider : Provider of load options for getting inputs to be merged

Namespace: Sheetize | Assembly: Sheetize.dll

 English