Class SpreadsheetMerger

Info

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