public override void Execute(GrapeCity.Documents.Excel.Workbook workbook)
{
//Change the path to the real file path when open.
XlsxOpenOptions options = new XlsxOpenOptions();
options.Password = "******";
workbook.Open(this.CurrentDirectory + "source.xlsx", options);
}
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook)
{
//Use XlsxOpenOptions.ImportFlags to control what you want to import from excel, ImportFlags.Data means only the data will be imported
//Change the path to the real file path when open.
XlsxOpenOptions options = new XlsxOpenOptions();
options.ImportFlags = ImportFlags.Data;
workbook.Open(this.CurrentDirectory + "source.xlsx", options);
}
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook)
{
//When XlsxOpenOptions.DoNotRecalculateAfterOpened means GrapeCity Documents for Excel will just read all the cached values without calculating again after
//opening an Excel file.
//Change the path to the real file path when open.
XlsxOpenOptions options = new XlsxOpenOptions();
options.DoNotRecalculateAfterOpened = true;
workbook.Open(this.CurrentDirectory + "source.xlsx", options);
}