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

MIT
Permitted

Commercial Use

Modify

Distribute

Place Warranty

Use Patent Claims

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.

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    in 2016, 47% of companies did not have formal process in place to track OS code
  • ...
    you can embed statistics from Open Hub on your site
  • ...
    65% of companies leverage OSS to speed application development in 2016
  • ...
    compare projects before you chose one to use

 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