Hi. Is there a way to maintain the formatting of a column when exported to Excel? For instance, I changed the format to 1'000.00 in the Purchase Amount column. When I open the exported Excel file, the formatting is gone. Any guidance is appreciated. Thanks.
I use Python scripts to format generated Excel spreadsheet as required - Excel has a bad habit of formatting and presenting data as it thinks it should!
So I have a folder for Python scripts and run this as a process from EasyMorph on a folder basis or an individual file basis to set the column format options (currency, numbering, accounting, date etc.), bold column headings and totals, freeze the top row etc.