
php-spreadsheetreader
PHP library for read data of spreadsheet files
It supports OpenDocument Spreadsheet (.ods), Microsoft Excel 97/2000 (.xls), and CSV (.csv), and Text with tab-separated or patterns (.txt).
It's very simple.
``` require_once 'SpreadsheetReaderFactory.php';
$spreadsheetsFilePath = 'test.ods'; //or test.xls, test.csv, etc. $reader = SpreadsheetReaderFactory::reader($spreadsheetsFilePath);
$sheets = $reader->read($spreadsheetsFilePath);
echo $sheets[0][0][0]; ```
Use this command to anonymously check out the latest project source code:
svn checkout http://php-spreadsheetreader.googlecode.com/svn/ php-spreadsheetreader
Revision 26
IMPORTANT!
I rewrite my Excel reader by pure PHP code. Instead of invoking the external reader, jxl.
See also Issue 1.
Revision 24
Add method: asXml(). This return $sheets as Xml string (Excel XML format). Therefor you can save it or put into a download stream.
Revision 21
It can return sheets as associative array.
Revision 16
Support MS Excel 2000/XP's XML file. Note: Excel 2000/XP's XML file format is a single XML file, and different from Office OpenXML.
Bug fixed
Let factory detect file-type case-insensitive.
bug of SpreadsheetReader_Excel: Sometimes, data will contain non-readable chars (I put in $ignoreChar). XML parser will occur a parse error. So we need to strip those non-readable chars.
It only output tables which have content in their first cell. Now fix it.
When read with READ_ASSOC, it forgets to skip the first Row(fields header) after 2nd sheet.
Project Information
- License: GNU Lesser GPL
- 16 stars
- svn-based source control
Labels:
php
library
spreadsheet