Visualizzazione dei risultati da 1 a 2 su 2

Discussione: Aiuto su PHPExcel

  1. #1

    Aiuto su PHPExcel

    sto crecando di usare questa libreria per esportare il contenuto di una tabella.
    ho fatto un semplice esempio:
    Codice PHP:
    <?php
    if ($_SERVER['REQUEST_METHOD'] == "POST") {
        
    // [url]http://blog.mayflower.de/archives/561-Import-and-export-data-using-PHPExcel.html[/url]
        
    include_once 'phpex/PHPExcel.php';
        
    $objEx = new PHPExcel();
        echo 
    date('H:i:s') . " Creation
    "
    ;
        
    $objEx->getProperties()->setCreator("Mattepuffo")
                ->
    setLastModifiedBy("Mattepuffo")
                ->
    setTitle("My library")
                ->
    setSubject("My library")
                ->
    setDescription("My library in excel.")
                ->
    setKeywords("Library book excel office php")
                ->
    setCategory("Book");

        echo 
    date('H:i:s') . " Adding
    "
    ;
        
    $objEx->getActiveSheet()->setTitle('Book');
        
    $objEx->setActiveSheetIndex(0)
                ->
    setCellValue('A1''Hello')
                ->
    setCellValue('B2''world!')
                ->
    setCellValue('C1''Hello')
                ->
    setCellValue('D2''world!');

        echo 
    date('H:i:s') . " Saving
    "
    ;
        
    $write PHPExcel_IOFactory::createWriter($phpExcel'Excel2007');
        
    $write->save("C:\\export.xls");

        echo 
    date('H:i:s') . " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 1024) . " MB\r
    "
    ;

        echo 
    date('H:i:s') . " Done.\r
    "
    ;
    }
    ?>
    in pratica ho tutti i messaggi giusti, però il file nn lo salva.
    sapete darmi una mano?

  2. #2
    ok modificando così ce l'ho fatta:
    Codice PHP:
                        <?php
                            error_reporting
    (E_ALL);

                            if (
    $_SERVER['REQUEST_METHOD'] == "POST") {

                                include 
    'phpex/PHPExcel.php';
                                include 
    '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
    "
    ;
                                
    $objPHPExcel->setActiveSheetIndex(0);
                                
    $objPHPExcel->getActiveSheet()->SetCellValue('A1''Hello');
                                
    $objPHPExcel->getActiveSheet()->SetCellValue('B2''world!');
                                
    $objPHPExcel->getActiveSheet()->SetCellValue('C1''Hello');
                                
    $objPHPExcel->getActiveSheet()->SetCellValue('D2''world!');

                                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("C:\\excel.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
    "
    ;
                                
    header('location:[url]http://62.94.208.157/book/index.php[/url]');
                            }
                        
    ?>
    il problema è che salva il file sul server e nn sul pc che esegue la richiesta.

Permessi di invio

  • Non puoi inserire discussioni
  • Non puoi inserire repliche
  • Non puoi inserire allegati
  • Non puoi modificare i tuoi messaggi
  •  
Powered by vBulletin® Version 4.2.1
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved.