Import Excel Spreadsheet

Do something cool with CMS? Show us ...
This board is for 'Answers', and the discussion of answers... Not for questions.
Post Reply
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12709
Joined: Thu Mar 09, 2006 5:32 am
Location: Arizona

Re: Import Excel Spreadsheet

Post 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
ganeshXL

Re: Import Excel Spreadsheet

Post 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...
Post Reply

Return to “Tips and Tricks”