Re: Spredsheet issue (Pear Library)
| From: | TAKAGI Masahiro | Date: | Thu, 03 Nov 2005 19:11:44 +0000 |
| Subject: | Re: Spredsheet issue (Pear Library) | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-21758@lists.php.net to get a copy of this message | ||
Hi,
"gaurav saxena" wrote:
>Hi,
> Thanks in advance for all your effort. I am facing one problem that i am not
>able to write the string of more than 255 characters.I am using Pear
>Spreadsheet_Excel_Writer.
>
Try this one.
<?php
require_once('Spreadsheet/Excel/Writer.php');
$workbook = new Spreadsheet_Excel_Writer();
$workbook->setVersion(8); // Use Excel97/2000 Format.
$worksheet =& $workbook->addWorksheet('testSheet');
$strLongerThan255Bytes = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
. 'abcdefghijklmnopqrstuvwxyz'
. 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
. 'abcdefghijklmnopqrstuvwxyz'
. 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
. 'abcdefghijklmnopqrstuvwxyz'
. 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
. 'abcdefghijklmnopqrstuvwxyz'
. 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
. 'abcdefghijklmnopqrstuvwxyz'
. 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
. 'abcdefghijklmnopqrstuvwxyz'
. 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
. 'abcdefghijklmnopqrstuvwxyz';
$worksheet->writeString(0, 0, $strLongerThan255Bytes);
$workbook->send('test.xls');
$workbook->close();
?>
And see also:
http://pear.php.net/package/Spreadsheet_Excel_Writer/docs/latest/Spreadsheet_Excel_Writer/Spreadsheet_Excel_Writer_Workbook.html#methodsetVersion
http://pear.php.net/package/Spreadsheet_Excel_Writer/download/0.6
--
TAKAGI Masahiro mailto:takagi@php.net