Extraction of sheets in a single file

Help Studio
, ,
1

Hello All, I have created a workflow in which I am extracting data from email body to different excel sheets. Each excel sheet contains a table with headers. Later while merging them, the data are appending one after another but the header in common for all. The tables are having same headers, but I want them to be separate also a line space between the tables…

2

@Pranay_Kumar_Bose

Yes bro you can do merging the data into single sheet

Regards

3

While using write range workbook, you can specify from which cell it should start.

So while writing the datatable you extracted, the first will be in cell A1, the second will be in A+(dt1.RowCount+2).ToString and so on

4

Hi @Pranay_Kumar_Bose

Bro I have uploaded the zip file please check I have changed the program as per your requirement
DataTable (2).zip (216.0 KB)

Hope it works!!

5

Thanks Varun @vrdabberu
Its working as required and is fulfilling the requirements.
It is a great save to me.
Also, thanks for the prompt response.

6

@Pranay_Kumar_Bose

Thank You bro

Happy Automation!!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.