Welcome Guest, Not a member yet? Register   Sign In
PHP-Excel-Reader issues
#1

[eluser]alainm[/eluser]
I followed the instructions i think to the letter on how to install this tool.

http://code.google.com/p/php-excel-reader/

$params = array('file' =>$file_path);

$this->load->library('Spreadsheet_Excel_Reader', $params);

error_reporting(E_ALL ^ E_NOTICE);

echo $this->spreadsheet_excel_reader->dump(true,true);

Something seems like it's doing something for about 1 min the CPU is 25%.. then all i get is a while browser page.

Also no output to the console or logs.

thoughts?

I'm on a Mac if that makes any difference.
#2

[eluser]alainm[/eluser]
Any thoughts at all? i'm stuck on the solution.
#3

[eluser]danmontgomery[/eluser]
How big is the file? You might be hitting max_execution_time... You can use

Code:
set_time_limit(0);
to disable for testing, although I wouldn't recommend leaving it there
#4

[eluser]alainm[/eluser]
Good thinking, but I've done that..

also, my test file had 2 rows and 5 columns.

Sad
#5

[eluser]alainm[/eluser]
anyone else have this working?

or does anyone, recommend any other tool for reading in and Excel sheet?
#6

[eluser]vitoco[/eluser]
same as you...but not as library....

use :
Code:
// SHOW ERRORS
    error_reporting( E_ALL ^ E_NOTICE );
    // SET MORE MEMORY TO PROCESS THE .XLS
    ini_set('memory_limit', '128M');
    // SET MORE TIME TO PROCESS THE .XLS
    set_time_limit( 2000 );
    // PATH TO THE .XLS FILE
    $file = APPPATH.'path/to/xls/file.xls';
    // INCLUDE THE LIBRARY
    require_once APPPATH.'libraries/external/php_excel_reader/excel_reader2.php';
    // READ THE .XLS
    $data = new Spreadsheet_Excel_Reader( $file , false );

Saludos




Theme © iAndrew 2016 - Forum software by © MyBB