Throw new Exception("Invalid cell index") when upload Excel

[alisazhang]

We have received the same problems many times from our customers, but we don't know the Excel content when they upload, so I want to know in which situation the Exception occurs.

vary thanks! Looking forward to your response!

[TheCloud]

I have the same issue, but it's related to XLSX files generated via Google Sheet (using Export function)

[abhishekthanvi8]

@TheCloud how did you resolved it ?

[alexut]

I have the same issue, but it's related to XLSX files generated via Google Sheet (using Export function)

Same here...

[Anyvie]

When you open an .xlsx file generated by GoogleSheets, it doesn't have the node in xl/worksheets/sheetX.xml so it can't be loaded successfully.

I made a quick fix for my own purposes, in the XLSXWorksheet class.

protected function parse($xml) {
	$this->parseDimensions($xml->dimension, $xml);
	$this->parseData($xml->sheetData);
}

protected function parseDimensions($dimensions, $xml) {
	$range = (string) $dimensions['ref'];
	
	if (! strlen($range)) {
		$nbRows = count($xml->sheetData->row);
		$nbCells = count($xml->sheetData->row[$nbRows-1]);
		$min = (string) $xml->sheetData->row->c[0]['r'];
		$max = (string) $xml->sheetData->row[$nbRows-1]->c[$nbCells-1]['r'];
		$range = $min.':'.$max;
	}
	
	$cells = explode(':', $range);
	$maxValues = $this->getColumnIndex($cells[1]);
	$this->colCount = $maxValues[0] + 1;
	$this->rowCount = $maxValues[1] + 1;
}

[mcanepa]

Thanks @Anyvie !

There's a pull request that was never merged: #2

In the mean time, your solution and @ahmednuaman's works great