excel - How can I get PivotTable Row and Column labels to change from their default value using Aspose Cells? -
i creating row , column pivot fields so:
pivottable.addfieldtoarea(aspose.cells.pivot.pivotfieldtype.row, description_column); pivottable.addfieldtoarea(aspose.cells.pivot.pivotfieldtype.column, monthyr_column);
this works, uses generic text labels, "row labels" , "column labels." want provide own labels replace those. using excel interop, can follows:
// changes label "column labels" pivottable.compactlayoutcolumnheader = "months"; // changes label "row labels" pivottable.compactlayoutrowheader = "description";
i can't use excel interop of these reports, though, because slow converting large amounts of data pivottable makes sloths cheetahs , molasses appear moving @ speed of light. literally took several hours generate excel interop took 21 minutes using aspose cells.
so equivalent of "compactlayoutcolumnheader" in aspose cells? makes intent little clearer (who think "compactlayoutcolumnheader" property assign label?
i stumbled across answer; more straightforward in aspose.cells excel interop (unsurprisingly):
pivottable.columnheadercaption = "months"; pivottable.rowheadercaption = "description";
Comments
Post a Comment