Reading from and Writing to Excel in PHP
One interesting implementation for the latest project I’ve got is to read some Excel file using PHP and stores the data in MySQL database, then exports the data to Excel, PDF or HTML format. There are so many various solutions. After I searched many websites and forums, I got some answers – use PHP Excel Praser Pro (USD 99.95) for reading Excel, Spreadsheet_Excel_Writer (Freeware) for exporting to Excel format, FPDF (Freeware) for exporting to PDF, and of course, use PHP itself for exporting HTML format. I may write an article for Excel reading and writing using PHP after I get some experiences. If anyone has other suggestions or ideas, please don’t hesitate to share them.