Welcome Guest, Not a member yet? Register   Sign In
import excel sheet to mssql database in CodeIgniter!
#1

[eluser]Monisha[/eluser]
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

[eluser]mjsilva[/eluser]
Check here: http://www.techontour.com/applications/2...-with-php/

Or this: http://www.dbtube.org/ full appliance!

Not CI specific but should help.
#3

[eluser]mjsilva[/eluser]
Also already being discussed in forum: http://ellislab.com/forums/viewthread/121028/
#4

[eluser]Monisha[/eluser]
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' ??




Theme © iAndrew 2016 - Forum software by © MyBB