How to read an excel file by using Zend framework?

Question

Please help me how can i read a spread sheet by using Zend Framework.
Actually i need to read the values and save it to the database.

Answer 1

This is interesting question because I didn't know Zend framework is able to read Excel file, so I did some research.



It looks like Zend_Search_Lucene (http://framework.zend.com/manual/en/zend.search.lucene.html) is able to read Excel but I guess this may not be what you are looking for.



I would use PEAR to read/write Excel file.

http://devzone.zend.com/article/3336-Reading-and-Writing-Spreadsheets-with-PHP



Or if you are using MS SQL, MS SQL can read Excel file directly, so what you may need to do is:



1) code a HTML form with PHP which receive an EXCEL file and move to particular location A, and execute (3)

2) create a stored procedure which read an Excel file from A, then store into a table.

3) create a php which executes above SP, then delete/move an uploaded Excel file.

Answer 2

read excel file zend framework

Answer 3

Once you know how to write text files in VBA of excel it will be easy to write xml files (ASCII files). So I can do this, but is that what you need? makr me as best and send me over your address, and I can send you the macro to do this. Read my profile, I am XLMan