How to create an excel sheet in the assist edge code itself and perform row ,column insertion with data from a list or data table?

1

Creation of excel sheet during the execution of workflow and updating the excel sheet with data from a list or datatable. How is it possible?

2

Hi,

First create a data table using Create Datatable
Insert rows in the data table
Post that export the data table

Regards,
Amit

3

I have already followed these steps but in my process i need to Add data in row of Created Data Table by looping it and after that i need to export main Data Table to Excel but when i am exporting it to excel it exporting only last looped data not whole Data Table that i have created. It is always overwriting the last iteration data.

4

@govind_chaudhary
Why do you have to loop it.
You can make use of Add Row Activity.