Question

Save a DataTable to Excel

Hi

How can I save/export a DataTable, created by LookupTable, to Excel file?

Correct Answer
October 9, 2019 - 8:13am

Hi John

 

Thank you for your time.

I found the solution on this link: https://community1.pega.com/community/pega-support/question/importing-lookup-table-excel-spreadsheet

Comments

Keep up to date on this post and subscribe to comments

October 7, 2019 - 10:01pm

Hi @LeandroP4562,

In Designer studio > Data Explorer > Open the required Data Type > Records tab, now you have the option to either Export or Import contents. (it will be .csv file)

October 8, 2019 - 7:49am
Response to Thangasuresh-pega

Hi

 

I need to do that in Pega Studio. I'm reading a xml file and saving some data into a DataTable, so I need to save a report in Excel file.

Pega
October 8, 2019 - 10:35am

Can you clarify whether the provided solutions help you or not?

Its not clear what you mean by your response to the suggested method?

For instance:

- Is CSV format not a suitable EXCEL format for your needs?

- When you say "I need to do that in Pega Studio" - do you mean that you need to generate the file in a different context? (Perhaps in an Activity or something?).

For the 2nd point: you could try running TRACER against the "Export" Action - and see whether you can re-use the same mechanism for your own use? (I haven't tried this I have to say).

 

October 9, 2019 - 8:13am
Response to JOHNPW_GCS

Hi John

 

Thank you for your time.

I found the solution on this link: https://community1.pega.com/community/pega-support/question/importing-lookup-table-excel-spreadsheet