[ jovan1982 @ 23.05.2012. 19:20 ] @
Pokusavam da generisem excel fajl koristeci Spreadsheet Excel Writer preko Pear-a. Vec znam kako da generisem excel koristeci header,ali hocu da to malo izgleda lepse,pa bih da koristim Pear.Pear u aplikaciji uspesno koristim za generisanje Pdf dokumenta,medjutim kada je u pitanju excel fajl nesto ne valja. Ovo je primer iz tutorial-a require_once '/home7/compens4/php/Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('example3.xls'); $worksheet =& $workbook->addWorksheet("Example 3"); $tax =& $workbook->addFormat(); $tax->setNumFormat('.00%'); $price =& $workbook->addFormat(); $price->setNumFormat('$####.00'); $worksheet->write(0, 0, 'Tax Calculation Worksheet'); $worksheet->write(1, 0, 'VAT:'); $worksheet->write(1, 1, ".16", $tax); $worksheet->write(2, 1, 'Price'); $worksheet->write(2, 2, "With Tax"); $worksheet->freezePanes(array(3)); for ($i = 3; $i < 101; $i++) { $worksheet->write($i, 0, "Item $i"); $worksheet->write($i, 1, rand(3, 100), $price); $cell = Spreadsheet_Excel_Writer::rowcolToCell($i, 1); $worksheet->writeFormula($i, 2, "=($cell*B2)+$cell", $price); } $worksheet->writeFormula(102, 1, "=SUM(B4:B102,C4:C102)", $price); $workbook->close(); pri cemu je u require_once deo '/home7/compens4/php/ mesto gde su mi smestene Pear instalacije. Sa istom lokacijom Pdf mi se preko Pear-a ok generise. Zasto ovo ne valja i u cemu je problem...?Naravno instalirao sam Excel writer... |