excel writer

[frank7l7]

tach auch,

suche ne anleitung bzw ein fertiges script der mit dem spreadsheet excel write modul arbeitet. ich hab im forum kurz was drüber gelesen. nu will es selbst mal einbauen hab aber keinen schimmer wie? googlen hat auch nur verwirrung gestiftet wer kann helfen

donge

fra7l7

[Offe1]

eigenes, funktionierendes, sinnloses Beispiel:

<?php
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();

$format_bold =& $workbook->addFormat();
$format_bold->setBold();

$format_title =& $workbook->addFormat();
$format_title->setBold();
$format_title->setColor('yellow');
$format_title->setPattern(1);
$format_title->setFgColor('blue');
// let's merge
$format_title->setAlign('merge');

  // Creating the first worksheet
  $worksheet1 =& $workbook->addWorksheet('Erster');
  $worksheet1->write(1, 1, "This worksheet's name is ".$worksheet1->getName());
  $worksheet1->write(2,1,"http://www.phpclasses.org/browse.html/package/767.html");
  $worksheet1->write(3, 0, 11);
  $worksheet1->write(3, 1, 1);
  $worksheet1->write(3, 2, "by four is");
  $worksheet1->writeFormula(3, 3, "=A4 * (2 + 2)");
  //$worksheet1->writeFormula(3, 3, "= SUM(A4:B4)");
  $worksheet1->write(5, 4, "= POWER(2,3)");
  $worksheet1->write(4, 4, "= SUM(5, 5, 5)");
  //$worksheet1->writeFormula(4, 4, "= LN(2.71428)");
  //$worksheet1->writeFormula(5, 4, "= SIN(PI()/2)");

$worksheet =& $workbook->addWorksheet(Test);
$worksheet->write(0, 0, "Quarterly Einnahmen bei prokonzept", $format_title);
// Couple of empty cells to make it look better
$worksheet->write(0, 1, "", $format_title);
$worksheet->write(0, 2, "", $format_title);
$worksheet->write(1, 0, "Quarter", $format_bold);
$worksheet->write(1, 1, "Einnahmen", $format_bold);
$worksheet->write(2, 0, "Q1");
$worksheet->write(2, 1, 2.5);
$worksheet->write(3, 0, "Q2");
$worksheet->write(3, 1, 3.2);
$worksheet->write(5, 0, "Feld E5 in Erster");
$worksheet->writeFormula(5, 1, "=Erster!E5");

$worksheet =& $workbook->addWorksheet(Einnahmen);
$worksheet->write(0, 0, "Quarterly Einnahmen bei prokonzept", $format_title);
// Couple of empty cells to make it look better
$worksheet->write(0, 1, "", $format_title);
$worksheet->write(0, 2, "", $format_title);
$worksheet->write(1, 0, "Quarter", $format_bold);
$worksheet->write(1, 1, "Einnahmen", $format_bold);
$worksheet->write(2, 0, "Q1");
$worksheet->write(2, 1, 2.5);
$worksheet->write(3, 0, "Q2");
$worksheet->write(3, 1, 3.2);
$worksheet->write(5, 0, "Summe");
$worksheet->write(5, 1, '=3+2*(SUM(B3:B4))');


$worksheet =& $workbook->addWorksheet(Ausgaben);
$worksheet->write(0, 0, "Quarterly Ausgaben bei prokonzept", $format_title);
// Couple of empty cells to make it look better
$worksheet->write(0, 1, "", $format_title);
$worksheet->write(0, 2, "", $format_title);
$worksheet->write(1, 0, "Quarter", $format_bold);
$worksheet->write(1, 1, "Ausgaben", $format_bold);
$worksheet->write(2, 0, "Q1");
$worksheet->write(2, 1, 1.5);
$worksheet->write(3, 0, "Q2");
$worksheet->write(3, 1, 3.0);
$worksheet->write(5, 0, "Summe");
$worksheet->write(5, 1, '=SIN(PI()/4)*B3' );

$workbook->send('test.xls');
$workbook->close();
?>

What is Spreadsheet_Excel_Writer?

Offe

[frank7l7]

aha, bene sehr gut.

aber wie komme ich an die writer.php ?

fra7l7

[Offe1]

pear install OLE
pear install Spreadsheet_Excel_Writer
wenn du PEAR installiert hast oder Spreadsheet_Excel_Writer

Offe

[frank7l7]

hmmmm, ... wie krieg ich raus ob das auf meinem webserver schon läuft bzw. wenn nicht muß ich dann meinem provider sagen das er es installieren soll?

danke

[Offe1]

OLE und Spreadsheet_Excel_Writer herunterladen, entzippen und dann auf den Server in das Verzeichnis pear, welches vorher im Dokument Root erstellt wurde, uploaden.

In dem Script zum Testen von Spreadsheet_Excel_Writer:

ini_set('include_path', '/pear'); 

das wärs und vielen Spaß.

Offe

[frank7l7]

also ich hab die sachen jetzt lokal runtergeladen ,... jetzt ein verzeichniss pear erstellen im doc root und die sachen dort reinschmeissen ja?

ich glaub die ini set brauch ich nicht da ich überall includieren kann