excel-api

node-excel-api

node-excel-api is a simple wrapper arround the mature JExcelApi project. So most APIs of JExcelApi are left unchanged. You can view documentation in JExcelApi's javadoc

Some methods are modified a little bit, see lib/excel.iced

Examples

Parsing

Workbook = require('excel-api').Workbook;
// http://jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/jxl/Workbook.html#getWorkbook(java.io.File)
Workbook.getWorkbook('./input.xls', function(err, workbook){
  
  // http://jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/jxl/Workbook.html#getSheetNames()
  workbook.getSheetNames(function(err, names){
    console.log('sheets: ' + names);

    // http://jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/jxl/Workbook.html#getSheet(java.lang.String)
    workbook.getSheet('Sheet1', function(err, sheet){

      // http://jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/jxl/Sheet.html#getRows(int)
      sheet.getRows(function(err, rows){
        console.log('rows: ' + rows);

        for(var i = 0; i < rows; i++){
          
          // http://jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/jxl/Sheet.html#getRow(int)
          sheet.getRow(function(err, cells){
            for(var j = 0; j < cells.length; j++){

              // http://jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/jxl/Cell.html#getContents()
              cells[j].getContents(function(err, content){
                console.log(i + 'x' + j + ': ' + content);
              });
            }
          });
        }
      });
    });
  });
});