Hi there
I'm working on a VB project where I'm extracting data from an excel spreadsheet. My problem is that the way the excel spreadsheet has been laid out is making it difficult for me to get at this data particularly as my skills with excel access is minimal. Anyway, the first 3 rows of the spreadsheet constitute a header with a title etc in them. Then the spreadsheet is set out so that it hides rows, for example the first visible row to me after Row 3 of the header is 302 therefore rows 4 to 301 have been hidden. Now, the project only requires me to extract the information from these visible rows, however, the spreadsheet is to be updated regularly so this means the first visible row will change with each update that means I cannot hardcode any row numbers into VB. So what I need is code that can find the first visible row number of a spreadsheet and tell me the last row with some data in it. Any help with this would be greatly appreciated. As I say my Excel handling skills are limited hence the struggle with how to get this data. Thanks in advance for your time.
I'm working on a VB project where I'm extracting data from an excel spreadsheet. My problem is that the way the excel spreadsheet has been laid out is making it difficult for me to get at this data particularly as my skills with excel access is minimal. Anyway, the first 3 rows of the spreadsheet constitute a header with a title etc in them. Then the spreadsheet is set out so that it hides rows, for example the first visible row to me after Row 3 of the header is 302 therefore rows 4 to 301 have been hidden. Now, the project only requires me to extract the information from these visible rows, however, the spreadsheet is to be updated regularly so this means the first visible row will change with each update that means I cannot hardcode any row numbers into VB. So what I need is code that can find the first visible row number of a spreadsheet and tell me the last row with some data in it. Any help with this would be greatly appreciated. As I say my Excel handling skills are limited hence the struggle with how to get this data. Thanks in advance for your time.