Re: excel spreadsheet - more than 255 characters
| From: | Xavier Noguer | Date: | Tue, 10 Feb 2004 22:12:45 +0000 |
| Subject: | Re: excel spreadsheet - more than 255 characters | ||
| References: | 1 2 3 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-10615@lists.php.net to get a copy of this message | ||
Could you try with:
error_reporting(E_ALL);
PEAR::setErrorHandling(PEAR_ERROR_DIE);
and save your file using:
$xls =& new Spreadsheet_Excel_Writer('yourfile.xls');
and see what happens?
Xavier
---------------------------------------------
Hi Justin,
Justin Patrin wrote:
> Could you show us at least some of your code?
>
<?php
include_once "Spreadsheet/Excel/Writer.php";
$ordner["custom"] = "includes/";
$xls =& new Spreadsheet_Excel_Writer();
$xls->send("ueber.xls");
$sheet =& $xls->addWorksheet('Uebersetzungen');
$xls->setVersion(8);
$db = new DB_TplNews();
$query = "SELECT ueberid, bereich, bezeichnung_de FROM uebersetzungen ";
$db -> query( $query );
$treffer = $db -> num_rows();
if ($treffer) {
// Zähler für die Zeilen
$a = 0;
$formatdata =& $xls->addFormat();
$formatdata->setTextWrap();
$formatdata->setAlign("left");
$formatdata->setAlign("top");
while($db -> next_record()):
$ueberid = $db -> f("ueberid");
$bereich = $db -> f("bereich");
$bezeichnung_de = $db -> f("bezeichnung_de");
// $sheet->setColumn(0,0,10);
$sheet->write($a,0,$ueberid,$formatdata);
// $sheet->setColumn(0,1,30);
$sheet->write($a,1,$bereich,$formatdata);
// $sheet->setColumn(0,2,100);
$sheet->write($a,2,trim($bezeichnung_de),$formatdata);
$a++;
endwhile;
}
$xls->close();
?>
Any Idea ... ?
Greetings,
Jens.