Troubles with LibreOffice about simplexlsx HOT 11 CLOSED

try this hack

if ( $xlsx = SimpleXLSX::parse('book.xlsx') ) {
	$sheet_names = $xlsx->sheetNames();
	reset( $sheet_names);
	$first_sheet_id = key( $sheet_names );
	print_r( $xlsx->rows( $first_sheet_id ) );
} else {
	echo SimpleXLSX::parse_error();
}

from simplexlsx.

from simplexlsx.

I can confirm the issue. Most recent simplexlsx version is still having troubles to open some xlsx file created by LibreOffice (LibreOffice V5.3.1.2 on Kubuntu 16.04).
upload_template.xlsx

from simplexlsx.

Hello! Excelente work!!

In my case the sheet id was number 3, I found that when print_r the sheet names, the only one was [3]=>Hoja1.
So, I add after the solution Pedro (but in another function) post a second check for id 3. I worked for me to solve quickly.

public function worksheet( $worksheet_id ) {

	if(!isset($this->sheets[1]) && isset($this->sheets[2])){
        $this->sheets[1] = $this->sheets[2];
        $worksheet_id = 2;
    }else if(!isset($this->sheets[2]) && isset($this->sheets[3])){
    	$this->sheets[1] = $this->sheets[3];
        $worksheet_id = 3;
    }

	if ( isset( $this->sheets[ $worksheet_id ] ) ) {
		$ws = $this->sheets[ $worksheet_id ];
		
		if (isset($ws->hyperlinks)) {
			$this->hyperlinks = array();
			foreach( $ws->hyperlinks->hyperlink as $hyperlink ) {
				$this->hyperlinks[ (string) $hyperlink['ref'] ] = (string) $hyperlink['display'];
			}
		}
		
		return $ws;
	} else {
		$this->error( 'Worksheet '.$worksheet_id.' not found.');
		return false;
	}
}

Thanks!

from simplexlsx.

Hi @shuchkin why is this closed? after saving xlsx in libre, the script won't work for me.

if ( $xlsx = SimpleXLSX::parse($tmp_file) ) {
	print_r( $xlsx->rows() );
} else {
	echo SimpleXLSX::parse_error();
}

does not throw a message. just a blank page :(
Thanks for the work you have done! saved in excel it worked just perfect :)

from simplexlsx.

ini_set('display_errors', true);
ini_set('error_reporting', E_ALL);
if ( $xlsx = SimpleXLSX::parse($tmp_file) ) {
	print_r( $xlsx->rows() );
} else {
	echo SimpleXLSX::parse_error();
}

from simplexlsx.

thanks for your fast response, it didn't show any errors either, sorry. Were you able to read the upload_template.xlsx Kukulkano uploaded? I am not.

from simplexlsx.

great, thank you, this worked! 💯 I don't really understand what these lines do, are you able to patch this? or can you provide me any if statement that tells me if the file is a Libre file?

from simplexlsx.

I'm also interested in a generic solution. It should be able to handle both Microsoft Excel and LibreOffice Calc saved xlsx files out of the box. If parsing the sheets solves the issue, maybe it can be done in general?

from simplexlsx.

@Kukulkano It's fixed in the latest version 👍

from simplexlsx.

Oh, 9 days ago. Great! Thanks! :)

from simplexlsx.