grazie, se nn riesco con phpexcel vado col tuo.
Originariamente inviato da JerryLeeLeewis
Ciao bstefano79,
come si fa ad implementare phpexcel?
ti posto quello che ho fatto.
ti scarichi la libreria e metti la directory Classes nel tuo progetto.
poi fai una cosa del genere:
Codice PHP:
<form method="post" action="<?php $_SERVER['PHP_SELF']; ?>">
<input type="submit" value="Create excel file" />
</form>
<?php
if ($_SERVER['REQUEST_METHOD'] == "POST") {
// include_once 'moduli/config.php';
include_once 'phpex/PHPExcel.php';
include_once 'phpex/PHPExcel/Writer/Excel5.php';
echo date('H:i:s') . " Create new PHPExcel object
";
$objPHPExcel = new PHPExcel();
echo date('H:i:s') . " Set properties
";
$objPHPExcel->getProperties()->setCreator("Matteo");
$objPHPExcel->getProperties()->setLastModifiedBy("Matteo");
$objPHPExcel->getProperties()->setTitle("My library");
$objPHPExcel->getProperties()->setSubject("My library");
$objPHPExcel->getProperties()->setDescription("My library.");
echo date('H:i:s') . " Add some data
";
$row = 0;
$col = 0;
$objPHPExcel->setActiveSheetIndex(0);
while ($row = $ind->selectEx()) {
foreach ($row as $key => $value) {
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
$col++;
}
$row++;
}
// $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Title');
// $objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Author');
// $objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Editor');
// $objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Price');
// $objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Isbn');
// $objPHPExcel->getActiveSheet()->SetCellValue('F1', 'Note');
echo date('H:i:s') . " Rename sheet
";
$objPHPExcel->getActiveSheet()->setTitle('Book');
echo date('H:i:s') . " Write to Excel2007 format
";
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
$objWriter->save("book.xls");
echo date('H:i:s') . " Done writing file.\r
";
echo date('H:i:s') . " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB\r
";
echo date('H:i:s') . " Done.\r
";
}
?>
a me nn riesce di listare in automatico tutta la tabella.
per il resto funziona tutto (se levi il while e metti la parte commentata).
Rispondi quotando
