Download the PHP package linio/spreadsheet-parser without Composer
On this page you can find all versions of the php package linio/spreadsheet-parser. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package spreadsheet-parser
Linio Spreadsheet Parser
Linio Spreadsheet Parser allows you to parse and import data files. This component supports both text and binary file formats.
Install
The recommended way to install Linio Spreadsheet Parser is through composer.
Tests
To run the test suite, you need install the dependencies via composer, then run PHPUnit.
$ composer install
$ vendor/bin/phpunit
Usage
There are two ways of using the parser: standalone or as a service.
Standalone
Service
Methods
Constructor
The $fileType
parameter is optional. If not present, it will use the file extension to determine its type.
open
This method opens the file. This is an optional step as the methods that read from the file will open the file automatically if the file was not opened before they are called.
getColumnNames
This method returns the column names from the file (first row) or false
if the option has_column_names
was set to false when creating the Spreadsheet
object.
getData
close
This method closes the open handles and deletes the temporary files created. It should always be called when you don't need to access the file anymore.
Parsers
csv
Parser for CSV files.
Parser options:
CsvParser::OPTION_HAS_COLUMN_NAMES
(defaults totrue
)CsvParser::OPTION_LENGTH
(defaults to0
)CsvParser::OPTION_DELIMITER
(defaults to,
)CsvParser::OPTION_ENCLOSURE
(defaults to"
)CsvParser::OPTION_ESCAPE
(defaults to\
)
xlsx
Parser for XLSX (Excel 2007+) files.
The OPTION_SHEET_INDEX
setting specifies the desired sheet index to import within the file.
The OPTION_SHEET_NAME
setting has precedence over the setting OPTION_SHEET_INDEX
. If both are specified, the parser will only try to use the sheet specified by OPTION_SHEET_NAME
.
Parser options:
XlsxParser::OPTION_HAS_COLUMN_NAMES
(defaults totrue
)XlsxParser::OPTION_SHEET_INDEX
(defaults to1
)XlsxParser::OPTION_SHEET_NAME
(defaults tonull
)