Lines Matching refs:sheet
4325 if(!sname && !(opts && opts.biff <= 5 && opts.biff >= 2)) throw new Error("empty sheet name");
4378 function sheet_to_workbook(sheet/*:Worksheet*/, opts)/*:Workbook*/ { argument
4379 var n = opts && opts.sheet ? opts.sheet : "Sheet1";
4380 var sheets = {}; sheets[n] = sheet;
5092 "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml": "workbooks",
5093 "application/vnd.ms-excel.sheet.macroEnabled.main+xml": "workbooks",
5094 "application/vnd.ms-excel.sheet.binary.macroEnabled.main": "workbooks",
5261 "sheet": "js" property in ct2type
5266 xlsx: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml",
5267 xlsm: "application/vnd.ms-excel.sheet.macroEnabled.main+xml",
5268 xlsb: "application/vnd.ms-excel.sheet.binary.macroEnabled.main",
5353 ['bin', 'application/vnd.ms-excel.sheet.binary.macroEnabled.main'],
8093 … case 'E': nn.Ref = (opts && opts.sheet || "Sheet1") + "!" + rc_to_a1(record[rj].slice(1)); break;
8439 "part:sheet"
8475 o.push("sheet:c:" + (r.e.c-r.s.c+1) + ":r:" + (r.e.r-r.s.r+1) + ":tvf:1");
12160 function sheet_insert_comments(sheet, comments/*:Array<RawComment>*/, threaded/*:boolean*/, people/… argument
12161 var dense = Array.isArray(sheet);
12166 if(!sheet[r.r]) sheet[r.r] = [];
12167 cell = sheet[r.r][r.c];
12168 } else cell = sheet[comment.ref];
12171 if(dense) sheet[r.r][r.c] = cell;
12172 else sheet[comment.ref] = cell;
12173 var range = safe_decode_range(sheet["!ref"]||"BDWGO1000001:A1");
12179 if (encoded !== sheet["!ref"]) sheet["!ref"] = encoded;
12500 /* macro and dialog sheet stubs */
13842 /* Writes a single sheet range [PtgRef PtgRef PtgRange] */
13871 /* Writes a range with explicit sheet name [PtgRef3D PtgRef3D PtgRange] */
13904 /* Writes a range with explicit sheet name [PtgArea3d] */
15383 var o = ({sheet:1}/*:any*/); property in write_ws_xml_protection.o
17291 case '<sheets': case '<sheets>': case '</sheets>': break; // aggregate sheet
17292 /* 18.2.19 sheet CT_Sheet + */
17293 case '<sheet':
17302 case '</sheet>': break;
17449 o[o.length] = (writextag('sheet',null,sht));
19441 case 0x0012 /* Protect */: out["!protect"] = val; break; /* for sheet or book */
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…
22508 case 'sheet-name': // 7.3.9
23030 'xmlns:sheet': "urn:oasis:names:tc:opendocument:sh33tjs:1.0",
24146 root2.sheets.forEach(function(sheet, idx) { argument
24147 book_append_sheet(out, sheet, idx == 0 ? root2.name : root2.name + "_" + idx, true);
24361 throw new Error("Template NUMBERS file must have exactly one sheet");
24404 var sheet = numbers_iwa_find(cfb, deps, sheetref);
24405 sheet.id = newsheetref;
24407 arch.push(sheet);
24410 return x.push(sheet);
25046 ['bookSheets', false], /* only try to get sheet names (no Sheets) */
25070 if(RELS.WS.indexOf(n) > -1) return "sheet";
25074 return (n && n.length) ? n : "sheet";
25084 function safe_parse_sheet(zip, path/*:string*/, relsPath/*:string*/, sheet, idx/*:number*/, sheetRe… argument
25086 sheetRels[sheet]=parse_rels(getzipstr(zip, relsPath, true), path);
25090 … case 'sheet': _ws = parse_ws(data, path, idx, opts, sheetRels[sheet], wb, themes, styles); break;
25091 case 'chart': _ws = parse_cs(data, path, idx, opts, sheetRels[sheet], wb, themes, styles);
25100 … case 'macro': _ws = parse_ms(data, path, idx, opts, sheetRels[sheet], wb, themes, styles); break;
25101 … case 'dialog': _ws = parse_ds(data, path, idx, opts, sheetRels[sheet], wb, themes, styles); break;
25102 default: throw new Error("Unrecognized sheet type " + stype);
25104 sheets[sheet] = _ws;
25108 if(sheetRels && sheetRels[sheet]) keys(sheetRels[sheet]).forEach(function(n) {
25110 if(sheetRels[sheet][n].Type == RELS.CMNT) {
25111 dfile = resolve_path(sheetRels[sheet][n].Target, path);
25116 if(sheetRels[sheet][n].Type == RELS.TCMNT) {
25117 dfile = resolve_path(sheetRels[sheet][n].Target, path);
25261 var nmode = (getzipdata(zip,"xl/worksheets/sheet.xml",true))?1:0;
25263 var stype = "sheet";
25270 path = 'xl/worksheets/sheet'+(i+1-nmode)+"." + wbext;
25271 path = path.replace(/sheet0\./,"sheet.");
25427 var _type = (ws || {})["!type"] || "sheet";
25432 f = "xl/worksheets/sheet" + rId + "." + wbext;
25435 add_rels(opts.wbrels, -1, "worksheets/sheet" + rId + "." + wbext, RELS.WS[0]);
25565 var _type = (ws || {})["!type"] || "sheet";
25570 f = "xl/worksheets/sheet" + rId + "." + wbext;
25573 add_rels(opts.wbrels, -1, "worksheets/sheet" + rId + "." + wbext, RELS.WS[0]);
25912 if(o.sheet) {
25913 if(typeof o.sheet == "number") idx = o.sheet;
25914 else idx = wb.SheetNames.indexOf(o.sheet);
25915 if(!wb.SheetNames[idx]) throw new Error("Sheet not found: " + o.sheet + " : " + (typeof o.sheet));
25994 function make_json_row(sheet/*:Worksheet*/, r/*:Range*/, R/*:number*/, cols/*:Array<string>*/, head… argument
26003 if(!dense || sheet[R]) for (var C = r.s.c; C <= r.e.c; ++C) {
26004 var val = dense ? sheet[R][C] : sheet[cols[C] + rr];
26033 function sheet_to_json(sheet/*:Worksheet*/, opts/*:?Sheet2JSONOpts*/) { argument
26034 if(sheet == null || sheet["!ref"] == null) return [];
26038 var range = o.range != null ? o.range : sheet["!ref"];
26045 case 'number': r = safe_decode_range(sheet["!ref"]); r.s.r = range; break;
26053 var dense = Array.isArray(sheet);
26056 if(dense && !sheet[R]) sheet[R] = [];
26057 var colinfo/*:Array<ColInfo>*/ = o.skipHidden && sheet["!cols"] || [];
26058 var rowinfo/*:Array<ColInfo>*/ = o.skipHidden && sheet["!rows"] || [];
26062 val = dense ? sheet[R][C] : sheet[cols[C] + rr];
26081 var row = make_json_row(sheet, r, R, cols, header, hdr, dense, o);
26089 function make_csv_row(sheet/*:Worksheet*/, r/*:Range*/, R/*:number*/, cols/*:Array<string>*/, fs/*:… argument
26094 var val = o.dense ? (sheet[R]||[])[C]: sheet[cols[C] + rr];
26112 function sheet_to_csv(sheet/*:Worksheet*/, opts/*:?Sheet2CSVOpts*/)/*:string*/ { argument
26115 if(sheet == null || sheet["!ref"] == null) return "";
26116 var r = safe_decode_range(sheet["!ref"]);
26121 o.dense = Array.isArray(sheet);
26122 var colinfo/*:Array<ColInfo>*/ = o.skipHidden && sheet["!cols"] || [];
26123 var rowinfo/*:Array<ColInfo>*/ = o.skipHidden && sheet["!rows"] || [];
26128 row = make_csv_row(sheet, r, R, cols, fs, rs, FS, o);
26137 function sheet_to_txt(sheet/*:Worksheet*/, opts/*:?Sheet2CSVOpts*/) { argument
26139 var s = sheet_to_csv(sheet, opts);
26145 function sheet_to_formulae(sheet/*:Worksheet*/)/*:Array<string>*/ { argument
26147 if(sheet == null || sheet["!ref"] == null) return [];
26148 var r = safe_decode_range(sheet['!ref']), rr = "", cols/*:Array<string>*/ = [], C;
26150 var dense = Array.isArray(sheet);
26156 x = dense ? (sheet[R]||[])[C] : sheet[y];
26268 /* find sheet index for given name / validate index */
26272 throw new Error("Cannot find sheet # " + sh);
26276 throw new Error("Cannot find sheet name |" + sh + "|");
26277 } else throw new Error("Cannot find sheet |" + sh + "|");
26304 /* set sheet visibility (visible/hidden/very hidden) */
26315 default: throw new Error("Bad sheet visibility setting " + vis);
26411 function write_csv_stream(sheet/*:Worksheet*/, opts/*:?Sheet2CSVOpts*/) { argument
26414 if(sheet == null || sheet["!ref"] == null) { stream.push(null); return stream; }
26415 var r = safe_decode_range(sheet["!ref"]);
26420 o.dense = Array.isArray(sheet);
26421 var colinfo/*:Array<ColInfo>*/ = o.skipHidden && sheet["!cols"] || [];
26422 var rowinfo/*:Array<RowInfo>*/ = o.skipHidden && sheet["!rows"] || [];
26431 row = make_csv_row(sheet, r, R-1, cols, fs, rs, FS, o);
26468 function write_json_stream(sheet/*:Worksheet*/, opts/*:?Sheet2CSVOpts*/) { argument
26471 if(sheet == null || sheet["!ref"] == null) { stream.push(null); return stream; }
26475 var range = o.range != null ? o.range : sheet["!ref"];
26481 case 'number': r = safe_decode_range(sheet["!ref"]); r.s.r = range; break;
26488 var dense = Array.isArray(sheet);
26491 if(dense && !sheet[R]) sheet[R] = [];
26492 var colinfo/*:Array<ColInfo>*/ = o.skipHidden && sheet["!cols"] || [];
26493 var rowinfo/*:Array<RowInfo>*/ = o.skipHidden && sheet["!rows"] || [];
26497 val = dense ? sheet[R][C] : sheet[cols[C] + rr];
26518 var row = make_json_row(sheet, r, R, cols, header, hdr, dense, o);