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

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

Hi @Shoebmd

You try filtering the file using Directory.GetFiles

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


1 Like