how to set Number format to pivot table datafields

[chaitanya]

could you please let me know how to set number format to pivot table datafields

[amy.zhao]

Dear chaitanya,

Thanks for your inquiry.
Please refer to the code snippet below.

Code: Select all

            PivotField fieldOrderNo = pivotTable.PivotFields["OrderNo"] as PivotField;
            fieldOrderNo.Axis = AxisTypes.Row;
            fieldOrderNo.NumberFormat = "0.00";


Regards,
Amy
E-iceblue support team

[amy.zhao]

Dear chaitanya,

Has this issue been resolved?
Please give us a feedback at your early convenience.

Thanks & Regards,
Amy
E-iceblue support team

[chaitanya]

Dear Amy,

thanks for your continuous support.

the code below you provided works perfectly.

but is there a possibility to set number format like pivottable.datafields[0].numberformat because I don't want to set the format immediately after creating rather I do like to set the format after all the datafields are created.

[amy.zhao]

Dear chaitanya,

Thanks for your feedback.
For your new issue below:
"is there a possibility to set number format like pivottable.datafields[0].numberformat?"
Yes, you could try the code below.

Code: Select all

PivotTable pivottable=sheet2.PivotTables[0];
pivottable.PivotFields[0].NumberFormat = "0.0";
pivottable.PivotFields[1].NumberFormat = "0.00";


Regards,
Amy
E-iceblue support team

[Gary.zhang]

Hello chaitanya,

Has the code provided by worked fine for you? Has the issue been resolved? Could you please update the thread if convenience?

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support team