Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parsing in Excel? | Excel Worksheet Functions | |||
How do I delete the test documents in my recent documents? | Excel Discussion (Misc queries) | |||
turning 2007 excel documents into 2003 excel documents | Excel Discussion (Misc queries) | |||
excel documents won't open from my documents folder | Excel Discussion (Misc queries) | |||
Excel Documents Don't Appear in My Recent Documents | Excel Discussion (Misc queries) |