PHP Classes

Native Excel Reader: Parse and access binary Excel files in pure PHP

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 64%Total: 5,633 All time: 428 This week: 51Up
Version License PHP version Categories
biff-reader 0.5.1GNU General Publi...5.0PHP 5, Files and Folders
Description 

Author

Ruslan V. Uss

This package can be used to parse and access binary Excel files in pure PHP.

It can take the data of an Excel file in the binary format and parse it to take the spreadsheet structure.

The package provides several classes that extract the different parts of a spreadsheet and allow iterating those parts like workbooks, sheets, rows, columns and cells.

Picture of Ruslan V. Uss
Name: Ruslan V. Uss <contact>
Classes: 2 packages by
Country: Russian Federation Russian Federation
Age: 45
All time rank: 47512 in Russian Federation Russian Federation
Week rank: 195 Up12 in Russian Federation Russian Federation Equal

Recommendations

import data from .xls and .xlsx file to database using PHP
SimpleXLSX class but this class can not import .xls file

  Files folder image Files (9)  
File Role Description
Accessible without login Plain text file example.php Example Simple example, reads test.xls file
Plain text file BiffWorkbook.inc.php Class Main excel reader class
Plain text file BiffWorkbookBorder.inc.php Class Excel cell border class
Plain text file BiffWorkbookCell.inc.php Class Excel cell class
Plain text file BiffWorkbookElement.inc.php Class Base class for style elements
Plain text file BiffWorkbookFont.inc.php Class Excel font class
Plain text file BiffWorkbookSheet.inc.php Class Excel worksheet class
Plain text file BiffWorkbookStyle.inc.php Class Excel cell style class
Plain text file CompoundDocument.inc.php Class MS Compound Document Reader

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadbiff-reader-2010-10-07.zip 18KB
Downloadbiff-reader-2010-10-07.tar.gz 12KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:5,633
This week:0
All time:428
This week:51Up
User Ratings User Comments (4)
 All time
Utility:94%StarStarStarStarStar
Consistency:89%StarStarStarStarStar
Documentation:-
Examples:85%StarStarStarStarStar
Tests:-
Videos:-
Overall:64%StarStarStarStar
Rank:702
 
That's so greate.
12 years ago (Leon Nguyen)		70%StarStarStarStar
great work!
12 years ago (sleven)		70%StarStarStarStar
Thank you the script is Great!!! :)
14 years ago (Archana Shukla)		70%StarStarStarStar
Brilliant - worked first time.
14 years ago (Paul Tanner-Tremaine)		65%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Pages that reference this package  
Recently, i got a task of grabbing data from tons of excel sheet into mysql , from the very first moment i realize that i will save the given files into CSV then i can easily get the data from the file. but what actually happened that i did’t find any class which is good for CSV in reading the workbook sheet...

Latest pages that reference packages Latest pages that reference packages