Re: excel spreadsheet - more than 255 characters
| From: | Jens Vetter | Date: | Mon, 09 Feb 2004 14:46:22 +0000 |
| Subject: | Re: excel spreadsheet - more than 255 characters | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-10571@lists.php.net to get a copy of this message | ||
Hi Xavier,
I got the newest version 0.6 and I only get an
"Call to undefined function: setversion()"
when I use the
$sheet->setVersion(8);
<?php
include_once "Spreadsheet/Excel/Writer.php";
$datei = "uebersetzungen_";
$datei .= date("dmY")."_".date("His");
$datei .= ".xls";
$xls =& new Spreadsheet_Excel_Writer();
$xls->send($datei);
$sheet =& $xls->addWorksheet('Uebersetzung');
$sheet->setVersion(8);
$formatdata =& $xls->addFormat();
$formatdata->setTextWrap();
$formatdata->setAlign("left");
$formatdata->setAlign("top");
$fieldname = "long text ...";
$sheet->setColumn(0,0,100);
$sheet->write(0,0,$fieldname,$formatdata);
$xls->close();
?>
Maybe you can tell me the version, that I need to install.
Thanks for your help,
Jens.
Xavier Noguer wrote:
In the latest version (and cvs also) you can use: $workbook->setVersion(8); in order to write strings longer than 255. Beware that this is experimental and the setVersion method will be deprecated in future versions, once BIFF7 support becomes the default. Xavier