XLGen
node.js's module to generate Microsoft Excel™ 97 ~ 2003 File(.xls)
Features
- Excel 97 ~ 2003 File Format(.xls)
- pure javascript on node.js
- lightweight javascript module
Changelog
v0.2.3
- fixed a bug Sometimes, When only string values fill into cells Excel appear it in the incorrect order
v0.2.2
- fixed issue#2
Unable to create more than one sheet in a workbook
v0.2.1
- added support for date - ivantodorovich
convert javascript date value to excel raw value(number) - added support number and date formats
- modified to overwrite a cell value
v0.1.0
- first release
API
- createXLGen( filePath)
create a XLGen object
XLGen class
-
formatStrings
standard number format stringsformatStrings.general: 'General', formatStrings.number0: '0', formatStrings.number1: '0.00', formatStrings.number2: '#,##0', formatStrings.number3: '#,##0.00', formatStrings.number4: '0%', formatStrings.number5: '0.00%', formatStrings.number6: '0.00E+00', formatStrings.number7: '# ?/?', formatStrings.number8: '# ??/??', formatStrings.number9: '#,##0 ;(#,##0)', formatStrings.number10: '#,##0 ;[Red](#,##0)', formatStrings.number11: '#,##0.00;(#,##0.00)', formatStrings.number12: '#,##0.00;[Red](#,##0.00)', formatStrings.number13: '##0.0E+0', formatStrings.date0: 'mm-dd-yy', formatStrings.date1: 'd-mmm-yy', formatStrings.date2: 'd-mmm', formatStrings.date3: 'mmm-yy', formatStrings.time0: 'h:mm AM/PM', formatStrings.time1: 'h:mm:ss AM/PM', formatStrings.time2: 'h:mm', formatStrings.time3: 'h:mm:ss', formatStrings.time4: 'mm:ss', formatStrings.time5: '[h]:mm:ss', formatStrings.time6: 'mmss.0', formatStrings.dateTime: 'm/d/yy h:mm', formatStrings.string: '@'
-
addFormat(formatString)
use to format a number and date type's value
formatString : a format string for a number formatting
return : a Format object -
addSheet(sheetName)
sheetName : a sheet name
return : a Sheet object -
end(callback)
flush all into a file and clean up all resources associated with the object.
after function 'end' has been called, cannot use xlg object again.
callback(err) : call this after ending a flush
Sheet class
- cell( rowIndex, colIndex, value, [format])
input value into cell.
rowIndex , colIndex: zero-based index
value : allow a Number, String, Date Type's value
format : optional, Format object added by addFormat function
Example
var xl = ;var xlg = xl; //register formatsvar fmtDate0 = xlg;var fmtDate1 = xlg;var fmtDate2 = xlg;var custfmtDate = xlg; var sht = xlg;//var sht = xlg.addSheet('시트1'); console;//print all standard format strings try sht; sht; sht; sht; sht; sht; sht; sht; sht; sht;catche console; xlg;
References
[MS-XLS]: Excel Binary File Format (.xls) Structure
License
MIT