Export to Excel formatting.

[rohitians]

Hello,

I want the export the excel option to send the report in particular format do we have any option where in we can edit the same as we want the report to be seen in excel...

Thanks and Regards,

Rohit Yadav

[#2]

You can use Macros (if you know VBA Excel). What you want to say" particular format" ?

[rohitians]

Hello,

Basic display format like cell spacing bg color...basic stuff which makes the report eye catching..

Have u done this.

Thanks and regards,

Rohit Yadav

[sushil353]

try to get someting from API Guide

[rohitians · Accepted solution]

Hello,

In the chart properties of the pivot table, tab 'style', select 'indent mode'.

Please note that most of the formatting gets lost when exporting to Excel, but at least it is not presented as a straight table anymore ...

Thanks and Regards

Rohit Yadav