Re: excel spreadsheet - more than 255 characters
| From: | Jens Vetter | Date: | Tue, 10 Feb 2004 17:01:20 +0000 |
| Subject: | Re: excel spreadsheet - more than 255 characters | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-10611@lists.php.net to get a copy of this message | ||
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.