excel-parser
node wrapper for parsing spreadsheets. Supports xls, xlsx.
You can install this module using npm:
npm install excel-parser
Requires python to be installed
For system-specific installation view the Wiki
API ### worksheets(options, callback(err, worksheets))
Get all the worksheets list in given spreadsheet where options are the object of arguments. The result is returned as a object.
Arguments
- inFile - Filepath of the source speadsheet
Example
var excelParser = ;excelParser;
Sample output
### parse(options, callback(err, records))
Parse spreadsheet with given optinos as an arguments. The result is returned as an array.
Arguments
- inFile - Filepath of the source speadsheet
- worksheet - Worksheet name or Id to parse. If nothing specified then default is 0 and parsed all the worksheets.
- skipEmpty - boolean
true
orfalse
. Pass true if want to skip empty cells from spreadsheet. - searchFor - Object with
term
andtype
values. If you want to get limited matching rows from spreadsheet then add the matching string array and one of the following search type. ** 'strict' is for the case sensetive and exact string matched. ** 'loose' is for the case insensetive and match relatively.
Example
var excelParser = ; excelParser;
Sample output
Running Tests
There are unit tests in test/
directory. To run test suite first run the following command to install dependencies.
npm install
then run the tests:
grunt nodeunit
NOTE: Install npm install -g grunt-cli
for running tests.
License
Copyright (c) 2013 Shekhar R. Thawali
Licensed under the MIT license.