node_spreadsheet

Node spreadsheet is a module to read and write Excel and CSV files using PHPExcel from phpexcel.codeplex.com.

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);
});