Hi all,
I've used the PEAR class Spreedsheet_Excel_writer some days ago. For one of my clients, who couldn't install pear on Webserver, I've repatched this class to xls_writer and a export function on it. It uses table headers worksheets, merged cells and merged rows. Some styles, like frame border, color, image or so, can be used on this function.
If you want, I will put it on my ftp-server for downloading...
Regards Michael
| Message: 1 | Date: Mon, 7 Jun 2004 16:24:46 +0200 | From: Michal =?utf-8?B?xIxpaGHFmQ==?= michal@cihar.com | To: phpMyAdmin devel phpmyadmin-devel@lists.sourceforge.net | Subject: [Phpmyadmin-devel] MS Excel export | | Hi all | | I just added experimental MS Excel export. It uses PEAR class | Spreadsheet_Excel_Writer. Enabling of this feature is | described in docs. | I'd like to get some feedback from you about this. | | -- | Regards | Michal ÄihaÅ | http://cihar.com | | | --__--__-- | | Message: 2 | Date: Mon, 7 Jun 2004 17:49:05 +0200 (CEST) | Subject: Re: [Phpmyadmin-devel] MS Excel export | From: "Garvin Hicking" phpmyadmin@supergarv.de | To: phpmyadmin-devel@lists.sourceforge.net | Reply-To: phpmyadmin@supergarv.de | | Hi Michal! | | I currently don't have the spreadsheet-class installed, but | will do so tonight. | Your code however looks clean, so I don't think that there'll | be problems. | | Love the implementatio, it's a good benefit. | | However I was thinking if we really need a new TempDir | setting? Couldn't we | combine that with SaveDir? | | And maybe we should use @include_once when probing for the | spreadsheet file no | not generate errors. And if the class was not found, we could | set $xls to a | string and on the export screen display a link/message that | you can use the | PEAR-class if you want native CSV/XLS export. | | Regards, | Garvin. | | -- | Garvin Hicking | Web-Entwickler | Make me happy: | www.supergarv.de | #ICQ 21392242 | http://wishes.garv.info/ | | | | --__--__-- | | Message: 3 | Date: Mon, 7 Jun 2004 17:52:41 +0200 | From: Michal =?utf-8?B?xIxpaGHFmQ==?= michal@cihar.com | To: phpmyadmin-devel@lists.sourceforge.net | Subject: Re: [Phpmyadmin-devel] MS Excel export | | Hi | | On 07.06.2004 17:49 +0200, Garvin Hicking wrote: | > I currently don't have the spreadsheet-class installed, but | will do so tonight. | > Your code however looks clean, so I don't think that | there'll be problems. | > | > Love the implementatio, it's a good benefit. | > | > However I was thinking if we really need a new TempDir | setting? Couldn't we | > combine that with SaveDir? | | It is used just for temporary files, so it should be separate directory | (and in case php ocassionaly crashes, that directory should be cleaned | up). | | > And maybe we should use @include_once when probing for the | spreadsheet file no | > not generate errors. | | Ooops, I removed @ during testing, adding back. | | > And if the class was not found, we could set $xls to a | > string and on the export screen display a link/message that | you can use the | > PEAR-class if you want native CSV/XLS export. | ^^^^^^^ just XLS, CVS is | always native :-)) | | Okay, I will add one more message. | | -- | Regards | Michal ÄihaÅ | http://cihar.com |