Set formatting when export to excel

AyumiS · October 2020

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?

anirudh · October 2020

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

AyumiS · October 2020

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

Answers