Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Code to determine, no of excel worksheets, no. of rows  in excel sheet.

Posted on 2013-01-21
2
Medium Priority
?
181 Views
Last Modified: 2013-02-05
Assuming header as first row in excel sheet.
How to determine no. of worksheets in excel sheet.
How to read every row of every worksheet.
0
Comment
Question by:searchsanjaysharma
2 Comments
 
LVL 15

Accepted Solution

by:
Minh Võ Công earned 1000 total points
ID: 38804394
You can use Microsoft.Office.Interop.Excel to read data from exel

http://stackoverflow.com/questions/3935514/finding-and-extracting-data-from-excel
0
 

Author Closing Comment

by:searchsanjaysharma
ID: 38857862
tx
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question