Re: Spreadsheet_Writer_Excel header row

From: Date: Wed, 17 Sep 2003 18:51:05 +0000
Subject: Re: Spreadsheet_Writer_Excel header row
References: 1  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-7878@lists.php.net to get a copy of this message
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: $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

« previous php.pear.general (#7878) next »