123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270
/*::type MJRObject = {	row: any;	isempty: boolean;};*/function make_json_row(sheet/*:Worksheet*/, r/*:Range*/, R/*:number*/, cols/*:Array<string>*/, header/*:number*/, hdr/*:Array<any>*/, dense/*:boolean*/, o/*:Sheet2JSONOpts*/)/*:MJRObject*/ {	var rr = encode_row(R);	var defval = o.defval, raw = o.raw || !Object.prototype.hasOwnProperty.call(o, "raw");	var isempty = true;	var row/*:any*/ = (header === 1) ? [] : {};	if(header !== 1) {		if(Object.defineProperty) try { Object.defineProperty(row, '__rowNum__', {value:R, enumerable:false}); } catch(e) { row.__rowNum__ = R; }		else row.__rowNum__ = R;	}	if(!dense || sheet[R]) for (var C = r.s.c; C <= r.e.c; ++C) {		var val = dense ? sheet[R][C] : sheet[cols[C] + rr];		if(val === undefined || val.t === undefined) {			if(defval === undefined) continue;			if(hdr[C] != null) { row[hdr[C]] = defval; }			continue;		}		var v = val.v;		switch(val.t){			case 'z': if(v == null) break; continue;			case 'e': v = (v == 0 ? null : void 0); break;			case 's': case 'd': case 'b': case 'n': break;			default: throw new Error('unrecognized type ' + val.t);		}		if(hdr[C] != null) {			if(v == null) {				if(val.t == "e" && v === null) row[hdr[C]] = null;				else if(defval !== undefined) row[hdr[C]] = defval;				else if(raw && v === null) row[hdr[C]] = null;				else continue;			} else {				row[hdr[C]] = raw || (o.rawNumbers && val.t == "n") ? v : format_cell(val,v,o);			}			if(v != null) isempty = false;		}	}	return { row: row, isempty: isempty };}

function sheet_to_json(sheet/*:Worksheet*/, opts/*:?Sheet2JSONOpts*/) {	if(sheet == null || sheet["!ref"] == null) return [];	var val = {t:'n',v:0}, header = 0, offset = 1, hdr/*:Array<any>*/ = [], v=0, vv="";	var r = {s:{r:0,c:0},e:{r:0,c:0}};	var o = opts || {};	var range = o.range != null ? o.range : sheet["!ref"];	if(o.header === 1) header = 1;	else if(o.header === "A") header = 2;	else if(Array.isArray(o.header)) header = 3;	else if(o.header == null) header = 0;	switch(typeof range) {		case 'string': r = safe_decode_range(range); break;		case 'number': r = safe_decode_range(sheet["!ref"]); r.s.r = range; break;		default: r = range;	}	if(header > 0) offset = 0;	var rr = encode_row(r.s.r);	var cols/*:Array<string>*/ = [];	var out/*:Array<any>*/ = [];	var outi = 0, counter = 0;	var dense = Array.isArray(sheet);	var R = r.s.r, C = 0, CC = 0;	if(dense && !sheet[R]) sheet[R] = [];	for(C = r.s.c; C <= r.e.c; ++C) {		cols[C] = encode_col(C);		val = dense ? sheet[R][C] : sheet[cols[C] + rr];		switch(header) {			case 1: hdr[C] = C - r.s.c; break;			case 2: hdr[C] = cols[C]; break;			case 3: hdr[C] = o.header[C - r.s.c]; break;			default:				if(val == null) val = {w: "__EMPTY", t: "s"};				vv = v = format_cell(val, null, o);				counter = 0;				for(CC = 0; CC < hdr.length; ++CC) if(hdr[CC] == vv) vv = v + "_" + (++counter);				hdr[C] = vv;		}	}	for (R = r.s.r + offset; R <= r.e.r; ++R) {		var row = make_json_row(sheet, r, R, cols, header, hdr, dense, o);		if((row.isempty === false) || (header === 1 ? o.blankrows !== false : !!o.blankrows)) out[outi++] = row.row;	}	out.length = outi;	return out;}
var qreg = /"/g;function make_csv_row(sheet/*:Worksheet*/, r/*:Range*/, R/*:number*/, cols/*:Array<string>*/, fs/*:number*/, rs/*:number*/, FS/*:string*/, o/*:Sheet2CSVOpts*/)/*:?string*/ {	var isempty = true;	var row/*:Array<string>*/ = [], txt = "", rr = encode_row(R);	for(var C = r.s.c; C <= r.e.c; ++C) {		if (!cols[C]) continue;		var val = o.dense ? (sheet[R]||[])[C]: sheet[cols[C] + rr];		if(val == null) txt = "";		else if(val.v != null) {			isempty = false;			txt = ''+(o.rawNumbers && val.t == "n" ? val.v : format_cell(val, null, o));			for(var i = 0, cc = 0; i !== txt.length; ++i) if((cc = txt.charCodeAt(i)) === fs || cc === rs || cc === 34 || o.forceQuotes) {txt = "\"" + txt.replace(qreg, '""') + "\""; break; }			if(txt == "ID") txt = '"ID"';		} else if(val.f != null && !val.F) {			isempty = false;			txt = '=' + val.f; if(txt.indexOf(",") >= 0) txt = '"' + txt.replace(qreg, '""') + '"';		} else txt = "";		/* NOTE: Excel CSV does not support array formulae */		row.push(txt);	}	if(o.blankrows === false && isempty) return null;	return row.join(FS);}
function sheet_to_csv(sheet/*:Worksheet*/, opts/*:?Sheet2CSVOpts*/)/*:string*/ {	var out/*:Array<string>*/ = [];	var o = opts == null ? {} : opts;	if(sheet == null || sheet["!ref"] == null) return "";	var r = safe_decode_range(sheet["!ref"]);	var FS = o.FS !== undefined ? o.FS : ",", fs = FS.charCodeAt(0);	var RS = o.RS !== undefined ? o.RS : "\n", rs = RS.charCodeAt(0);	var endregex = new RegExp((FS=="|" ? "\\|" : FS)+"+$");	var row = "", cols/*:Array<string>*/ = [];	o.dense = Array.isArray(sheet);	var colinfo/*:Array<ColInfo>*/ = o.skipHidden && sheet["!cols"] || [];	var rowinfo/*:Array<ColInfo>*/ = o.skipHidden && sheet["!rows"] || [];	for(var C = r.s.c; C <= r.e.c; ++C) if (!((colinfo[C]||{}).hidden)) cols[C] = encode_col(C);	for(var R = r.s.r; R <= r.e.r; ++R) {		if ((rowinfo[R]||{}).hidden) continue;		row = make_csv_row(sheet, r, R, cols, fs, rs, FS, o);		if(row == null) { continue; }		if(o.strip) row = row.replace(endregex,"");		out.push(row + RS);	}	delete o.dense;	return out.join("");}
function sheet_to_txt(sheet/*:Worksheet*/, opts/*:?Sheet2CSVOpts*/) {	if(!opts) opts = {}; opts.FS = "\t"; opts.RS = "\n";	var s = sheet_to_csv(sheet, opts);	if(typeof cptable == 'undefined' || opts.type == 'string') return s;	var o = cptable.utils.encode(1200, s, 'str');	return String.fromCharCode(255) + String.fromCharCode(254) + o;}
function sheet_to_formulae(sheet/*:Worksheet*/)/*:Array<string>*/ {	var y = "", x, val="";	if(sheet == null || sheet["!ref"] == null) return [];	var r = safe_decode_range(sheet['!ref']), rr = "", cols/*:Array<string>*/ = [], C;	var cmds/*:Array<string>*/ = [];	var dense = Array.isArray(sheet);	for(C = r.s.c; C <= r.e.c; ++C) cols[C] = encode_col(C);	for(var R = r.s.r; R <= r.e.r; ++R) {		rr = encode_row(R);		for(C = r.s.c; C <= r.e.c; ++C) {			y = cols[C] + rr;			x = dense ? (sheet[R]||[])[C] : sheet[y];			val = "";			if(x === undefined) continue;			else if(x.F != null) {				y = x.F;				if(!x.f) continue;				val = x.f;				if(y.indexOf(":") == -1) y = y + ":" + y;			}			if(x.f != null) val = x.f;			else if(x.t == 'z') continue;			else if(x.t == 'n' && x.v != null) val = "" + x.v;			else if(x.t == 'b') val = x.v ? "TRUE" : "FALSE";			else if(x.w !== undefined) val = "'" + x.w;			else if(x.v === undefined) continue;			else if(x.t == 's') val = "'" + x.v;			else val = ""+x.v;			cmds[cmds.length] = y + "=" + val;		}	}	return cmds;}
function sheet_add_json(_ws/*:?Worksheet*/, js/*:Array<any>*/, opts)/*:Worksheet*/ {	var o = opts || {};	var offset = +!o.skipHeader;	var ws/*:Worksheet*/ = _ws || ({}/*:any*/);	var _R = 0, _C = 0;	if(ws && o.origin != null) {		if(typeof o.origin == 'number') _R = o.origin;		else {			var _origin/*:CellAddress*/ = typeof o.origin == "string" ? decode_cell(o.origin) : o.origin;			_R = _origin.r; _C = _origin.c;		}	}	var cell/*:Cell*/;	var range/*:Range*/ = ({s: {c:0, r:0}, e: {c:_C, r:_R + js.length - 1 + offset}}/*:any*/);	if(ws['!ref']) {		var _range = safe_decode_range(ws['!ref']);		range.e.c = Math.max(range.e.c, _range.e.c);		range.e.r = Math.max(range.e.r, _range.e.r);		if(_R == -1) { _R = _range.e.r + 1; range.e.r = _R + js.length - 1 + offset; }	} else {		if(_R == -1) { _R = 0; range.e.r = js.length - 1 + offset; }	}	var hdr/*:Array<string>*/ = o.header || [], C = 0;
	js.forEach(function (JS, R/*:number*/) {		keys(JS).forEach(function(k) {			if((C=hdr.indexOf(k)) == -1) hdr[C=hdr.length] = k;			var v = JS[k];			var t = 'z';			var z = "";			var ref = encode_cell({c:_C + C,r:_R + R + offset});			cell = utils.sheet_get_cell(ws, ref);			if(v && typeof v === 'object' && !(v instanceof Date)){				ws[ref] = v;			} else {				if(typeof v == 'number') t = 'n';				else if(typeof v == 'boolean') t = 'b';				else if(typeof v == 'string') t = 's';				else if(v instanceof Date) {					t = 'd';					if(!o.cellDates) { t = 'n'; v = datenum(v); }					z = (o.dateNF || SSF._table[14]);				}				else if(v === null && o.nullError) { t = 'e'; v = 0; }				if(!cell) ws[ref] = cell = ({t:t, v:v}/*:any*/);				else {					cell.t = t; cell.v = v;					delete cell.w; delete cell.R;					if(z) cell.z = z;				}				if(z) cell.z = z;			}		});	});	range.e.c = Math.max(range.e.c, _C + hdr.length - 1);	var __R = encode_row(_R);	if(offset) for(C = 0; C < hdr.length; ++C) ws[encode_col(C + _C) + __R] = {t:'s', v:hdr[C]};	ws['!ref'] = encode_range(range);	return ws;}function json_to_sheet(js/*:Array<any>*/, opts)/*:Worksheet*/ { return sheet_add_json(null, js, opts); }
var utils/*:any*/ = {	encode_col: encode_col,	encode_row: encode_row,	encode_cell: encode_cell,	encode_range: encode_range,	decode_col: decode_col,	decode_row: decode_row,	split_cell: split_cell,	decode_cell: decode_cell,	decode_range: decode_range,	format_cell: format_cell,	sheet_add_aoa: sheet_add_aoa,	sheet_add_json: sheet_add_json,	sheet_add_dom: sheet_add_dom,	aoa_to_sheet: aoa_to_sheet,	json_to_sheet: json_to_sheet,	table_to_sheet: parse_dom_table,	table_to_book: table_to_book,	sheet_to_csv: sheet_to_csv,	sheet_to_txt: sheet_to_txt,	sheet_to_json: sheet_to_json,	sheet_to_html: HTML_.from_sheet,	sheet_to_formulae: sheet_to_formulae,	sheet_to_row_object_array: sheet_to_json};