Reading .xlsx

  • Thread starter Thread starter mavrick_101
  • Start date Start date
M

mavrick_101

Hi,

I have a web page, where users can upload excel sheet and the page will then
process the data (take data and insert into the table).

Its a simple excel sheet and not fancy stuff.

Can any one point me to a tutorial where I can learn how to open and read
the .xlsx files?

Thnx in advance.
 
In addition to the advice from Mark and Alexy, you can also get to the data
in another way. I am not recommending this route, as I think it is a waste
of time, but it would be one helluva learning exercise:

..xslx is a zip file If you want proof, copy an .xslx file and change the
extension to .zip. Then double click. See, I told you.

This means you can use a compression library and open the .xslx file. You
can then get at the actual data file(s) which are located at:

{filename}.xlsx\xl\worksheets

They are .xml files. For info on the schemas for Office 2007, start here:
http://msdn.microsoft.com/en-us/library/aa338205.aspx

The easier way is to follow the advice already given. ;-)

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
 
Back
Top