1.0.2 • Published 8 years ago
allto-json v1.0.2
Convert files to JSON
#Install
npm install allto-json
#How to use?
##1.CSV
require('allto-json').csv('sample.csv',function(err,result){
console.log(result);
})
####CSV to JSON file
require('allto-json').csvFile('sample.csv')
##2.XML
require('allto-json').xml('sample.xml',function(error,result){
console.log(result)
})
####XML to JSON file
require('allto-json').xmlFile('sample.xml')
##3.xlsx
require('allto-json').xlsx(('sample.xlsx'),function(error,result){
console.log(result)
})
####xlsx to JSON file
require('allto-json').xlsxFile('sample.xlsx')
##4.xls
require('allto-json').xls(('sample.xls'),function(error,result){
console.log(result)
})
####xls to JSON file
require('allto-json').xlsFile('sample.xml')
#API
##1.CSV
csv(filename,opts,callback)
opts is optional,below is available options
- encoding: default to utf8
- delimiter: default to ,
- newlint: default to \n
- quote: default to \"
- header: default to false
csvFile(filename,opts)
no callback require,opts is same as above.
##2.XML
xml(filename,callback)
no opts
xml(filename)
no callback
##3.xlsx
xlsx(filename, opts, callback)
opts is optional,below is available options
second colume shows default value
- cellFormula true Save formulae to the .f field **
- cellHTML true Parse rich text and save HTML to the .h field
- cellNF false Save number format string to the .z field
- cellStyles false Save style/theme info to the .s field
- cellDates false Store dates as type d (default is n) **
- sheetStubs false Create cell objects for stub cells
- sheetRows 0 If >0, read the first sheetRows rows **
- bookDeps false If true, parse calculation chains
- bookFiles false If true, add raw files to book object **
- bookProps false If true, only parse enough to get book metadata **
- bookSheets false If true, only parse enough to get the sheet names
- bookVBA false If true, expose vbaProject.bin to vbaraw field **
- password "" If defined and file is encrypted, use password **
xlsxFile(filename,opts)
opts is same as above.
##4.xls
xls(filename, opts, callback)
opts is optional,below is available options
second colume shows default value
- cellFormula true Save formulae to the .f field **
- cellNF false Save number format string to the .z field
- cellStyles false Save style/theme info to the .s field
- sheetRows 0 If >0, read the first sheetRows rows **
- bookFiles false If true, add raw files to book object **
- bookProps false If true, only parse enough to get book metadata **
- bookSheets false If true, only parse enough to get the sheet names
- password "" If defined and file is encrypted, use password **
xls(filename, opts)
opts is same as above
you can use opts like this
csv(filename,{header:true},callback)
License
MIT