Advantage to parsing Excel Spreadsheet data vs. CSV?

Posted by john on Stack Overflow See other posts from Stack Overflow or by john
Published on 2009-06-19T16:31:32Z Indexed on 2010/05/20 17:10 UTC
Read the original article Hit count: 221

Filed under:
|
|
|

I have tabulated data in an Excel spreadsheet (file size will likely never be larger than 1 mb). I want to use PHP to parse the data and insert in to a MySQL database.

Is there any advantage to keeping the file as an .xls/.xlsx and parsing it using a PHP Excel Parsing Library? If so, what are some good libraries to use?

Obviuously, I can save the .xls/.xlsx as a CSV and handle the file that way.

Thanks!

© Stack Overflow or respective owner

Related posts about php

Related posts about csv