Need to write results in different sheets in same Excel file

Help
, ,
1

Hi All,

After filtering(sheet1) and removing duplicates in the results (sheet2) - I want to write in different sheets(Sheet1,Sheet2) in the same excel file.

Any one having solution for this one.

Thanks,
Bala

2

just mention “Sheet2” in writeRange and give same excel path
Cheers @Bala_Murugan_Kothand

3

here is a sample workflow you can refer!
Cheers @Bala_Murugan_KothandWriting in Different Excel Sheet.xaml (4.9 KB)

4

I have tried, its not working. Any other solution is available means kindly share it.

5

send me your workflow sample i’ll have a look?

6

Fine
–hope we have the sheet1 and sheet2 ready in excel once after filtering and removing duplicates and is read with READ RANGE ACTIVITY and obtained the datatable named dt1 and dt2
–now use a EXCEL APPLICATION SCOPE and pass the filepath of excel as input
and inside that use WRITE RANGE activity and mention the input as dt1 and enable add headers and mention the sheetname as “sheet1” or if we want we can mention different sheename as well
and another write range activity with input as dt2 and enable add headers property
and sheetname as “sheet2” or if we want we can mention different sheename as well

this will write the datatable back to the excel

Cheers @Bala_Murugan_Kothand

7

FilterInvoiceDataBasedOnCountry.xaml (37.3 KB)

8

image
image1600×900 117 KB

change sheet name here

9

you are using BuildDataTable inside foreachloop put it at the beginning
and let everything be same!
and change the sheet name @Bala_Murugan_Kothand

10

Hi Pradeep,

Thanks your solution, i’ll try it and let u know

1 Like