Guardar tabla dinámica en archivo ODS
Aspose.Cells proporciona la capacidad de guardar la tabla dinámica en archivos ODS. Para ello, simplemente convierta un libro de trabajo con una tabla dinámica existente o cree una nueva tabla dinámica y guarde el archivo en formato ODS. Asegúrese de llamar a PivotTable.CalculateData() antes de guardar para garantizar que la tabla dinámica se represente en el archivo ODS de salida. El siguiente fragmento de código demuestra cómo guardar la tabla dinámica en un archivo ODS.
Código de Muestra
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
string outputDir = RunExamples.Get_OutputDirectory(); | |
// Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
// Obtaining the reference of the newly added worksheet | |
Worksheet sheet = workbook.Worksheets[0]; | |
Cells cells = sheet.Cells; | |
// Setting the value to the cells | |
Cell cell = cells["A1"]; | |
cell.PutValue("Sport"); | |
cell = cells["B1"]; | |
cell.PutValue("Quarter"); | |
cell = cells["C1"]; | |
cell.PutValue("Sales"); | |
cell = cells["A2"]; | |
cell.PutValue("Golf"); | |
cell = cells["A3"]; | |
cell.PutValue("Golf"); | |
cell = cells["A4"]; | |
cell.PutValue("Tennis"); | |
cell = cells["A5"]; | |
cell.PutValue("Tennis"); | |
cell = cells["A6"]; | |
cell.PutValue("Tennis"); | |
cell = cells["A7"]; | |
cell.PutValue("Tennis"); | |
cell = cells["A8"]; | |
cell.PutValue("Golf"); | |
cell = cells["B2"]; | |
cell.PutValue("Qtr3"); | |
cell = cells["B3"]; | |
cell.PutValue("Qtr4"); | |
cell = cells["B4"]; | |
cell.PutValue("Qtr3"); | |
cell = cells["B5"]; | |
cell.PutValue("Qtr4"); | |
cell = cells["B6"]; | |
cell.PutValue("Qtr3"); | |
cell = cells["B7"]; | |
cell.PutValue("Qtr4"); | |
cell = cells["B8"]; | |
cell.PutValue("Qtr3"); | |
cell = cells["C2"]; | |
cell.PutValue(1500); | |
cell = cells["C3"]; | |
cell.PutValue(2000); | |
cell = cells["C4"]; | |
cell.PutValue(600); | |
cell = cells["C5"]; | |
cell.PutValue(1500); | |
cell = cells["C6"]; | |
cell.PutValue(4070); | |
cell = cells["C7"]; | |
cell.PutValue(5000); | |
cell = cells["C8"]; | |
cell.PutValue(6430); | |
PivotTableCollection pivotTables = sheet.PivotTables; | |
// Adding a PivotTable to the worksheet | |
int index = pivotTables.Add("=A1:C8", "E3", "PivotTable2"); | |
// Accessing the instance of the newly added PivotTable | |
PivotTable pivotTable = pivotTables[index]; | |
// Unshowing grand totals for rows. | |
pivotTable.RowGrand = false; | |
// Draging the first field to the row area. | |
pivotTable.AddFieldToArea(PivotFieldType.Row, 0); | |
// Draging the second field to the column area. | |
pivotTable.AddFieldToArea(PivotFieldType.Column, 1); | |
// Draging the third field to the data area. | |
pivotTable.AddFieldToArea(PivotFieldType.Data, 2); | |
pivotTable.CalculateData(); | |
// Saving the ODS file | |
workbook.Save(outputDir + "PivotTableSaveInODS_out.ods"); |
El archivo de salida generado del código anterior está adjunto para su referencia.