Generate an excel file from DynamicDataRow

Unknown

Generate an excel file from DynamicDataRow

Unknown

Hi,
Is there any easy way to generate an excel worksheet file from a DynamicDataRow?
Thanks

Unknown

Hi ildanny,

To generate excel data from an object, I recommend this documentation:

https://documentation.decisions.com/docs/create-excel-data-object-data

I hope this helps!

Regards,

Andrew Paterson

Unknown

[quote=andrew.paterson@decisions.com]Hi ildanny,
To generate excel data from an object, I recommend this documentation:
https://documentation.decisions.com/docs/create-excel-data-object-data
I hope this helps!
Andrew Paterson[/quote]

No. It was not helpful because I dont want to generate a csv file. Instead I want to add a worksheet to an existing workbook.

I know how to generate an excel file from an entity.

My problem here is that my object is a DynamicDataRow.
I dont know the number of column, so dealing with that makes the process extremely slow. It takes hours to export 1000 rows.

At the moment, I am using "set value in row".
So, I was wondering if theres a step specifically to print an entire DynamicDataRow at once

Unknown

Hi,

If you would like to add a worksheet to an existing excel file, we provide an Add Worksheet step. This can be found in the step catalogue under Integrations > Excel and CSV > Add Work Sheet.

Also for printing an entire row at once, I may need some more clarification as to where you would like this to print. Are you wishing to display this in plain text on the screen or to a file?