Forum Discussion
2 Replies
Sort By
- Colin_McCraeCommunity Hero
And if you're using Excel as a COM object you either stop when you read in a blank value (you're doing keyword driven tests so you must be reading these in right?)
Or if you want, the Excel sheet has a UsedRange property you can read in advance which tells you how many active rows it is regarded as having.
https://msdn.microsoft.com/en-us/library/office/ff840732.aspx
Of course, if you have blank lines within that used range, you'll have to factor something into your code to account for that.
Related Content
Recent Discussions
- 5 hours agodhundley