exporting excel sheet to database

[murali (Socoolgmk)]

Hi, i’m new to yii, i’m having an excel sheet with 'n’rows ,that need to be added to the database.Can anyone suggest the best way to do it.

any help from your side is highly appreciated.Thanks in advance.

[jazmanister]

So you’re just looking to populate your database entirely independent of anything Yii-related? If so, save your excel file as CSV(comma separated values), then look at fgetcsv(). You can write a simple little script that grabs each row into an array. Then just do a normal db insert.

[murali (Socoolgmk)]

So you’re just looking to populate your database entirely independent of anything Yii-related? If so, save your excel file as CSV(comma separated values), then look at fgetcsv(). You can write a simple little script that grabs each row into an array. Then just do a normal db insert.

Thanks for your reply.