In the Appian User Interface, I have a grid with colored rows. My requirement is that when I click on 'Export to Excel' from the grid, the downloaded Excel file should retain the same row colors. How can I achieve this
I am uploading image
Discussion posts and replies are publicly visible
As far as i know, you can't export the colors of your grid to excel
Is there any alternative method with customization can we achieve?
Appian's default Excel export doesn’t preserve grid row colors. To achieve this, use the "Export Data Store Entity to Excel" Smart Service with a pre-styled Excel template. Prepare your data in a Data Store Entity, define colors/styles in the template, and map them during export.https://docs.appian.com/suite/help/24.4/Export_To_Excel_Smart_Service.htmlhttps://docs.appian.com/suite/help/24.4/Export_To_Excel_Smart_Service.html#exporting-data-to-a-formatted-excel-sheet
As mentioned in your link, I believe the Export DSE to Excel Node will actually overwrite the formatting in any cells that it's used to add data to (and that's beyond how much of a pain it is to create a copy of your template file first so you don't accidentally overwrite it, since they never added a Base Template option).
I think OP might need to try with the JSON to Excel smart service or one of the deprecated Excel Tools smart services (CDT to Excel or SQL to Excel), though these merely don't overwrite formatting, but nothing I know of really allows addition of dynamic formatting.
Is it possible to export data from a grid to Excel using Sql to Excel plugin . Note- I am using record based approach .
I'd actually recommend looking into the Export JSON to Excel smart service (it's by itself in a relatively newer plug-in). This will allow you to assemble arbitrary dictionaries of data and pass them into an excel - it should work just fine for Record Type data as well, you'd just need to query it and add whatever column values you want to a Map that you then wrap in JSON.
No, you cannot hook the SQL to Excel plug-in directly to a record grid export; use the built‑in record Export to Excel instead.May i know your actual requirement?
bulit in record Export to Excel I can not use as I am getting the queried data in a local variable.
requirement - I need to export the grid data to an Excel using SQL to Excel tools .And I am using record based approach . Few of the grid columns are also coming from relationships.
Sharda said:I am getting the queried data in a local variable.
I'm not sure if you saw my suggestion in my earlier reply above, but it should work well for this use case.