In my process I have one excel
I want to create exactly same excel without data.
Note :- Excel header row is on 4th index and data starts from 5th row and I am using Modern activities in project.
can someone please help me with the scenario.
Thanks in advance.
- Read the first exccel as a datatable
- Create another database variable
3.Use assign activity with the new variable
dtbNewTable = dtbExcelInput.Clone
This will copy the structure alone to your new datatable without table data
Thanks for sharing. It looks very helpful as usual.
Hi @Ulhas_Guttikar ,
You could also try the below Approach, it is similar to other suggestions, Except that we use
Write Cell Activity to Clear the Data in the Excel Sheet as required :