RE: [PHP] reading excell and writing to text file..
Hey there... Are you using a windows server? If so, I can provide you with code examples as to how to select fields and write new excel docs using the COM stuff built into windows. For linux, things get a little bit more complicated -- really, you just need some sort of external app to do the conversion. Something like this might help: http://chicago.sourceforge.net/xlhtml/ -- jon -Original Message- From: Andrew Kwiczola [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 11:47 AM To: '[EMAIL PROTECTED]' Subject: [PHP] reading excell and writing to text file.. I was wondering a good place I could get started on reading excel spreadsheets in PHP ive seen a couple of things out there that will take data from the web and transform it into a .xls file. I was wondering if I could take a XLS file with php and read it, and rip out certain data from it :-) but just knowing how to read it to the screen would be enough to get me going. Thanks! Dragoonkain --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.551 / Virus Database: 343 - Release Date: 12/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.551 / Virus Database: 343 - Release Date: 12/11/2003 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] reading excell and writing to text file..
Andrew Kwiczola wrote: I was wondering a good place I could get started on reading excel spreadsheets in PHP ive seen a couple of things out there that will take data from the web and transform it into a .xls file. I was wondering if I could take a XLS file with php and read it, and rip out certain data from it :-) but just knowing how to read it to the screen would be enough to get me going. Thanks! To actually read the XLS file, you'll probably need to use COM. Or if you convert / save-as the file to a .csv, then you can read it as a normal text file. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] reading excell and writing to text file..
[snip] I was wondering a good place I could get started on reading excel spreadsheets in PHP ive seen a couple of things out there that will take data from the web and transform it into a .xls file. I was wondering if I could take a XLS file with php and read it, and rip out certain data from it :-) but just knowing how to read it to the screen would be enough to get me going. Thanks! [/snip] you could use the excel com object if you are on windows http://fi.php.net/manual/en/ref.com.php I know there is a pear package to write excel files but not sure if there is one to read them yet. If you can use perl you can use Spreadsheet::ParseExcel, I have used it before and it works really well. http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2602/ParseExcel.pm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php