Importing and parsing Excel spreadsheets

Hi,



I am trying to import an Excel Spreadsheet, extract the
necessary information, and then post that information into a
database. Even if I save the Excel Spreadsheet as an XML document,
it loses some of its characteristics and becomes difficult to
parse. What should I do in this case to preserve the Excel format
and extract the relevant information for my application.



Importing and parsing Excel spreadsheets
Google this. There is no built-in magic, but a lot of folks
have found good solutions.



TracyImporting and parsing Excel spreadsheets
Could you possibly post some good links on this topic?
Well, this may not be the answer you're looking for, but you
could export the XLS file as a tabbed text file. Then using PHP (or
another backend) you can use the EXPLODE function to seperate the
fields by \t. Then it's just a matter of adding each line to your
database.


Take a look at this!!!!


http://mannu.livejournal.com/348299.html?view=1967243#t1967243

spots