reading data from excel

gil.silva

Active Member
Hello nbargaje,
When you use the action Get Worksheet as Collection, all the 'visible' rows will show up.
You can use the action "Remove Empty Rows" in Utility - Collection Manipulation to get only your results!
 

nbargaje

Member
@gil.silva
No. previously it was working fine. i was able get data for only those rows which has data in excel(using action Get Worksheet as Collection )e issue

and you can also try and i hope you will get data for those only.

few days before support guy did some changes in database, since facing the issue.
 

jrprajapati

New Member
I am having the same problem. I have 27 rows of data but my collection is having 31 rows( 4 empty rows). What is the reason for that?
it was working find and was readind 27 rows only before I edited the worksheet.

Can anyone please help here.
thanks
 

nbargaje

Member
if possible copy and paste that data in new excel and read that excel.

if not then call remove empty rows from excel and then read data.

please let me know if that helps.

Thanks,
Nitin
 
Top