excel sheet read in php

[y_naga_malles_wara_rao]

Dear All,

I am Nagamalleswarar ao and i am new to this and i want to read the excel sheet and place it in an database so please help me.

Thank in advance,


Regards,
Malli.

[ronverdonk]

The answer greatly depends on your Excel version. Before Excel 2003 you could export the sheet as CSV file and import it into the database via load or a custom loader.
From Excel 2003 on you can export the sheet as XML and that, with some XML parsing code in PHP, makes it somewhat easier to import.

So, what Excel are you using?

Ronald :cool:

[bessie]

...jumping in here and I hardly know anything about programming but I just posted a question and in my post is the code for a registration form that uses csv.php and the data can be read in Excel 2003 in a csv file. Will this help Malli?

[NinethSense]

If you use PHP under Windows, you can use COM.
Eg: $word = new COM("excel.appl ication") // Look manual for more details

Other wize you will have to buy some libraries or you will have to make your own, which I conider is possible only for advanced users.