0
I Use This!
Activity Not Available

Project Summary

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.

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-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.

Tags

library php spreadsheet

In a Nutshell, php-spreadsheetreader...

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

GNU Library or "Lesser" GPL (LGPL)
Permitted

Place Warranty

Use Patent Claims

Commercial Use

Modify

Distribute

Forbidden

Sub-License

Hold Liable

Required

Distribute Original

Disclose Source

Include Copyright

State Changes

Include License

Include Install Instructions

These details are provided for information only. No information here is legal advice and should not be used as such.

All Licenses

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    Black Duck offers a free trial so you can discover if there are open source vulnerabilities in your code
  • ...
    anyone with an Open Hub account can update a project's tags
  • ...
    use of OSS increased in 65% of companies in 2016
  • ...
    you can embed statistics from Open Hub on your site

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Community Rating

Be the first to rate this project
Click to add your rating
   Spinner
Review this Project!
Sample ohloh analysis