By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,280 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,280 IT Pros & Developers. It's quick & easy.

Get rowcount of a excel sheet

P: 1
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
Share this Question
Share on Google+
2 Replies


100+
P: 1,646
Hi. I believe you will have to search for the first blank row using ole automation objects
Mar 16 '07 #2

P: 8
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

Post your reply

Sign in to post your reply or Sign up for a free account.