![]() |
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. |
All times are GMT +1. The time now is 04:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com