I have a couple questions about pivot tables.
1) Is there away to autofit all columns generated by the pivot table.
2) How do you set the number format of a DataField. i.e) I want to format this column to be a currency.
pt.DataFields.Add(pt.PivotFields("Amount"), "Total", Spire.Xls.SubtotalTypes.Sum)