When exporting using an existing Excel file all formatting is preserved (column width, row heights, cell formatting, etc…) The only thing that isn’t being preserved is the conditional formatting.
When EnableStylesExport is turned on (True) the conditional formats are not in the file; however, the Excel Exporter did create some styling in the file as its default.
Attached is a zip file containing the source file (template) and 2 ouput files based on the EnableStylesExport value.
Version: 12.2.20122.2075
The Excel library does not currently support round-tripping conditional formatting information. I have forwarded this post to the Developer Support Manager to create a feature request on your behalf.
Thanks!
Hello,
I need information on the progress of this feature (PI13040065), it is very important in my project.
Thank You
Hello Pete,
I have logged feature request PI13040065 for “Preserving conditional Formatting of existing Excel file” on your behalf. Product team will review this new feature requests for development and chooses based on popular feedback from our customer base. If your feature is chosen for development, you will be notified at that time. Your reference number for this feature request is PI13040065.
I hope this helps.