Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-21 12:42 PM
Hi Team,
I am trying to read excel as collection and that particular excel is having 110 rows. When I use MS Excel VBO - Get Worksheet As Collection, Get Worksheet Range As Collection and Get Worksheet As Collection(Fast), all these actions are reading only the first three rows from that worksheet and it is skipping the remaining rows.
Can someone help me on this?
I am trying to read excel as collection and that particular excel is having 110 rows. When I use MS Excel VBO - Get Worksheet As Collection, Get Worksheet Range As Collection and Get Worksheet As Collection(Fast), all these actions are reading only the first three rows from that worksheet and it is skipping the remaining rows.
Can someone help me on this?
------------------------------
Thanks & Regards,
Kathiresh Yoganathan
Application Developer
IBM
------------------------------
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-21 01:29 PM
I figured out the issue, There is a formula in 4th row 10th column which is not in a proper format.
------------------------------
Thanks & Regards,
Kathiresh Yoganathan
Application Developer
IBM
------------------------------
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-21 12:50 PM
Hi K,
Sounds like there could be some bad data in your XL. If you step into the VBO action 'Get Worksheet As Collection' and run the code stage, does it present some sort of error there?
If you convert your XL to a CSV and retry the 'Get Worksheet As Collection' against the CSV, does that work any better? If not: does the CSV show any invalid values if you browse it with Notepad++? (don't use MS Notepad for this check...)
Happy coding!
Paul
Sweden
Sounds like there could be some bad data in your XL. If you step into the VBO action 'Get Worksheet As Collection' and run the code stage, does it present some sort of error there?
If you convert your XL to a CSV and retry the 'Get Worksheet As Collection' against the CSV, does that work any better? If not: does the CSV show any invalid values if you browse it with Notepad++? (don't use MS Notepad for this check...)
Happy coding!
Paul
Sweden
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)
Paul, Sweden
(By all means, do not mark this as the best answer!)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-21 01:05 PM
No, The excel workbook that I am reading is having four sheets and the sheet which I am trying to read is having some formulas(reading values from other sheets). I am not getting any error message while reading the excel file. It is reading only first three rows along with column names and skipping the remaining 107 rows.
------------------------------
Thanks & Regards,
Kathiresh Yoganathan
Application Developer
IBM
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-21 01:08 PM
Hi Kathiresh,
What is the range you are passing into the Get Worksheet As Collection action? I believe you taking the row count and then using it to determine the end row.
What is the range you are passing into the Get Worksheet As Collection action? I believe you taking the row count and then using it to determine the end row.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-21 01:29 PM
I figured out the issue, There is a formula in 4th row 10th column which is not in a proper format.
------------------------------
Thanks & Regards,
Kathiresh Yoganathan
Application Developer
IBM
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-10-21 07:54 PM
Thanks for letting us know the resolution.
When we deal with excel automaton most of the issues and solutions lies within excel.
It's always recommended to know excel better as it will make lives easier.
When we deal with excel automaton most of the issues and solutions lies within excel.
It's always recommended to know excel better as it will make lives easier.
