How can we extract data table from Google Spreadsheet which is in structured format?
(Webscrape is not able to recognize individual elements.)
I tried using Get OCR Text but that’s not feasible for a big excel report. Any idea how can we do it? (without downloading the excel)
I have also tried below method which gives us result,
Click on Spreadsheet
Send hot key (Ctrl + A)
Open excel in local system
Send hot key (Ctrl +V)
Process it further
but was looking for something which directly gives a datatable
Workaround: download the spreadsheet as Excel.