Lines Matching refs:SheetNames
4381 return { SheetNames: [n], Sheets: sheets };
5668 "Worksheets", "SheetNames",
5697 props.SheetNames = parts.slice(idx, idx + len);
5762 …o[o.length] = (W('TitlesOfParts', W('vt:vector', cp.SheetNames.map(function(s) { return "<vt:lpstr…
5890 var BLACKLIST = ["Worksheets","SheetNames"];
7884 return ({SheetNames:[],Sheets:{}});
8853 if(!realnames.length) return { SheetNames: snames, Sheets: sheets };
8863 return { SheetNames: rnames, Sheets: osheets };
8908 …; i < wb.SheetNames.length; ++i) if((wb.Sheets[wb.SheetNames[i]] || {})["!ref"]) write_biff_rec(ba…
8911 for(i = 0; i < wb.SheetNames.length; ++i) {
8912 var ws = wb.Sheets[wb.SheetNames[i]];
8955 for(var i = 0; i < wb.SheetNames.length; ++i) {
8956 var name = wb.SheetNames[i];
9638 var wb = { SheetNames: [], Sheets: {} };
13266 if(opts.biff > 8 && (!supbooks.XTI || !supbooks.XTI[ixti])) return supbooks.SheetNames[ixti];
13278 o = XTI[1] == -1 ? "#REF" : supbooks.SheetNames[XTI[1]];
13279 return XTI[1] == XTI[2] ? o : o + ":" + supbooks.SheetNames[XTI[2]];
13281 if(opts.SID != null) return supbooks.SheetNames[opts.SID];
13289 o = XTI[1] == -1 ? "#REF" : (supbooks.SheetNames[XTI[1]] || "SH33TJSERR3");
13290 return XTI[1] == XTI[2] ? o : o + ":" + supbooks.SheetNames[XTI[2]];
13454 o = supbooks.SheetNames[supbooks[bookidx][nameidx].itab-1] + "!";
13457 else o = supbooks.SheetNames[nameidx-1]+ "!";
13816 …out.write_shift(2, 2 + wb.SheetNames.map(function(n) { return n.toLowerCase(); }).indexOf(sname.to…
13834 …out.write_shift(2, 2 + wb.SheetNames.map(function(n) { return n.toLowerCase(); }).indexOf(sname.to…
13885 …out.write_shift(2, 2 + wb.SheetNames.map(function(n) { return n.toLowerCase(); }).indexOf(sname.to…
13892 …out.write_shift(2, 2 + wb.SheetNames.map(function(n) { return n.toLowerCase(); }).indexOf(sname.to…
13916 …out.write_shift(2, 2 + wb.SheetNames.map(function(n) { return n.toLowerCase(); }).indexOf(sname.to…
15356 var cname = wb.SheetNames[idx];
15471 name.Ref = formula_quote_sheet_name(wb.SheetNames[idx]) + "!" + fix_range(ref); break;
15473 … names.push({ Name: '_xlnm._FilterDatabase', Sheet: idx, Ref: "'" + wb.SheetNames[idx] + "'!" + re…
15786 var s = wb.SheetNames[idx], sidx = 0, rdata = "";
16431 supbooks.SheetNames = wb.SheetNames || wb.Sheets.map(function(x) { return x.name; });
16842 name.Ref = formula_quote_sheet_name(wb.SheetNames[idx]) + "!" + fix_range(ref); break;
16844 … '_xlnm._FilterDatabase', Sheet: idx, Ref: formula_quote_sheet_name(wb.SheetNames[idx]) + "!" + fi…
16881 var s = wb.SheetNames[idx], ws = wb.Sheets[s] || {};
17218 if(!wb || !wb.SheetNames || !wb.Sheets) throw new Error("Invalid Workbook");
17219 if(!wb.SheetNames.length) throw new Error("Workbook is empty");
17221 check_wb_names(wb.SheetNames, Sheets, !!wb.vbaraw);
17222 …for(var i = 0; i < wb.SheetNames.length; ++i) check_ws(wb.Sheets[wb.SheetNames[i]], wb.SheetNames[…
17223 wb.SheetNames.forEach(function(n, i) {
17431 for(i = 0; i != wb.SheetNames.length; ++i) {
17435 if(i == wb.SheetNames.length) i = 0;
17441 for(i = 0; i != wb.SheetNames.length; ++i) {
17442 var sht = ({name:escapexml(wb.SheetNames[i].slice(0,31))}/*:any*/);
17610 supbooks.SheetNames = [];
17618 supbooks.SheetNames.push(val.name);
17712 for(var idx = 0; idx != wb.SheetNames.length; ++idx) {
17714 var d = { Hidden: viz, iTabID: idx+1, strRelID: 'rId' + (idx+1), name: wb.SheetNames[idx] };
17773 var L = wb.SheetNames.length;
18809 out.SheetNames = sheetnames;
19097 var s = wb.SheetNames[idx];
19130 for(var i = 0; i < wb.SheetNames.length; ++i)
19131 …d.push(writextag("Worksheet", write_ws_xlml(i, opts, wb), {"ss:Name":escapexml(wb.SheetNames[i])})…
19328 supbooks.SheetNames = opts.snames;
19732 …wb.SheetNames=keys(Directory).sort(function(a,b) { return Number(a) - Number(b); }).map(function(x…
19734 if(!wb.SheetNames.length && Preamble["!ref"]) {
19735 wb.SheetNames.push("Sheet1");
19740 …if(wb.Sheets) FilterDatabases.forEach(function(r,i) { wb.Sheets[wb.SheetNames[i]]['!autofilter'] =…
21308 for(var i=0;i<wb.SheetNames.length;++i) if(wb.SheetNames[i] == o.sheet) idx=i;
21309 …if(idx == 0 && !!o.sheet && wb.SheetNames[0] != o.sheet) throw new Error("Sheet not found: " + o.s…
21312 write_ws_biff2(ba, wb.Sheets[wb.SheetNames[idx]], idx, o, wb);
21410 var s = wb.SheetNames[idx], ws = wb.Sheets[s] || {};
21500 write_biff_rec(A, 0x013d /* RRTabId */, write_RRTabId(wb.SheetNames.length));
21545 …for(j = 0; j < wb.SheetNames.length; ++j) blen += (b8 ? 12 : 11) + (b8 ? 2 : 1) * wb.SheetNames[j]…
21547 for(j = 0; j < wb.SheetNames.length; ++j) {
21549 …Sheet8 */, write_BoundSheet8({pos:start, hs:_sheet.Hidden||0, dt:0, name:wb.SheetNames[j]}, opts));
21586 for(var i = 0; i < wb.SheetNames.length; ++i) bufs[bufs.length] = write_ws_biff8(i, o, wb);
21592 for(var i = 0; i <= wb.SheetNames.length; ++i) {
21593 var ws = wb.Sheets[wb.SheetNames[i]];
21597 …if(typeof console != "undefined" && console.error) console.error("Worksheet '" + wb.SheetNames[i] …
22097 var Sheets = {}, SheetNames/*:Array<string>*/ = []; variable
22134 SheetNames.push(sheetag.name);
22403 if(intable) nrange.Sheet = SheetNames.length;
22607 SheetNames: SheetNames, property in out
22815 function write_names_ods(Names, SheetNames, idx) { argument
22842 …o.push(' <table:table table:name="' + escapexml(wb.SheetNames[i]) + '" table:style-name="ta1"…
22920 if((wb.Workbook||{}).Names) o.push(write_names_ods(wb.Workbook.Names, wb.SheetNames, i));
22930 wb.SheetNames.map(function(n) { return wb.Sheets[n]; }).forEach(function(ws) {
22949 wb.SheetNames.map(function(n) { return wb.Sheets[n]; }).forEach(function(ws) {
22979 wb.SheetNames.map(function(n) { return wb.Sheets[n]; }).forEach(function(ws) {
23060 …for(var i = 0; i != wb.SheetNames.length; ++i) o.push(write_ws(wb.Sheets[wb.SheetNames[i]], wb, i,…
23061 if((wb.Workbook||{}).Names) o.push(write_names_ods(wb.Workbook.Names, wb.SheetNames, -1));
24152 if (out.SheetNames.length == 0)
24362 wb.SheetNames.forEach(function(name, idx) {
25220 else if(props.Worksheets && props.SheetNames.length > 0) sheets=props.SheetNames;
25222 if(opts.bookSheets && typeof sheets !== 'undefined') out.SheetNames = sheets;
25223 if(opts.bookSheets ? out.SheetNames : opts.bookProps) return out;
25237 props.SheetNames = [];
25239 props.SheetNames[j] = wbsheets[j].name;
25276 …case "string": if(props.SheetNames[i].toLowerCase() != opts.sheets.toLowerCase()) continue wsloop;…
25281 …if(typeof opts.sheets[snj] == "string" && opts.sheets[snj].toLowerCase() == props.SheetNames[i].to…
25286 …safe_parse_sheet(zip, path, relsPath, props.SheetNames[i], i, sheetRels, sheets, stype, opts, wb, …
25296 SheetNames: props.SheetNames, property in out
25404 if(wb.Props && wb.Props.SheetNames){/* empty */}
25405 else if(!wb.Workbook || !wb.Workbook.Sheets) wb.Props.SheetNames = wb.SheetNames;
25408 for(var _i = 0; _i < wb.SheetNames.length; ++_i)
25409 if((wb.Workbook.Sheets[_i]||{}).Hidden != 2) _sn.push(wb.SheetNames[_i]);
25410 wb.Props.SheetNames = _sn;
25412 wb.Props.Worksheets = wb.Props.SheetNames.length;
25424 for(rId=1;rId <= wb.SheetNames.length; ++rId) {
25426 var ws = wb.Sheets[wb.SheetNames[rId-1]];
25539 if(wb.Props && wb.Props.SheetNames){/* empty */}
25540 else if(!wb.Workbook || !wb.Workbook.Sheets) wb.Props.SheetNames = wb.SheetNames;
25543 for(var _i = 0; _i < wb.SheetNames.length; ++_i)
25544 if((wb.Workbook.Sheets[_i]||{}).Hidden != 2) _sn.push(wb.SheetNames[_i]);
25545 wb.Props.SheetNames = _sn;
25547 wb.Props.Worksheets = wb.Props.SheetNames.length;
25562 for(rId=1;rId <= wb.SheetNames.length; ++rId) {
25564 var ws = wb.Sheets[wb.SheetNames[rId-1]];
25914 else idx = wb.SheetNames.indexOf(o.sheet);
25915 if(!wb.SheetNames[idx]) throw new Error("Sheet not found: " + o.sheet + " : " + (typeof o.sheet));
25921 case 'sylk': return write_string_type(SYLK.from_sheet(wb.Sheets[wb.SheetNames[idx]], o, wb), o);
25923 case 'html': return write_string_type(sheet_to_html(wb.Sheets[wb.SheetNames[idx]], o), o);
25924 case 'txt': return write_stxt_type(sheet_to_txt(wb.Sheets[wb.SheetNames[idx]], o), o);
25925 case 'csv': return write_string_type(sheet_to_csv(wb.Sheets[wb.SheetNames[idx]], o), o, "\ufeff");
25926 case 'dif': return write_string_type(DIF.from_sheet(wb.Sheets[wb.SheetNames[idx]], o), o);
25927 case 'dbf': return write_binary_type(DBF.from_sheet(wb.Sheets[wb.SheetNames[idx]], o), o);
25928 case 'prn': return write_string_type(PRN.from_sheet(wb.Sheets[wb.SheetNames[idx]], o), o);
25929 case 'rtf': return write_string_type(sheet_to_rtf(wb.Sheets[wb.SheetNames[idx]], o), o);
25930 case 'eth': return write_string_type(ETH.from_sheet(wb.Sheets[wb.SheetNames[idx]], o), o);
25932 case 'wk1': return write_binary_type(WK_.sheet_to_wk1(wb.Sheets[wb.SheetNames[idx]], o), o);
26271 if(sh >= 0 && wb.SheetNames.length > sh) return sh;
26274 var idx = wb.SheetNames.indexOf(sh);
26282 return { SheetNames: [], Sheets: {} };
26288 …if(!name) for(; i <= 0xFFFF; ++i, name = undefined) if(wb.SheetNames.indexOf(name = "Sheet" + i) =…
26289 if(!name || wb.SheetNames.length >= 0xFFFF) throw new Error("Too many worksheets");
26290 if(roll && wb.SheetNames.indexOf(name) >= 0) {
26294 for(++i; i <= 0xFFFF; ++i) if(wb.SheetNames.indexOf(name = root + i) == -1) break;
26297 …if(wb.SheetNames.indexOf(name) >= 0) throw new Error("Worksheet with name |" + name + "| already e…
26299 wb.SheetNames.push(name);