Write range is pasting a blank dt

hi,
I have scraped data from an excel sheet and output it to dt. I then processed to write range to another dt but it’s not pasting and producing a blank spreadsheet with no data.
i have attached my code
Main.xaml (30.3 KB)

1 Like

Hi

Pls ensure that read range has correct sheet name
And I hope you have used this sequence

—use excel application scope and pass the file path and inside the scope use a READ RANGE activity and get the output as dt

—the use WRITE RANGE ACTIVITY from workbook activities where mention the filepath and sheetname and pass the same dt as input and enable add headers

And I saw your code I could see you were using remove column in the datatavle
Pls ensure there are few more columns apart from the mention one else it will paste black table only

Cheers @Rowley101

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