1. module excel-export
   1. function excel-export.execute (config)
   2. function excel-export.executeAsync (config, callBack)
   3. function excel-export.sheet (config, xlsx, shareStrings, convertedShareStrings)
   4. object excel-export.sheet.prototype
2. module excel-export.sheet
   1. function excel-export.sheet (config, xlsx, shareStrings, convertedShareStrings)
3. module excel-export.sheet.prototype
   1. function excel-export.sheet.prototype.generate ()

module excel-export

function excel-export.execute (config)

• description and source-code

  execute = function (config) {
  	var xlsx = new JSZip(templateXLSX, {
  		base64: true,
  		checkCRC32: false
  	});
  	shareStrings = new SortedMap();
  	convertedShareStrings = "";
  
  	var configs = [];
  	if (config instanceof Array) {
  		configs = config;
  	}else{
  		configs.push(config);
  	}
  	generateMultiSheets(configs, xlsx);
  	generateWorkbook(configs, xlsx);
  	generateRel(configs,xlsx) ;
  	generateContentType(configs, xlsx);
  	generateSharedStringsFile(xlsx);
  	var results = xlsx.generate({
  		base64: false,
  		compression: "DEFLATE"
  	});
  	delete shareStrings;
  	delete xlsx;
  	return results;
  }

• example usage

  ...
  	  	}];
  	  	conf.rows = [
  	 		['pi', new Date(Date.UTC(2013, 4, 1)), true, 3.14],
  	 		["e", new Date(2012, 4, 1), false, 2.7182],
              ["M&M<>'", new Date(Date.UTC(2013, 6, 9)), false, 1.61803],
              ["null date", null, true, 1.414]
  	  	];
  	  	var result = nodeExcel.execute(conf);
  	  	res.setHeader('Content-Type', 'application/vnd.openxmlformats');
  	  	res.setHeader("Content-Disposition", "attachment; filename=" + "Report.xlsx");
  	  	res.end(result, 'binary');
  	});
  
  	app.listen(3000);
  	console.log('Listening on port 3000');
  ...

function excel-export.executeAsync (config, callBack)

• description and source-code

  executeAsync = function (config, callBack) {
  	return process.nextTick(function() {
  		var r = exports.execute(config);
  		callBack(r);
  	});
  }

• example usage

  n/a

function excel-export.sheet (config, xlsx, shareStrings, convertedShareStrings)

• description and source-code

  function Sheet(config, xlsx, shareStrings, convertedShareStrings){
    this.config = config;
    this.xlsx = xlsx;
    this.shareStrings = shareStrings;
    this.convertedShareStrings = convertedShareStrings;
  }

• example usage

  n/a

module excel-export.sheet

function excel-export.sheet (config, xlsx, shareStrings, convertedShareStrings)

• description and source-code

  function Sheet(config, xlsx, shareStrings, convertedShareStrings){
    this.config = config;
    this.xlsx = xlsx;
    this.shareStrings = shareStrings;
    this.convertedShareStrings = convertedShareStrings;
  }

• example usage

  n/a

module excel-export.sheet.prototype

function excel-export.sheet.prototype.generate ()

• description and source-code

  generate = function (){
    var config = this.config, xlsx = this.xlsx;
  	var cols = config.cols,
  	data = config.rows,
  	colsLength = cols.length,
  	rows = "",
  	row = "",
  	colsWidth = "",
  	styleIndex,
    self = this,
  	k;
  	config.fileName = 'xl/worksheets/' + (config.name || "sheet").replace(/[*?\]\[\/\/]/g, '') + '.xml';
  	if (config.stylesXmlFile) {
  		var path = config.stylesXmlFile;
  		var styles = null;
  		styles = fs.readFileSync(path, 'utf8');
  		if (styles) {
  			xlsx.file("xl/styles.xml", styles);
  		}
  	}
  
  	//first row for column caption
  	row = '<x:row r="1" spans="1:' + colsLength + '">';
  	var colStyleIndex;
  	for (k = 0; k < colsLength; k++) {
  		colStyleIndex = cols[k].captionStyleIndex || 0;
  		row += addStringCell(self, getColumnLetter(k + 1) + 1, cols[k].caption, colStyleIndex);
  		if (cols[k].width) {
  			colsWidth += '<col customWidth = "1" width="' + cols[k].width + '" max = "' + (k + 1) + '" min="' + (k + 1) + '"/>';
  		}
  	}
  	row += '</x:row>';
  	rows += row;
  
  	//fill in data
  	var i, j, r, cellData, currRow, cellType, dataLength = data.length;
  
  	for (i = 0; i < dataLength; i++) {
  		r = data[i],
  		currRow = i + 2;
  		row = '<x:row r="' + currRow + '" spans="1:' + colsLength + '">';
  		for (j = 0; j < colsLength; j++) {
  			styleIndex = null;
  			cellData = r[j];
  			cellType = cols[j].type;
  			if (typeof cols[j].beforeCellWrite === 'function') {
  				var e = {
  					rowNum: currRow,
  					styleIndex: null,
  					cellType: cellType
  				};
  				cellData = cols[j].beforeCellWrite(r, cellData, e);
  				styleIndex = e.styleIndex || styleIndex;
  				cellType = e.cellType;
  				delete e;
  			}
  			switch (cellType) {
  			case 'number':
  				row += addNumberCell(getColumnLetter(j + 1) + currRow, cellData, styleIndex);
  				break;
  			case 'date':
  				row += addDateCell(getColumnLetter(j + 1) + currRow, cellData, styleIndex);
  				break;
  			case 'bool':
  				row += addBoolCell(getColumnLetter(j + 1) + currRow, cellData, styleIndex);
  				break;
  			default:
  				row += addStringCell(self, getColumnLetter(j + 1) + currRow, cellData, styleIndex);
  			}
  		}
  		row += '</x:row>';
  		rows += row;
  	}
  	if (colsWidth !== "") {
  		sheetFront += '<cols>' + colsWidth + '</cols>';
  	}
  	xlsx.file(config.fileName, sheetFront + '<x:sheetData>' + rows + '</x:sheetData>' + sheetBack);
  }

• example usage

  ...
  
  function generateMultiSheets(configs, xlsx) {
  	var i = 1;
  	configs.forEach(function(config) {
  		config.name = config.name ? config.name : ('sheet'+i);
  		i++;
      var sheet = new Sheet(config, xlsx, shareStrings, convertedShareStrings);
  		sheet.generate();
      convertedShareStrings = sheet.convertedShareStrings
  	});
  }
  
  function generateContentType(configs, xlsx) {
  	var workbook = contentTypeFront;
  	configs.forEach( function(config) {
  ...