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?
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
Thank you for your advice.
We haven't tried excel add-in, but will challenge it0