static void Main(string[] args)
{
// Create Spreadsheet instance
Spreadsheet spreadsheet = new Spreadsheet();
spreadsheet.RegistrationName = "demo";
spreadsheet.RegistrationKey = "demo";
// Load document
spreadsheet.LoadFromFile(@"CustomFuncExample.xlsx");
// Add custom formula handler
spreadsheet.CustomFunctionsCallback = new CustomFunctionsCallback(MyFunctions);
// Calculate the first worksheet
Worksheet worksheet = spreadsheet.Workbook.Worksheets[0];
worksheet.Calculate();
// Save calculated values to neighbor cells to demonstrate custom functions are calculated
worksheet["C2"].Value = worksheet["B2"].Value;
worksheet["C3"].Value = worksheet["B3"].Value;
worksheet["C4"].Value = worksheet["B4"].Value;
// Save modified spreadsheet
spreadsheet.SaveAs(@"result.xlsx");
// Cleanup
spreadsheet.Dispose();
// Open saved spreadsheet in associated application (for demo purpose)
Process.Start("result.xlsx");
}
public double SheetTimer(Worksheet sheet)
{
MicroStopwatch timer = MicroStopwatch.StartNewMicroStopwatch();
sheet.Calculate();
return((double)timer.ElapsedMillisecondsHighResolution);
}
