caseycs/catdoc-xls

PHP wrapper on catdoc util - xls files parser

dev-master 2016-03-14 05:03 UTC

Requires

• php: >=5.3.0

Requires (Dev)

• phpunit/phpunit: 3.7.*

MIT

• Ilia Kondrashov

• excel
• xls
• parser

README

Excel files to PHP array convertor (xls/xlsx), wrapper on catdoc, xls2csv (with few modifications) and xlsx2csv.

Dependencies should be already install: xlsx2csv can be installed via pip, catdoc is available by apt-get.

Usage example:

$Parser = new \CatDocXls\Parser;
$result = $Parser->xls('path/to/file.xls');
print_r($result);

//some xsl files are not parsed via xls2csv binary correct, so you can try python script
$Parser = new \CatDocXls\Parser;
$result = $Parser->xls2('path/to/file.xls', 0);
print_r($result);

$Parser = new \CatDocXls\Parser;
$result = $Parser->xlsx('path/to/file.xlsx');
print_r($result);

See more examples in ParserTest.php

Known issues

• Empty lines are ignored - this is hardcoded in xls2csv, and --ignoreempty is always passed to xlsx2csv
• Empty sheets are also ignored
• Xls2cvs always output date and datetime fields as days count, so is is passed as is - you should convert them manually, see http://www.linuxquestions.org/questions/red-hat-31/xls2csv-doesn-t-work-with-excel-date-format-703348/