Re: excel spreadsheet - more than 255 characters
| From: | Xavier Noguer | Date: | Mon, 09 Feb 2004 15:39:17 +0000 |
| Subject: | Re: excel spreadsheet - more than 255 characters | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-10575@lists.php.net to get a copy of this message | ||
On Monday 09 February 2004 11:46, Jens Vetter wrote:
....
> $xls =& new Spreadsheet_Excel_Writer();
> $xls->send($datei);
> $sheet =& $xls->addWorksheet('Uebersetzung');
> $sheet->setVersion(8);
That should be:
$xls->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