RE: [PHP] MySQL to Excel with mutiple sheets
Ha ha... Thanks... I realize it's off-topic to just post links, but here are the ones I find most useful... Generate Basic Excel Files from PHP http://px.sklar.com/code.html?code_id=488 Favicon Generator (for Internet Explorer - icon that accompanies a link when you add it to your favorites list) http://www.favicon.com/ JavaScript 1.3 Object/Laguange Reference (a bit outdated, but very useful) http://rts.ncst.ernet.in/resources/javascript/reference/ Zip Code Database http://sourceforge.net/project/showfiles.php?group_id=3641&release_id=30 240 ADODB for PHP http://sourceforge.net/project/showfiles.php?group_id=3641&release_id=30 240 AfterBurner Cache for PHP http://bwcache.bware.it/ Strip MP3 ID Tags - PHP http://px.sklar.com/code.html?code_id=429 Date Calculation Class - PHP http://www.phpinsider.com/php/code/Date_Calc/ DBG PHP Debugger http://dd.cron.ru/dbg/ Graphing Class for PHP http://www.aditus.nu/jpgraph/index.php PHP Nightly Builds http://snaps.php.net/ PHP Accelerator (similar to Zend cache) http://212.67.208.211/index.php File Format Archive http://www.wotsit.org/default.asp Cascading Style Sheets 2 Reference http://zvon.org/xxl/CSS2Reference/Output/index.html PHP DOM XML Parsing Class (doesn't require DOM-XML Library) http://sourceforge.net/projects/phpxpath/ World of Mathematics (discrete math, anyone?) http://mathworld.wolfram.com/ PHP Bytecode Compiler http://pbc.sourceforge.net/ NuSphere Tech Library (good articles on PEAR DB, XML, and Gemini tables) http://www.nusphere.com/products/tech_library.htm -Original Message- From: jimmy elab [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 1:34 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] MySQL to Excel with mutiple sheets Matthew Loff wrote: > > http://www.wotsit.org/search.asp?page=49&s=ALLFILES > > http://homepage.tinet.ie/~jmcnamara/perl/WriteExcel.html This guy really has loads of remarkable links, or have you?! Got any more? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySQL to Excel with mutiple sheets
Jason Murray wrote: > > I stand by my original statement. After someone requires PHP to > output a multi-sheet Excel file, the code to do it will then > be "out there". :) Ah, this is a nice cryptic answer! I need it -more or less- ;-) Why? This is why: http://nijb.nl/planning.php (It will open a flat excel sheet, or so you might think) Oh, in case you should worry, the file is PHP generated and guaranteed macro free. There's the first requirement fullfilled. So what more needs to be done, and where is 'out there?' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySQL to Excel with mutiple sheets
David Robley wrote: > > s/require it be done/want to do it Count me in. Starting somewhere in December. An RTF module will be first, though! I'll post. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySQL to Excel with mutiple sheets
Matthew Loff wrote: > > http://www.wotsit.org/search.asp?page=49&s=ALLFILES > > http://homepage.tinet.ie/~jmcnamara/perl/WriteExcel.html This guy really has loads of remarkable links, or have you?! Got any more? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] MySQL to Excel with mutiple sheets
> > > Actually, I looked into the possibility of doing that, but it turns > > > out the Excel 5.0+ file format is -very- complicated... Not just a > > > standard binary file... > > > > > > Check it out: > > > http://www.wotsit.org/search.asp?page=49&s=ALLFILES > > > > > > Way beyond my capabilities and patience. :) > > > > Eugh > > > > Hrm, well ... it can be done at least. We just need someone > > to require it be done :) > > s/require it be done/want to do it I stand by my original statement. After someone requires PHP to output a multi-sheet Excel file, the code to do it will then be "out there". :) Jason -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySQL to Excel with mutiple sheets
On Thu, 29 Nov 2001 16:51, Jason Murray wrote: > > Actually, I looked into the possibility of doing that, but it turns > > out the Excel 5.0+ file format is -very- complicated... Not just a > > standard binary file... > > > > Check it out: > > http://www.wotsit.org/search.asp?page=49&s=ALLFILES > > > > Way beyond my capabilities and patience. :) > > Eugh > > Hrm, well ... it can be done at least. We just need someone to require > it be done :) > s/require it be done/want to do it ;-) -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA C:\WINDOWS C:\WINDOWS\GO C:\PC\CRAWL -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] MySQL to Excel with mutiple sheets
> Actually, I looked into the possibility of doing that, but it turns out > the Excel 5.0+ file format is -very- complicated... Not just a standard > binary file... > > Check it out: > http://www.wotsit.org/search.asp?page=49&s=ALLFILES > > Way beyond my capabilities and patience. :) Eugh Hrm, well ... it can be done at least. We just need someone to require it be done :) J -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] MySQL to Excel with mutiple sheets
Actually, I looked into the possibility of doing that, but it turns out the Excel 5.0+ file format is -very- complicated... Not just a standard binary file... Check it out: http://www.wotsit.org/search.asp?page=49&s=ALLFILES Way beyond my capabilities and patience. :) -Original Message- From: Jason Murray [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 1:02 AM To: 'Matthew Loff'; 'Brian Lee'; [EMAIL PROTECTED] Subject: RE: [PHP] MySQL to Excel with mutiple sheets > Can't be done easily with PHP right now... To get that type of > functionality, you'd need to write it in Perl using the > SpreadSheet::WriteExcel module. > > http://homepage.tinet.ie/~jmcnamara/perl/WriteExcel.html In that case, someone could probably work out how to do it based on the source of that module... :) Jason -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] MySQL to Excel with mutiple sheets
> Can't be done easily with PHP right now... To get that type of > functionality, you'd need to write it in Perl using the > SpreadSheet::WriteExcel module. > > http://homepage.tinet.ie/~jmcnamara/perl/WriteExcel.html In that case, someone could probably work out how to do it based on the source of that module... :) Jason -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] MySQL to Excel with mutiple sheets
Can't be done easily with PHP right now... To get that type of functionality, you'd need to write it in Perl using the SpreadSheet::WriteExcel module. http://homepage.tinet.ie/~jmcnamara/perl/WriteExcel.html -Original Message- From: Brian Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:34 PM To: [EMAIL PROTECTED] Subject: [PHP] MySQL to Excel with mutiple sheets I have a script that searches a MySQL DB and produces an Excel file from each table in the search. EX. You search 4 different tables for the "Seattle" you would come up with 4 different Excel files. Now I was wondering if it was possible to take the 4 different Excel files I just created and combine into one excel file with 4 different sheets? If anyone has a code for this or could possible help me it would be great. I am using: PHP: 4.04 Linux: 7.0 MySQL: 3.22.32 Thanks -Brian _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]