We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

RowAxisLayout support in Aspose.Cells Pivot tables

There is a way, or is in plan a support in the near future, to create a Pivot Table with RowAxisLayout property set to xlCompactRow excel value ?
We are using Aspose.Cells 4.8.0.0 for creating Excel 2007 PivotTable reports

Thanks in advance,

Hi,

Could you create a sample pivot table manually in MS excel with details or screen shots, post the file here to show your requirement, we will check it soon.

Thank you.

Thanks for your reply. I’ve solved myself:

for(int i = 0;i<pivotTable.RowFields.Count;i++)
{
PivotField f = pivotTable.RowFields[i];
f.ShowCompact = true;
f.ShowInOutlineForm = true;
}

In Excel there is a PivotTable property (RowAxisLayout) that obtain the same result

Regards