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