Download the PHP package laacz/xls-parser without Composer

On this page you can find all versions of the php package laacz/xls-parser. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of laacz/xls-parser

Informations about the package xls-parser

XLSParser is reasonably fast PHP library intended to parse Microsoft Excel legacy binary XLS formats. It was written because all PHP implementations where too slow. Code is more or less direct port of python's excellent xlrd package. Library is very early alpha. I made it a long time ago.

Feedback

Issues and pull requests are accepted.

Requirements

Install

Via command line: composer require laacz/xls-parser.

Tests

Install dependencies with composer install --dev, then run tests with vendor/bin/phpunit.

Usage

KISS. Provide filename and it gets loaded or parsed.

Accessing sheets

Sheets can be accessed via their numeric index or name. Since Sheet object implements ArrayAccess and IteratorAggregate, you can do that too.

Accessing cells

Cells also can be accessed as with sheets. Index starts from zero.

To get value of a cell, cast it to string (or use it in such context) or get value attribute:

Or, if you wish...

Formatting

By now formatting can be accessed raw. In short - sheet contains mapping array rich_text_runlist_map[][], which has arrays with two elements - position and font reference. First is position where style is being applied from, second is number which refers to book's font_list[], which on its part contains format description.

Excel dates

Library does its best to parse dates found within cells. It returns string in common date format: 'yyyy-mm-dd hh:mi:ss'. For example: 2014-12-31 12:59:59.

Wishlist

All versions of xls-parser with dependencies

PHP Build Version
Package Version
Requires php Version >=5.4
ext-mbstring Version *
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package laacz/xls-parser contains the following files

Loading the files please wait ....