467,926 Members | 1,744 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,926 developers. It's quick & easy.

Get rowcount of a excel sheet

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
  • viewed: 2216
Share:
2 Replies
1GB
Hi. I believe you will have to search for the first blank row using ole automation objects
Mar 16 '07 #2
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.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
12 posts views Thread by elziko | last post: by
3 posts views Thread by | last post: by
3 posts views Thread by implicate_order | last post: by
3 posts views Thread by pleaseexplaintome_2 | last post: by
13 posts views Thread by chuckie_9497 | last post: by
reply views Thread by =?Utf-8?B?YW5hbmQgcmFtYWNoYW5kcmFu?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.