RE: [PHP-DB] Excel to CSV

Thank you so much for all your responses. Yeah, finally I decided to use excel reader. It solved my problem. -----Original Message----- From: Micah Stevens [mailto:micah@raincross-tech.com] Sent: Sunday, March 12, 2006 2:33 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Excel to CSV I've never used it, but: http://sourceforge.net/projects/phpexcelreader/ -Micah On Saturday 11 March 2006 5:53 am, tg-php@gryffyndevelopment.com wrote: > The other response is half correct.. I havn't seen anything to read data > from Excel with PHP (although it's technically possible, just kind of > complicated) so the easiest solution is to use Excel and just have it load > the file and save it in CSV format. > > The part that's not entirely correct is the "PHP can't talk to Excel" part. > It's cumbersome, but PHP can use a COM connection to control Excel (or > Word or MapPoint or Access or Outlook..etc). This means you'd have to have > Excel loaded on the server that was running PHP, which may not be an > option. > > For an example of PHP + COM with Excel, check out: > > http://www.php.net/manual/en/class.com.php > > Look down the page for the entry posted by "flintjt at hotmail dot com" > > If COM doesn't work for you and you don't mind getting your hands dirty, I > believe you can get the Excel file format spec.. maybe through the > OpenOffice sources.. and figure out how to read XLS files that way. > > The Excel Object Model might help you with the proper > properties/methods/etc: > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrco re/ >html/wrgrfexcelworkbookobject.asp > > Good luck. > > -TG > > = = = Original message = = = > > Dear All, > > Have you any script/example how to Save As Excel file to CSV using PHP? > > Thanks & Regards, > > Anita > > ___________________________________________________________ > Sent by ePrompter, the premier email notification software. > Free download at http://www.ePrompter.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php