Creando Subtotales
Contents
[
Hide
]
Crear subtotales
El siguiente código de ejemplo muestra cómo crear subtotales usando Aspose.Cells. El código carga el archivo de Excel de ejemplo y crea subtotales en el rango de celdas B13:C19 y guarda el archivo de Excel de salida. La siguiente captura de pantalla muestra cómo se ven el archivo de Excel de ejemplo y de salida después de la ejecución del código.
Código de muestra
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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(); |