LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Parsing in Excel? DavidMunday Excel Worksheet Functions 1 August 4th 10 04:34 AM
How do I delete the test documents in my recent documents? mrjack Excel Discussion (Misc queries) 1 February 14th 10 04:08 PM
turning 2007 excel documents into 2003 excel documents La Shawn Dillon Excel Discussion (Misc queries) 2 February 15th 08 11:23 PM
excel documents won't open from my documents folder Paul1961 Excel Discussion (Misc queries) 2 January 15th 06 05:31 PM
Excel Documents Don't Appear in My Recent Documents Addi Excel Discussion (Misc queries) 4 July 24th 05 09:43 PM


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"