node_spreadsheet

Thanks to Shimon Doodkin for writing the original version of this module

Original repo can be found at: https://github.com/shimondoodkin/node_spreadsheet

#What Is This?
Node spreadsheet is a module to read and write Excel and CSV files using PHPExcel from phpexcel.codeplex.com.

#Installation
npm install node_spreadsheet

#Requirements
As this runs PHPExcel, you will need php5-cli installed. You'll also need Node.js

#Usage
To read in an excel file:

var spreadsheet=require('node_spreadsheet');
var basePath = __dirname;
var inputFile = basePath + "YourFile.xls";

spreadsheet.read(inputFile, function(err, data) {
if(!err) console.log(data);
});

To read in an excel file and convert it to an object:

var spreadsheet=require('node_spreadsheet');
var basePath = __dirname;
var inputFile = basePath + "YourFile.xls";

spreadsheet.readAndConvertToObject(inputFile, function(err, data) {
/*
A CSV containing the following data:
'Address', 'City', 'State', 'Zip'
'1515 S Main St', 'Los Angeles', 'CA', '90021'
'124 N Penrose Ave', 'Someplace', 'CA', '92022'

Will become:

[
{
address: '1515 S Main St',
city: 'Los Angeles',
state: 'CA',
zip: '90021'
},
{
address: '124 N Penrose Ave',
city: 'Someplace',
state: 'CA',
zip: '92022'
}
]
*/

if(!err) console.log(data);
});

To write an excel file:

var spreadsheet=require('node_spreadsheet');
var basePath = __dirname;
var outFile = basePath + "YourFile.xls";

var data = [
['Address', 'City', 'State', 'Zip'],
['1515 S Main St', 'Los Angeles', 'CA', '90021'],
['124 N Penrose Ave', 'Someplace', 'CA', '92022']
];

spreadsheet.write(data, outFile,function(err, fileName) {
if(!err) console.log(fileName);
});

To convert an excel file:

var spreadsheet=require('node_spreadsheet');
var basePath = __dirname;

var inFile = basePath + "YourFile.csv";
var outFile = basePath + "YourFile.xlsx";

spreadsheet.convert(inFile, outFile,function(err, fileName) {
if(!err) console.log(fileName);
});