Set formatting when export to excel

Highlighted
Occasional Contributor

Set formatting when export to excel

When end user export data to Excel, both number and text are right-aligned.

My end user want to set text is left-aligned and number is right-aligned.

Is it possible to set export formatting of each line item when export to excel?

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Set formatting when export to excel

Hi,

This is not possible using Export. But have you considered using the Excel Add-in and connecting the add-in to this module. That way, data can be pulled and formatted in any desired way

https://help.anaplan.com/anapedia/Content/Extensions_and_Addins/Excel4_Add-in.htm

Regards,
Anirudh
Highlighted
Occasional Contributor

Re: Set formatting when export to excel

Thank you for your advice.
We haven't tried excel add-in, but will challenge it