Skip to main content
marcot0005
marcot0005
February 24, 2022
Question

Export to Excel

  • February 24, 2022
  • 4 replies
  • 0 views

I have a grid that has been populated by a map in a local variable and I would like to export that data to an excel file. The data isn't in a record, so I can't set showExportButton to true. It isn't in a datastore entity, so I can't use exportDataStoreEntityToExcel, and it isn't a process report so exportProcessReportToExcel is out. Is there any other way to export this grid's data (or I suppose just the local variable itself)? 

4 replies

mikes0011
mikes0011
Brainy
February 24, 2022

Assuming you can map the data to an existing (or new) CDT, you could pass the data into a process and utilize the Export CDT to Excel node from the Excel Tools plug-in, which in spite of being (officially) Deprecated, still works, and does not yet have any functionally sufficient replacement available.

The Expression Guru
marcot0005
marcot0005Author
February 24, 2022

I don't suppose you have any tips on how to use that node? I keep getting "An error occurred in executing an Activity Class." when I run it. I clearly don't know what I am doing when it comes to configuring it and the error message isn't helping me out much. 

mikes0011
mikes0011
Brainy
February 24, 2022

That's a generic error message, so no real clues without more details - but if you haven't already, check the tomcat.stdout log file and see if more detail is provided there.

The Expression Guru
Terms & ConditionsAccessibility statement