janson-leung / phpexcel Goto Github PK

I use this script to read article numbers from an xlsx file and to write them to an API or to a txt file, which then imports these articles into my shop. Now I only have the following problem: Article numbers that start with a 0 will be cut off. Say 0112233 becomes 112233 through the conversion. What and where do I have to change so that the leading zeros are not cut off?

For example: days get translated to English. Please add the option to change this

Because the for($i) loop is always true at least once $this->currentRow[$i] is always an array with the value of array("") which is not an empty array.
Which also means that PHPExcelReader->next() will never return null when using an XLS file.

ChangeSheet() Should be returning false in the case of invalid $index . This results in ChangeSheet() returning true even when there is no available sheet to read.

Hi @Janson-Leung

I am using your lib to read excel and csv files. However, I have encountered an issue using the csv reader.

For a particular file, it is not returning file data. When I tried to print the $row before yield $row, it prints the row output but not returning the data to the $reader.

When I loop through $reader, it has nothing. How to fix this issue?

file:
PHPExcelReader/PHPExcel/Reader/Excel5.php

code:
$myFactors = self::_factors($value);

_factors not found in Class PHPExcel_Reader_Excel5

Hello,

Is there any way to preset the excel book password or passing the password to open the password protected excel?

Thanks

Hi,

I have a requirement in which I have to read rate card of customer. When I read xls file, the field that contain pound symbol and price is return as "NULL".

Please help.

Regards,
Aashish Kaushik

1. Excel5.php：使用之前没有检测，202行isset($this->_parse)，223行：isset($this->_lastPos)
2. XLS.php：67行 $this->index--
3. SheetId和实际文件的对应关系应该有一些问题，主要是Sheets()函数

hello,
Can we do row grouping? If there is this feature, how do we do it?
thanks.

Excel2007 parser returns a wrong value of the "lastColumnLetter" if a sheet has more than 27 columns and columns with an index like "AH" are empty for latest rows.
I suggest that will be better to use condition like

if (strlen($columnLetter) > strlen($info['lastColumnLetter'])
    || (strlen($columnLetter) == strlen($info['lastColumnLetter']) && $columnLetter > $info['lastColumnLetter'])) {
    $info['lastColumnLetter'] = $columnLetter;
}

The PHPExcel library sets the global error handler in Excel::load(), overriding any error handler that might have been set earlier. This can cause conflicts with error handlers set by frameworks etc.