Excel to PHP Magic

[greg@hassefamily.com]

I've converted my Excel file with "ExcelMySQlMagic" to a mySQL DB, then I converted the mySQL DB to a PHP Magic Plus file with "Mysql2PHPMagic Wizard", however, I don't have any fields in my PHP Magic project. The Excel columns appear to convert OK to the mySQL DB.

Any suggestions?

[cu-it-up]

Humm,, did you select all the fields when using Mysql2PHPMagic. I think there is a selection in there to pick fields to convert.

[greg@hassefamily.com]

I figured this out on my own. When I converted from Excel to mySQL the worksheet name in Excel had a space in the name that did not convert to an underscore. That messed up the conversion to PHPMagic. Bottom line - make sure there are no spaces in the worksheet name!

[JasonDean]

Excel to MySQL Magic is a very easy to use automation tool that can convert any MySql database into MS Excel spreadsheets or convert any Microsoft Excel spreadsheets into MySQL database.

Utilizing the easy to use Wizard style interface, Just follow the simple screens and let the wizard automatically do all the work. This useful tool can save you tons of your valuable time , and is suitable for both beginners and experienced users alike.

Supporting many advanced features like selecting certain tables or columns to convert, Conversion Scheduling, Splitting Large MySQL tables.

[GarryBenjamin]

The easiest thing to do would be to output it as a CSV file, which can be done with the fputcsv() function. Excel can easily read it, though there would be no formatting. If you need a true Excel file, then you'll probably want to look for some 3rd-party PHP classes/functions. (The PEAR repository has the Spreadsheet_Excel_Writer package, for instance.)