public static void Run()
{
// ExStart:UsingGlobalizationSettings
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Load your source workbook
Workbook wb = new Workbook(dataDir + "sample.xlsx");
// Set the glorbalization setting to change subtotal and grand total names
GlobalizationSettings gsi = new GlobalizationSettingsImp();
wb.Settings.GlobalizationSettings = gsi;
// Access first worksheet
Worksheet ws = wb.Worksheets[0];
// Apply subtotal on A1:B10
CellArea ca = CellArea.CreateCellArea("A1", "B10");
ws.Cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 2, 3, 4 });
// Set the width of the first column
ws.Cells.SetColumnWidth(0, 40);
// Save the output excel file
wb.Save(dataDir + "output_out.xlsx");
// ExEnd:UsingGlobalizationSettings
}
public static void Run()
{
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
//Output directory
string outputDir = RunExamples.Get_OutputDirectory();
// Load your source workbook
Workbook wb = new Workbook(sourceDir + "sampleTotalsInOtherLanguages.xlsx");
// Set the glorbalization setting to change subtotal and grand total names
GlobalizationSettings gsi = new GlobalizationSettingsImp();
wb.Settings.GlobalizationSettings = gsi;
// Access first worksheet
Worksheet ws = wb.Worksheets[0];
// Apply subtotal on A1:B10
CellArea ca = CellArea.CreateCellArea("A1", "B10");
ws.Cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 2, 3, 4 });
// Set the width of the first column
ws.Cells.SetColumnWidth(0, 40);
// Save the output excel file
wb.Save(outputDir + "outputTotalsInOtherLanguages.xlsx");
Console.WriteLine("TotalsInOtherLanguages executed successfully.");
}
public static void Run()
{
// ExStart:UsingGlobalizationSettings
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Load your source workbook
Workbook wb = new Workbook(dataDir + "sample.xlsx");
// Set the glorbalization setting to change subtotal and grand total names
GlobalizationSettings gsi = new GlobalizationSettingsImp();
wb.Settings.GlobalizationSettings = gsi;
// Access first worksheet
Worksheet ws = wb.Worksheets[0];
// Apply subtotal on A1:B10
CellArea ca = CellArea.CreateCellArea("A1", "B10");
ws.Cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 2, 3, 4 });
// Set the width of the first column
ws.Cells.SetColumnWidth(0, 40);
// Save the output excel file
wb.Save(dataDir + "output_out.xlsx");
// ExEnd:UsingGlobalizationSettings
}