Re: Spreadsheet_Writer_Excel header row
| From: | Jackson Miller | Date: | Wed, 17 Sep 2003 19:59:28 +0000 |
| Subject: | Re: Spreadsheet_Writer_Excel header row | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-7879@lists.php.net to get a copy of this message | ||
On Wednesday 17 September 2003 1:51, Rob Yelvington wrote:
> If you're looking to just put some kind of heading in the first row of each
> column, this is what I found in the docs...create a format, then write the
> heading to the column with the format:
Yeah that is helpful. However, I was hoping to make actual column headers
which I have seen in Excel, but maybe a feature newer than Excel 5.
-Jackson
>
> $format_bold =& $workbook->addFormat();
> $format_bold->setBold();
> $worksheet->write(0, 0, 'HEADING Col A', $format_bold);
> $worksheet->write(0, 1, 'HEADING Col B', $format_bold);
> $worksheet->write(0, 2, 'HEADING Col C', $format_bold);
> $worksheet->write(0, 3, 'HEADING Col D', $format_bold);
>
> HTH!
>
> Thanks,
>
> ~Rob
>
>
> ----- Original Message -----
> From: "Jackson Miller" <jackson@coldfeetcreative.com>
> To: <pear-general@lists.php.net>
> Sent: Wednesday, September 17, 2003 1:38 PM
> Subject: [PEAR] Spreadsheet_Writer_Excel header row
>
>
> Is there any way to set the column name using Spreadsheet_Writer_Excel?
>
> I would like for the headers to be along the lines of:
> First Name | Last Name | Address |etc
>
> as opposed to:
> A | B | C | etc
>
> I have read the docs but I can't find anything about setting headers but
> there
> is a method to get the headers.
>
> Thanks,
> -Jackson
>
>
> --
> jackson miller
>
> cold feet creative
> 615.321.3300 / 800.595.4401
> jackson@coldfeetcreative.com
>
>
> cold feet presents Emma
> the world's easiest email marketing
> Learn more @ http://www.myemma.com
>
> --
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
jackson miller
cold feet creative
615.321.3300 / 800.595.4401
jackson@coldfeetcreative.com
cold feet presents Emma
the world's easiest email marketing
Learn more @ http://www.myemma.com