Simplexcel.php - Easily read / parse / convert / write between Microsoft Excel XML / CSV / TSV / HTML / JSON / etc spreadsheet tabular file formats

Faisal Salman

Last update: Dec 27, 2022

Related tags

Office csv-converter html-converter json-converter excel-reader excel-converter excel-writer xlsx-converter xlsx-reader

Overview

Simple Excel

Easily parse / convert / write between Microsoft Excel XML / CSV / TSV / HTML / JSON / etc formats

For further deatails see the GitHuib Pages site: http://faisalman.github.com/simple-excel-php

PHP Versions Supported

PHP >= 5.3

Installation

If you're using Composer to manage libraries, include this package in your composer.json

"require" : {
    "faisalman/simple-excel-php" : "0.3.*"
}

If you want to try version 0.4 (still in develop branch) you can use

"require" : {
    "faisalman/simple-excel-php" : "develop as 0.4.0-alpha"
}

Or just load this library in your PHP project by including SimpleExcel.php

require_once('../your/project/directory/here/lib/SimpleExcel/SimpleExcel.php');

Features

Available parsers: Microsoft Excel 2003 XML, CSV, TSV, HTML, JSON
Available writers: Microsoft Excel 2003 XML, CSV, TSV, HTML, JSON

Usage

use SimpleExcel\SimpleExcel

$excel = new SimpleExcel('CSV');
$excel->parser->loadFile('test.csv');

echo $excel->parser->getCell(1, 1);

$excel->convertTo('JSON');
$excel->writer->addRow(array('add', 'another', 'row'));
$excel->writer->saveFile('example');

Development

Testing

$ phpunit --configuration test/phpunit.xml

Next version 0.4.0-alpha is now available under develop branch

License

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Comments

Export array to CSV to disk

Hello, please how can i export array to CSV and please, how can I export array to CSV file directly to disk with a specific path and file name?

Thank you Tom

opened by tomkralik 7
Class 'SimpleExcel' not found
I'm running into the same problem as mentioned by Nevega on linux.org.ru here. Namely an error "Class 'SimpleExcel' not found".

<?php error_reporting (-1); ini_set ('display_errors', 'On'); include_once (dirname (__FILE__) . '/../lib/SimpleExcel/SimpleExcel.php'); $excel = new SimpleExcel ('xml'); ?>

The include works, but then the new fails.
opened by Bert-de-Jong 4
Fix number datatype identification in XMLWriter

When converting CSV to XML, XMLWriter doesn't recognize numeric values properly. Instead, everything gets cast to string.

The problem seems to be in the wrong order of calling is_string and is_numeric. To my understanding, the present, wrong order works in no circumstances.

This pull request inverts the order and thus fixes the problem.

opened by firoxer 3
Autoloader is now a easily unregisterable function

Closures can't be unregistered easily: AFAIK you must unregister all autoloading functions and then add back those that you didn't want to exclude in the first place.

This commit will allow you to unregister the autoloader instance created by this package by simply doing:

spl_autoload_unregister(array('SimpleExcel\SimpleExcel', 'autoLoader'));

opened by unreal4u 3
Develop

Added method removeColumn() to worksheet class. Had to create this to remove column of a worksheet that caused processing of the worksheet laborious.

Side note: first ever pull request. Please let me know if I did this correctly.

opened by KariTrace 3
bug abstract method

I tried to use the library but got error trying to use the example code

Fatal error: Class SimpleExcel\Writer\XMLWriter contains 1 abstract method and must therefore be declared abstract or implement the remaining methods (SimpleExcel\Writer\IWriter::saveFile) in D:\htdocs\libraries\SimpleExcel\Writer\XMLWriter.php on line 154
bug

opened by ghost 3
Non-Excel XML to Excel?

Hello. I try to use SimpleExcel for parsing and convert non-Excel XML file. When I try to do it I get that error: "Document namespace isn't a valid Excel XML 2003 Spreadsheet".

Can I use SimpleExcel for create .xls documents from non Excel XML? Thanks.

opened by skazhikadyadya 2
Catch libxml errors & fixed minor errors
Catch libxml errors in XMLParser::loadString

PHPDoc block fixes

Fixed too late fclose in BaseParser::checkFile

Manually merged changes from #31 by @unreal4u

Fixed SimpleExcel::loadString

Added tests for PHP 5.5 - 5.6

XLSXParser must implement loadString

Fixed HTMLParser::loadString
opened by sergeyklay 1
Incompatible with PHP 5.4

In php 5.4 Call-time pass-by-reference has been removed meaning that you need to put the & in the function definition and not in the function call.

opened by garethlees 1
Bugfixes
Hello,

i made several fixes to your library including:

adding autoloader to composer

fixed bug where you use local insted of instance variable

fixed wront filetype check

added return values after parsing XML

Cheers, Moritz
opened by McRip 1
CSV export broken

Hey Dude,

if I try to export a csv, I get the following warnings:

Warning: fputcsv() expects parameter 1 to be resource, string given in /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/CSVWriter.php on line 45

Call Stack: 0.0002 640496 1. {main}() /home/cbrauckmann/web/www/excel_export/index.php:0 0.0022 864288 2. SimpleExcel\Writer\BaseWriter->saveFile() /home/cbrauckmann/web/www/excel_export/index.php:23 0.0023 866080 3. SimpleExcel\Writer\CSVWriter->saveString() /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/BaseWriter.php:95 0.0023 866296 4. fputcsv() /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/CSVWriter.php:45

Warning: fputcsv() expects parameter 1 to be resource, string given in /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/CSVWriter.php on line 45

Call Stack: 0.0002 640496 1. {main}() /home/cbrauckmann/web/www/excel_export/index.php:0 0.0022 864288 2. SimpleExcel\Writer\BaseWriter->saveFile() /home/cbrauckmann/web/www/excel_export/index.php:23 0.0023 866080 3. SimpleExcel\Writer\CSVWriter->saveString() /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/BaseWriter.php:95 0.0025 866296 4. fputcsv() /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/CSVWriter.php:45

Warning: fputcsv() expects parameter 1 to be resource, string given in /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/CSVWriter.php on line 45

Call Stack: 0.0002 640496 1. {main}() /home/cbrauckmann/web/www/excel_export/index.php:0 0.0022 864288 2. SimpleExcel\Writer\BaseWriter->saveFile() /home/cbrauckmann/web/www/excel_export/index.php:23 0.0023 866080 3. SimpleExcel\Writer\CSVWriter->saveString() /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/BaseWriter.php:95 0.0026 866296 4. fputcsv() /home/cbrauckmann/web/www/excel_export/src/SimpleExcel/Writer/CSVWriter.php:45
bug

opened by derbronko 1
Problem with JSON convert

Is there some option to show the empty fields in JSON string as empty string. The problem is that $excel->toString('JSON') skip the empty fields and if I try to get the content of column X, the content type doesn't match with other rows column X content.

For example

The output array is:

array(3) { [0]=> string(?) "Title" [1]=> string(?) "Quantity" [2]=> string(?) "Price" } array(3) { [0]=> string(?) "BMW" [1]=> string(?) "5" [2]=> string(?) "$192.000" } array(2) { [0]=> string(?) "Mercedes" [1]=> string(?) "$204.000" } array(3) { [0]=> string(?) "Audi" [1]=> string(?) "10" [2]=> string(?) "$150.000" }

So, when I'm trying to get all quantites result is:

5, $204.000, 10

opened by PYovchevski 1
Bug: new line after closing php tag.

Please remove all the php closing tags in your files, because it write a new line to the output unnecessary.

For example: XMLWriter.php line 147

I am using v.0.3

Thank you, and keep up the good work, your project is awesome. I did not found any openxml parser what is work fast like this.

opened by vaso123 0
can't use any parsing methods after setData

When you you getData() on an instance, manipulate the data in php, then write it back into the instance using setData(), any parsing such as getRow() will affect the original file that was loaded and not the modified data that was set. Any writing options do write the data from setData(). Is there anyway to make the result of setData visible to the parsing engine?

opened by mmelon 0
how to do if a cell has a long content and including newline ?

i have a sheet(csv), and some cells gets a long contents, including one/two newline, and i tried to parse the sheet with SimpleExcel, but found i can't get all contents of the cell, only the contents of the first line(before \n).

how to do with it ?

opened by huang-sheng 1