Get rowcount of a excel sheet

surekhads

Hi all,
I have developed a project for extracting data from a HTML file and export that data to a excel sheet. I am storing that extracted data to the db. And then I am exporting that data to excel sheet. But, the data is getting overwritten in that excel sheet each time. I want to get rowcount from excel sheet & then append new data to that sheet. I tried to connect to excel sheet as a database. But, after that I have no idea how to extract rowcount from that sheet.
If somebody helps me, i will be grateful for him/her.

surekha

Mar 16 '07 #1

willakawill

Hi. I believe you will have to search for the first blank row using ole automation objects

Mar 16 '07 #2

RookieDan

Hi all,
I have developed a project for extracting data from a HTML file and export that data to a excel sheet. I am storing that extracted data to the db. And then I am exporting that data to excel sheet. But, the data is getting overwritten in that excel sheet each time. I want to get rowcount from excel sheet & then append new data to that sheet. I tried to connect to excel sheet as a database. But, after that I have no idea how to extract rowcount from that sheet.
If somebody helps me, i will be grateful for him/her.

surekha

Would you like to use VBA for this?

Mar 16 '07 #3