123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245
/* xlsx.js (C) 2013-present  SheetJS -- http://sheetjs.com *//* eslint-env node *//* vim: set ts=2 ft=javascript: *//// <reference types="../node_modules/@types/node/" />const n = "xlsx";import X = require("xlsx");import 'exit-on-epipe';import * as fs from 'fs';import program = require('commander');program	.version(X.version)	.usage('[options] <file> [sheetname]')	.option('-f, --file <file>', 'use specified workbook')	.option('-s, --sheet <sheet>', 'print specified sheet (default first sheet)')	.option('-N, --sheet-index <idx>', 'use specified sheet index (0-based)')	.option('-p, --password <pw>', 'if file is encrypted, try with specified pw')	.option('-l, --list-sheets', 'list sheet names and exit')	.option('-o, --output <file>', 'output to specified file')
	.option('-B, --xlsb', 'emit XLSB to <sheetname> or <file>.xlsb')	.option('-M, --xlsm', 'emit XLSM to <sheetname> or <file>.xlsm')	.option('-X, --xlsx', 'emit XLSX to <sheetname> or <file>.xlsx')	.option('-I, --xlam', 'emit XLAM to <sheetname> or <file>.xlam')	.option('-Y, --ods',  'emit ODS  to <sheetname> or <file>.ods')	.option('-8, --xls',  'emit XLS  to <sheetname> or <file>.xls (BIFF8)')	.option('-5, --biff5','emit XLS  to <sheetname> or <file>.xls (BIFF5)')	.option('-2, --biff2','emit XLS  to <sheetname> or <file>.xls (BIFF2)')	.option('-i, --xla',  'emit XLA to <sheetname> or <file>.xla')	.option('-6, --xlml', 'emit SSML to <sheetname> or <file>.xls (2003 XML)')	.option('-T, --fods', 'emit FODS to <sheetname> or <file>.fods (Flat ODS)')
	.option('-S, --formulae', 'emit list of values and formulae')	.option('-j, --json',     'emit formatted JSON (all fields text)')	.option('-J, --raw-js',   'emit raw JS object (raw numbers)')	.option('-A, --arrays',   'emit rows as JS objects (raw numbers)')	.option('-H, --html', 'emit HTML to <sheetname> or <file>.html')	.option('-D, --dif',  'emit DIF  to <sheetname> or <file>.dif (Lotus DIF)')	.option('-U, --dbf',  'emit DBF  to <sheetname> or <file>.dbf (MSVFP DBF)')	.option('-K, --sylk', 'emit SYLK to <sheetname> or <file>.slk (Excel SYLK)')	.option('-P, --prn',  'emit PRN  to <sheetname> or <file>.prn (Lotus PRN)')	.option('-E, --eth',  'emit ETH  to <sheetname> or <file>.eth (Ethercalc)')	.option('-t, --txt',  'emit TXT  to <sheetname> or <file>.txt (UTF-8 TSV)')	.option('-r, --rtf',  'emit RTF  to <sheetname> or <file>.txt (Table RTF)')	.option('-z, --dump', 'dump internal representation as JSON')	.option('--props',    'dump workbook properties as CSV')
	.option('-F, --field-sep <sep>', 'CSV field separator', ",")	.option('-R, --row-sep <sep>', 'CSV row separator', "\n")	.option('-n, --sheet-rows <num>', 'Number of rows to process (0=all rows)')	.option('--codepage <cp>', 'default to specified codepage when ambiguous')	.option('--req <module>', 'require module before processing')	.option('--sst', 'generate shared string table for XLS* formats')	.option('--compress', 'use compression when writing XLSX/M/B and ODS')	.option('--read', 'read but do not generate output')	.option('--book', 'for single-sheet formats, emit a file per worksheet')	.option('--all', 'parse everything; write as much as possible')	.option('--dev', 'development mode')	.option('--sparse', 'sparse mode')	.option('-q, --quiet', 'quiet mode');
program.on('--help', function() {	console.log('  Default output format is CSV');	console.log('  Support email: dev@sheetjs.com');	console.log('  Web Demo: http://oss.sheetjs.com/js-'+n+'/');});
/* flag, bookType, default ext */const workbook_formats = [	['xlsx',   'xlsx', 'xlsx'],	['xlsm',   'xlsm', 'xlsm'],	['xlam',   'xlam', 'xlam'],	['xlsb',   'xlsb', 'xlsb'],	['xls',     'xls',  'xls'],	['xla',     'xla',  'xla'],	['biff5', 'biff5',  'xls'],	['ods',     'ods',  'ods'],	['fods',   'fods', 'fods']];const wb_formats_2 = [	['xlml',   'xlml', 'xls']];program.parse(process.argv);
let filename = '', sheetname = '';if(program.args[0]) {	filename = program.args[0];	if(program.args[1]) sheetname = program.args[1];}if(program.sheet) sheetname = program.sheet;if(program.file) filename = program.file;
if(!filename) {	console.error(n + ": must specify a filename");	process.exit(1);}if(!fs.existsSync(filename)) {	console.error(n + ": " + filename + ": No such file or directory");	process.exit(2);}
const opts: X.ParsingOptions = {};let wb: X.WorkBook;if(program.listSheets) opts.bookSheets = true;if(program.sheetRows) opts.sheetRows = program.sheetRows;if(program.password) opts.password = program.password;let seen = false;function wb_fmt() {	seen = true;	opts.cellFormula = true;	opts.cellNF = true;	if(program.output) sheetname = program.output;}function isfmt(m: string): boolean {	if(!program.output) return false;	const t = m.charAt(0) === "." ? m : "." + m;	return program.output.slice(-t.length) === t;}workbook_formats.forEach(function(m) { if(program[m[0]] || isfmt(m[0])) { wb_fmt(); } });wb_formats_2.forEach(function(m) { if(program[m[0]] || isfmt(m[0])) { wb_fmt(); } });if(seen) {} else if(program.formulae) opts.cellFormula = true;else opts.cellFormula = false;
const wopts: X.WritingOptions = ({WTF:opts.WTF, bookSST:program.sst}/*:any*/);if(program.compress) wopts.compression = true;
if(program.all) {	opts.cellFormula = true;	opts.bookVBA = true;	opts.cellNF = true;	opts.cellHTML = true;	opts.cellStyles = true;	opts.sheetStubs = true;	opts.cellDates = true;	wopts.cellStyles = true;	wopts.bookVBA = true;}if(program.sparse) opts.dense = false; else opts.dense = true;if(program.codepage) opts.codepage = +program.codepage;
if(program.dev) {	opts.WTF = true;	wb = X.readFile(filename, opts);} else try {	wb = X.readFile(filename, opts);} catch(e) {	let msg = (program.quiet) ? "" : n + ": error parsing ";	msg += filename + ": " + e;	console.error(msg);	process.exit(3);}if(program.read) process.exit(0);if(!wb) { console.error(n + ": error parsing " + filename + ": empty workbook"); process.exit(0); }/*:: if(!wb) throw new Error("unreachable"); */if(program.listSheets) {	console.log((wb.SheetNames||[]).join("\n"));	process.exit(0);}if(program.dump) {	console.log(JSON.stringify(wb));	process.exit(0);}if(program.props) {	dump_props(wb);	process.exit(0);}
/* full workbook formats */workbook_formats.forEach(function(m) { if(program[m[0]] || isfmt(m[0])) {		wopts.bookType = <X.BookType>(m[1]);		X.writeFile(wb, program.output || sheetname || ((filename || "") + "." + m[2]), wopts);		process.exit(0);} });
wb_formats_2.forEach(function(m) { if(program[m[0]] || isfmt(m[0])) {		wopts.bookType = <X.BookType>(m[1]);		X.writeFile(wb, program.output || sheetname || ((filename || "") + "." + m[2]), wopts);		process.exit(0);} });
let target_sheet = sheetname || '';if(target_sheet === '') {	if(program.sheetIndex < (wb.SheetNames||[]).length) target_sheet = wb.SheetNames[program.sheetIndex];	else target_sheet = (wb.SheetNames||[""])[0];}
let ws: X.WorkSheet;try {	ws = wb.Sheets[target_sheet];	if(!ws) {		console.error("Sheet " + target_sheet + " cannot be found");		process.exit(3);	}} catch(e) {	console.error(n + ": error parsing "+filename+" "+target_sheet+": " + e);	process.exit(4);}
if(!program.quiet && !program.book) console.error(target_sheet);
/* single worksheet file formats */[	['biff2', '.xls'],	['biff3', '.xls'],	['biff4', '.xls'],	['sylk', '.slk'],	['html', '.html'],	['prn', '.prn'],	['eth', '.eth'],	['rtf', '.rtf'],	['txt', '.txt'],	['dbf', '.dbf'],	['dif', '.dif']].forEach(function(m) { if(program[m[0]] || isfmt(m[1])) {		wopts.bookType = <X.BookType>(m[0]);		X.writeFile(wb, program.output || sheetname || ((filename || "") + m[1]), wopts);		process.exit(0);} });
let oo = "", strm = false;if(!program.quiet) console.error(target_sheet);if(program.formulae) oo = X.utils.sheet_to_formulae(ws).join("\n");else if(program.json) oo = JSON.stringify(X.utils.sheet_to_json(ws));else if(program.rawJs) oo = JSON.stringify(X.utils.sheet_to_json(ws,{raw:true}));else if(program.arrays) oo = JSON.stringify(X.utils.sheet_to_json(ws,{raw:true, header:1}));else {	strm = true;	const stream: NodeJS.ReadableStream = X.stream.to_csv(ws, {FS:program.fieldSep, RS:program.rowSep});	if(program.output) stream.pipe(fs.createWriteStream(program.output));	else stream.pipe(process.stdout);}
if(!strm) {	if(program.output) fs.writeFileSync(program.output, oo);	else console.log(oo);}/*::   } *//*:: } */
function dump_props(wb: X.WorkBook) {	let propaoa: any[][] = [];	propaoa = (<any>Object).entries({...wb.Props, ...wb.Custprops});	console.log(X.utils.sheet_to_csv(X.utils.aoa_to_sheet(propaoa)));}