Page 1 of 1
Re: Import Excel Spreadsheet
Posted: Thu Jul 20, 2006 5:11 pm
by Dr.CSS
have you tried open office, they have a way to export Power Point as html, maybe Excel too, example on this page second box down....
http://www.multiintech.com/index.php?pa ... d_w_images
Re: Import Excel Spreadsheet
Posted: Fri Jul 28, 2006 4:17 am
by ganeshXL
Are you talking about XLS-tables -> HTML-tables, or XLS-file -> database table?
Importing tabular data is fairly easy with PHP. Just make sure you convert your .xls file to a tab-delimited text file or .csv first.
There are special PHP functions for handling such data:
http://ca.php.net/fgetcsv
Also, if you're using phpmyadmin, there's text-import options to import stuff directly to a table.
If you're talking about just importing XLS-tables and convert to HTML-tables... there are some "cleaner" applications out there, that will strip the MS-HTML from garbage (unneccessary) tags, CSS, attributes and such...