Creazione dei subtotali

Creare i Subtotali

Il seguente codice di esempio mostra come creare i subtotali utilizzando Aspose.Cells. Il codice carica il file Excel di esempio e crea i subtotali nell’intervallo delle celle B13:C19 e salva il file Excel di output. La schermata seguente mostra l’aspetto del file Excel di esempio e di output dopo l’esecuzione del codice.

todo:image_alt_text

Codice di Esempio

Aspose::Cells::Startup();
//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C
//Path of input
U16String dirPath(u"");
//Path of output
U16String outPath(u"");
//Path of input excel file
U16String sampleCreatingSubtotals = dirPath + u"sampleCreatingSubtotals.xlsx";
//Path of output excel file
U16String outputCreatingSubtotals = outPath + u"outputCreatingSubtotals.xlsx";
//Load sample excel file into a workbook object
Workbook wb(sampleCreatingSubtotals);
//Get first worksheet of the workbook
Worksheet ws = wb.GetWorksheets().Get(0);
//Get the cells collection of the worksheet
Cells cells = ws.GetCells();
//Create cell area covering the cell range B3:C19
CellArea ca = CellArea::CreateCellArea(u"B3", u"C19");
//Create integer array of size 1 and set its first value to 1
int data[1]{1};
Vector<int> totalList(data,1);
//Apply subtotal, the consolidation function is Sum and it will be applied to second column
cells.Subtotal(ca, 0, ConsolidationFunction::Sum, totalList);
//Save the workbook in xlsx format
wb.Save(outputCreatingSubtotals);
Aspose::Cells::Cleanup();