Re: DataObject, DataGrid and joins
| From: | Mark Wiesemann | Date: | Sun, 20 Nov 2005 17:36:30 +0000 |
| Subject: | Re: DataObject, DataGrid and joins | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-22024@lists.php.net to get a copy of this message | ||
"Prue" wrote:
> 4. If I used $dg->renderer->setFilename('datagrid.xls');
>
> Two spreadsheets were created. One named datagrid.xls contained
> only the column headings and was immediately displayed on the screen. The
> other, named datagridxx.xls contained the correct data, where 'xx' was the
> next incremental number of copies of the spreadsheet that had been
> generated. This was automatically downloaded to the local machine.
The last one may be a temporary file that actually should have been
deleted after generating the real Excel file.
I just have checked the old and new behaviour of the XLS renderer and it
worked as expected on my machine.
If it doesn't work for you, then please provide excerpts from your code,
so that we can try to reproduce your problems.
> PS: Has anyone devised a way to 'pretty-up' the format of the output Excel
> worksheet?
After a refactoring of Structures_DataGrid it will be easy to overload
the header() method, for example. In this method you could set another
font size and family or change the (fore-/background) color of the first
row.
Mark