Extract data from open excel file, used data scraping but only initial data getting

[Shoebmd]

Hi guys

I want to extract data from a open excel file and write in one excel file

The excel file is random name , thats why i used data scraping on it but its reading only 30 rows not entire sheet

How to do this

[pravin_calvin (pravin kumar)]

Hi @Shoebmd

You try filtering the file using Directory.GetFiles

And You Read range to read the excel and Writerange to the Specfied path!

Regards