This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
July 28, 2009 10:02am
Subscribe [1]#1 / Jul 28, 2009 10:02am
Hi..
I am new to CodeIgniter. My client wants to import the Excelsheet directly to MSSQL database rather thn submitting each and every product detail. The Excel file they are using has multiple sheets and so many columns. So my functionality should be like uploading an excel file and validate it, then the every sheet should create a table in database and first row (column name) becomes the table fields.
anybody can suggest what should I do?
#2 / Jul 28, 2009 11:04am
Check here: http://www.techontour.com/applications/2007/10/24/import-excel-file-to-mysql-with-php/
Or this: http://www.dbtube.org/ full appliance!
Not CI specific but should help.
#3 / Jul 28, 2009 11:48am
Also already being discussed in forum: http://ellislab.com/forums/viewthread/121028/
#4 / Jul 29, 2009 8:07am
Thanks for reply ... i’ll look forward it..
I google the same issue and come to know about ‘phpExcelReader’ and ‘Excel Reader Class - library’
But not even working ... Its showing error message in controller file as below:
Message: Undefined property: myexcelreader::$Excel_reader
any idea how to solve this errors?
or any body tried out ‘phpExcelReader’ and ‘Excel Reader Class’ ??