473,322 Members | 1,259 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Parsing Excel documents with C#

Hello everybody,
here is a question I have to deal with :

In brief, I have an Excel document which consists of 3 sheets ( with
the same names for each document ).
The document always has fixed format except for number of rows, but it
doesn't have a correct table
format. I mean that each sheet has its own header ( filled with
insignificant information ) and table of
important data after header.
How I can get an access to the data of the sheet row by row or is that
possible to use
SQL statements to get the data from table inside of Excel sheet. Note
that the sheet doesn't have a correct table structure but I suppose it
can't be represented as table of strind fields, but it's not a good
idea because there are many formulas inside of the document.

Thanks in advance.

Oct 16 '06 #1
2 2046
Here's a basic explanation:

http://www.codeproject.com/csharp/csharp_excel.asp

Pete Davis

<sv*******@mail.ruwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hello everybody,
here is a question I have to deal with :

In brief, I have an Excel document which consists of 3 sheets ( with
the same names for each document ).
The document always has fixed format except for number of rows, but it
doesn't have a correct table
format. I mean that each sheet has its own header ( filled with
insignificant information ) and table of
important data after header.
How I can get an access to the data of the sheet row by row or is that
possible to use
SQL statements to get the data from table inside of Excel sheet. Note
that the sheet doesn't have a correct table structure but I suppose it
can't be represented as table of strind fields, but it's not a good
idea because there are many formulas inside of the document.

Thanks in advance.

Oct 16 '06 #2
Thanks a lot !!!
Very useful article.

"Fredo писал(а):
"
Here's a basic explanation:

http://www.codeproject.com/csharp/csharp_excel.asp

Pete Davis

<sv*******@mail.ruwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hello everybody,
here is a question I have to deal with :

In brief, I have an Excel document which consists of 3 sheets ( with
the same names for each document ).
The document always has fixed format except for number of rows, but it
doesn't have a correct table
format. I mean that each sheet has its own header ( filled with
insignificant information ) and table of
important data after header.
How I can get an access to the data of the sheet row by row or is that
possible to use
SQL statements to get the data from table inside of Excel sheet. Note
that the sheet doesn't have a correct table structure but I suppose it
can't be represented as table of strind fields, but it's not a good
idea because there are many formulas inside of the document.

Thanks in advance.
Oct 17 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Phil Powell | last post by:
What would one best recommend to parse an existing Excel spreadsheet (was done in Excel 97 or 2000 not sure to be honest)? I am looking for the most practical way of parsing an existing...
16
by: Terry | last post by:
Hi, This is a newbie's question. I want to preload 4 images and only when all 4 images has been loaded into browser's cache, I want to start a slideshow() function. If images are not completed...
1
by: c duden | last post by:
Excel won't allow documents to be linked to a worksheet in office 2000 when using C# to create an add-in. The following code snippets are what was used in the attempts (there are more...
2
by: Krish | last post by:
This is my first attempt, please bear. I referenced Excel 10.0 Object from VS .NET IDE, I think this creates Interop Object for Excel. I have the following code. ------code start---- ...
1
by: Bernd Muent | last post by:
Hi together, I am using the following code in Visual Basic to open Word or Excel applications: Word: Dim w As Word.Application w = CType(CreateObject("Word.application"), Word.Application)...
4
by: Lewis Edward Moten III | last post by:
I have a file that users can download through a web page protected by forms authentication: Download.aspx?ID=45 and within that file ... FileInfo fileToDownload = new FileInfo(fileName);
14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
5
by: randy | last post by:
Can some point me to a good example of parsing XML using C# 2.0? Thanks
0
by: sandervanee | last post by:
Hello, I am trying to export several Access 2003 select queries to Excel 2003 using an Access macro. I'm using the macro command "TransferSpreadsheet" to export the queries. This going quit well,...
3
by: waldopat | last post by:
Hi all, I have an excel doc that has some information about various countries and I want to get a list of all the countries, which is in Column A. But, when I try to iterate over column A, I get...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shllpp 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.