![]() ![]() There is a property UsedRange that returns all the rows and cells that have been used. What we are interested in are rows and cells that have data. What this means is that the value returned by these properties represent the maximum rows and cells for worksheet. But these properties represent all the rows and cells used and unused. There are properties named Rows and Cells on Worksheet object. There are properties of Worksheet object that you can use to access row and columns. If you are working with some tabular form of data then sometime you want to figure out how many rows and columns are there in the worksheet and how you can iterate over each of those. Now that you have opened the workbook, next you want to access data in rows and columns. In my previous post, I described How to open excel file using.
0 Comments
Leave a Reply. |