PHP library for read data of spreadsheet filesIt supports OpenDocument Spreadsheet (.ods), Microsoft Excel 97/2000 (.xls), and CSV (.csv), and Text with tab-separated or patterns (.txt).
It's very simple.
$spreadsheetsFilePath = 'test.ods'; //or test.xls, test.csv, etc.
$reader = SpreadsheetReaderFactory::reader($spreadsheetsFilePath);
$sheets = $reader->read($spreadsheetsFilePath);
echo $sheets;Use this command to anonymously check out the latest project source code:
svn checkout http://php-spreadsheetreader.googlecode.com/svn/ php-spreadsheetreaderRevision 26IMPORTANT!
I rewrite my Excel reader by pure PHP code. Instead of invoking the external reader, jxl.
See also Issue 1.
Revision 24Add method: asXml(). This return $sheets as Xml string (Excel XML format). Therefor you can save it or put into a download stream.
Revision 21It can return sheets as associative array.
Revision 16Support 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.
Use Patent Claims
Include Install Instructions
These details are provided for information only. No information here is legal advice and should not be used as such.