S
svictorov
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.
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.