Skip to main content
Inspiring
May 17, 2021
Question

Export Data Store Entity to Excel formating

  • May 17, 2021
  • 1 reply
  • 0 views

Hello, 

Using Export Data Store Entity to Excel is there a way to be configured to not erase the current applied styles and formatting of the Excel File which is updating ?

Currently of there is some kind of colors set-up it eliminates everything. 

    1 reply

    csteward
    Brainy
    May 17, 2021

    Unfortunately there is no way to configure Export DSE to Excel in such a way that it doesn't entirely 'cleanse' the document.  This node will always overwrite formatting.  The only way I've been able to export to excel while retaining all formatting and data types is with the deprecated Export CDT to Excel node (Excel Tools plugin).  We are hoping to see something to cover that functionality in the base product eventually..  Here's one of my threads related to Excel export options.