Lines Matching refs:Workbook

4378 function sheet_to_workbook(sheet/*:Worksheet*/, opts)/*:Workbook*/ {
5091 /* Workbook */
5192 /* Shared Workbook */
5569 function write_meta_ods(/*:: wb: Workbook, opts: any*/)/*:string*/ {
6727 function write_BOF(wb/*:Workbook*/, t/*:number*/, o) {
7878 function dbf_to_workbook(buf, opts)/*:Workbook*/ {
8065 var wb = { Workbook: { WBProps: {}, Names: [] } }; class in SYLK.wb
8081 if(d1904 >= 1 && d1904 <= 4) wb.Workbook.WBProps.date1904 = true;
8095 wb.Workbook.Names.push(nn);
8114 … && fmt_is_date(next_cell_format) && opts.cellDates) { val = numdate(wb.Workbook.WBProps.date1904 …
8117 if(!opts.cellDates) { cell_t = "n"; val = datenum(val, wb.Workbook.WBProps.date1904); }
8140 …rmat) arr[R][C].w = SSF_format(arr[R][C].z, arr[R][C].v, { date1904: wb.Workbook.WBProps.date1904 …
8202 function sylk_to_workbook(d/*:RawData*/, opts)/*:Workbook*/ {
8205 var _opts = dup(opts); _opts.date1904 = (((wb||{}).Workbook || {}).WBProps || {}).date1904;
8257 var d1904 = (((wb||{}).Workbook||{}).WBProps||{}).date1904;
8332 function dif_to_workbook(str/*:string*/, opts)/*:Workbook*/ {
8423 …function eth_to_workbook(d/*:string*/, opts)/*:Workbook*/ { return sheet_to_workbook(eth_to_sheet(…
8671 …function prn_to_workbook(d/*:RawData*/, opts)/*:Workbook*/ { return sheet_to_workbook(prn_to_sheet…
8739 function lotus_to_workbook_buf(d, opts)/*:Workbook*/ {
8900 function book_to_wk3(wb/*:Workbook*/, opts/*:WriteOpts*/) {
8949 function write_BOF_WK3(wb/*:Workbook*/) {
9630 function qpw_to_workbook_buf(d, opts)/*:Workbook*/ {
11004 function write_sty_xml(wb/*:Workbook*/, opts)/*:string*/ {
12033 /* 18.14 Supplementary Workbook Data */
15357 try { if(wb.Workbook) cname = wb.Workbook.Sheets[idx].CodeName || cname; } catch(e) {}
15462 if(!wb.Workbook) wb.Workbook = ({Sheets:[]}/*:any*/);
15463 if(!wb.Workbook.Names) wb.Workbook.Names = [];
15464 var names/*: Array<any> */ = wb.Workbook.Names;
15495 …if((((wb||{}).Workbook||{}).Views||[])[0]) sview.rightToLeft = wb.Workbook.Views[0].RTL ? "1" : "0…
15737 function write_ws_xml_data(ws/*:Worksheet*/, opts, idx/*:number*/, wb/*:Workbook*//*::, rels*/)/*:s…
15781 function write_ws_xml(idx/*:number*/, opts, wb/*:Workbook*/, rels)/*:string*/ {
16345 function write_BrtBeginWsView(ws, Workbook, o) { argument
16348 if((((Workbook||{}).Views||[])[0]||{}).RTL) f |= 0x20;
16763 function write_CELLTABLE(ba, ws/*:Worksheet*/, idx/*:number*/, opts/*::, wb:Workbook*/) {
16795 function write_COLINFOS(ba, ws/*:Worksheet*//*::, idx:number, opts, wb:Workbook*/) {
16833 if(!wb.Workbook) wb.Workbook = ({Sheets:[]}/*:any*/);
16834 if(!wb.Workbook.Names) wb.Workbook.Names = [];
16835 var names/*: Array<any> */ = wb.Workbook.Names;
16853 function write_WSVIEWS2(ba, ws, Workbook) { argument
16857 write_record(ba, 0x0089 /* BrtBeginWsView */, write_BrtBeginWsView(ws, Workbook));
16879 function write_ws_bin(idx/*:number*/, opts, wb/*:Workbook*/, rels) {
16882 …var c/*:string*/ = s; try { if(wb && wb.Workbook) c = wb.Workbook.Sheets[idx].CodeName || c; } cat…
16895 write_WSVIEWS2(ba, ws, wb.Workbook);
16997 //function write_cs_xml(idx/*:number*/, opts, wb/*:Workbook*/, rels)/*:string*/ {
17062 //function write_cs_bin(/*::idx:number, opts, wb:Workbook, rels*/) {
17189 function safe1904(wb/*:Workbook*/)/*:string*/ {
17191 if(!wb.Workbook) return "false";
17192 if(!wb.Workbook.WBProps) return "false";
17193 return parsexmlbool(wb.Workbook.WBProps.date1904) ? "true" : "false";
17218 if(!wb || !wb.SheetNames || !wb.Sheets) throw new Error("Invalid Workbook");
17219 if(!wb.SheetNames.length) throw new Error("Workbook is empty");
17220 var Sheets = (wb.Workbook && wb.Workbook.Sheets) || [];
17227 if(!wb.Workbook) wb.Workbook = {};
17228 if(!wb.Workbook.Names) wb.Workbook.Names = [];
17229 …wb.Workbook.Names.forEach(function(dn) { if(dn.Name == "_xlnm._FilterDatabase" && dn.Sheet == i) D…
17232 else wb.Workbook.Names.push({Name: "_xlnm._FilterDatabase", Sheet: i, Ref: nn});
17236 /* 18.2 Workbook */
17396 function write_wb_xml(wb/*:Workbook*//*::, opts:?WriteOpts*/)/*:string*/ {
17405 var write_names = (wb.Workbook && (wb.Workbook.Names||[]).length > 0);
17411 if(wb.Workbook && wb.Workbook.WBProps) {
17413 /*:: if(!wb.Workbook || !wb.Workbook.WBProps) throw "unreachable"; */
17414 if((wb.Workbook.WBProps[x[0]]/*:any*/) == null) return;
17415 if((wb.Workbook.WBProps[x[0]]/*:any*/) == x[1]) return;
17416 workbookPr[x[0]] = (wb.Workbook.WBProps[x[0]]/*:any*/);
17418 /*:: if(!wb.Workbook || !wb.Workbook.WBProps) throw "unreachable"; */
17419 …if(wb.Workbook.WBProps.CodeName) { workbookPr.codeName = wb.Workbook.WBProps.CodeName; delete work…
17425 var sheets = wb.Workbook && wb.Workbook.Sheets || [];
17458 if(wb.Workbook && wb.Workbook.Names) wb.Workbook.Names.forEach(function(n) {
17599 /* [MS-XLSB] 2.1.7.61 Workbook */
17713 …var viz = wb.Workbook && wb.Workbook.Sheets && wb.Workbook.Sheets[idx] && wb.Workbook.Sheets[idx].…
17748 if(!wb.Workbook || !wb.Workbook.Sheets) return;
17749 var sheets = wb.Workbook.Sheets;
17763 if(!wb.Workbook || !wb.Workbook.Names) return;
17764 wb.Workbook.Names.forEach(function(name) { try {
17810 /* [MS-XLSB] 2.1.7.61 Workbook */
17816 …write_record(ba, 0x0099 /* BrtWbProp */, write_BrtWbProp(wb.Workbook && wb.Workbook.WBProps || nul…
17823 if((wb.Workbook||{}).Names) write_BRTNAMES(ba, wb);
18065 function parse_xlml_xml(d, _opts)/*:Workbook*/ {
18115 var Workbook/*:WBWBProps*/ = ({ Sheets:[], WBProps:{date1904:false} }/*:any*/), wsprops = {}; class
18221 Workbook.Sheets.push(wsprops);
18262 if(!Workbook.Names) Workbook.Names = [];
18268 if(Workbook.Sheets.length>0) _DefinedName.Sheet=Workbook.Sheets.length-1;
18269 /*:: if(Workbook.Names) */Workbook.Names.push(_DefinedName);
18325 case 'workbook' /*case 'Workbook'*/:
18426 /*:: if(!Workbook.WBProps) Workbook.WBProps = {}; */
18427 Workbook.WBProps.date1904 = true;
18512 if(!Workbook.Views) Workbook.Views = [];
18513 if(!Workbook.Views[0]) Workbook.Views[0] = {};
18514 Workbook.Views[0].RTL = true;
18810 out.Workbook = Workbook;
18818 function parse_xlml(data/*:RawBytes|string*/, opts)/*:Workbook*/ {
18829 function write_props_xlml(wb/*:Workbook*/, opts)/*:string*/ {
18841 …if((((wb||{}).Workbook||{}).WBProps||{}).date1904) return '<ExcelWorkbook xmlns="urn:schemas-micro…
18859 if(!((wb||{}).Workbook||{}).Names) return "";
18860 /*:: if(!wb || !wb.Workbook || !wb.Workbook.Names) throw new Error("unreachable"); */
18861 var names/*:Array<any>*/ = wb.Workbook.Names;
18871 function write_ws_xlml_names(ws/*:Worksheet*/, opts, idx/*:number*/, wb/*:Workbook*/)/*:string*/ {
18873 if(!((wb||{}).Workbook||{}).Names) return "";
18874 /*:: if(!wb || !wb.Workbook || !wb.Workbook.Names) throw new Error("unreachable"); */
18875 var names/*:Array<any>*/ = wb.Workbook.Names;
18889 function write_ws_xlml_wsopts(ws/*:Worksheet*/, opts, idx/*:number*/, wb/*:Workbook*/)/*:string*/ {
18933 if(wb && wb.Workbook && wb.Workbook.Sheets && wb.Workbook.Sheets[idx]) {
18935 …if(wb.Workbook.Sheets[idx].Hidden) o.push(writextag("Visible", (wb.Workbook.Sheets[idx].Hidden == …
18938 for(var i = 0; i < idx; ++i) if(wb.Workbook.Sheets[i] && !wb.Workbook.Sheets[i].Hidden) break;
18945 if(((((wb||{}).Workbook||{}).Views||[])[0]||{}).RTL) o.push("<DisplayRightToLeft/>");
19058 function write_ws_xlml_table(ws/*:Worksheet*/, opts, idx/*:number*/, wb/*:Workbook*/)/*:string*/ {
19095 function write_ws_xlml(idx/*:number*/, opts, wb/*:Workbook*/)/*:string*/ {
19134 return XML_HEADER + writextag("Workbook", d.join(""), {
19245 function parse_workbook(blob, options/*:ParseOpts*/)/*:Workbook*/ {
19263 …var Workbook/*:WBWBProps*/ = ({ Sheets:[], WBProps:{date1904:false}, Views:[{}] }/*:any*/), wsprop… class
19372 /*:: if(!Workbook.WBProps) Workbook.WBProps = {}; */
19373 wb.opts.Date1904 = Workbook.WBProps.date1904 = val; break;
19466 Workbook.Sheets.push(wsprops);
19716 if(val.RTL) Workbook.Views[0].RTL = true;
19722 /*:: if(!Workbook.WBProps) Workbook.WBProps = {}; */
19723 if(!cur_sheet) Workbook.WBProps.CodeName = val || "ThisWorkbook";
19747 if(supbooks.names.length > 0) Workbook.Names = supbooks.names;
19748 wb.Workbook = Workbook;
19778 function write_xls_props(wb/*:Workbook*/, cfb/*:CFBContainer*/) {
19803 function parse_xlscfb(cfb/*:any*/, options/*:?ParseOpts*/)/*:Workbook*/ {
19812 WB = CFB.find(cfb, '/Workbook') || CFB.find(cfb, '/Book');
19837 else throw new Error("Cannot find Workbook stream");
19851 function write_xlscfb(wb/*:Workbook*/, opts/*:WriteOpts*/)/*:CFBContainer*/ {
19854 var wbpath = "/Workbook";
19860 case "biff8": wbpath = "/Workbook"; o.biff = 8; break;
21280 function write_ws_biff2(ba/*:BufArray*/, ws/*:Worksheet*/, idx/*:number*/, opts/*::, wb:Workbook*/)…
21303 function write_biff2_buf(wb/*:Workbook*/, opts/*:WriteOpts*/) {
21408 function write_ws_biff8(idx/*:number*/, opts, wb/*:Workbook*/) {
21411 var _WB/*:WBWBProps*/ = ((wb||{}).Workbook||{}/*:any*/);
21481 function write_biff8_global(wb/*:Workbook*/, bufs, opts/*:WriteOpts*/) {
21483 var _WB/*:WBWBProps*/ = ((wb||{}).Workbook||{}/*:any*/);
21563 /* [MS-XLS] 2.1.7.20 Workbook Stream */
21564 function write_biff8_buf(wb/*:Workbook*/, opts/*:WriteOpts*/) {
21591 function write_biff_buf(wb/*:Workbook*/, opts/*:WriteOpts*/) {
21609 function html_to_sheet(str/*:string*/, _opts)/*:Workbook*/ {
21704 function html_to_workbook(str/*:string*/, opts)/*:Workbook*/ {
21723 function sheet_to_html(ws/*:Worksheet*/, opts/*:?Sheet2HTMLOpts*//*, wb:?Workbook*/)/*:string*/ {
21829 function table_to_book(table/*:HTMLElement*/, opts/*:?any*/)/*:Workbook*/ {
22088 function parse_content_xml(d/*:string*/, _opts, _nfm)/*:Workbook*/ {
22605 var out/*:Workbook*/ = ({
22608 Workbook: WB property in out
22614 function parse_ods(zip/*:ZIPFile*/, opts/*:?ParseOpts*/)/*:Workbook*/ {
22626 function parse_fods(data/*:string*/, opts/*:?ParseOpts*/)/*:Workbook*/ {
22839 var write_ws = function(ws, wb/*:Workbook*/, i/*:number*/, opts, nfs)/*:string*/ {
22920 if((wb.Workbook||{}).Names) o.push(write_names_ods(wb.Workbook.Names, wb.SheetNames, i));
23059 …if(((wb.Workbook||{}).WBProps||{}).date1904) o.push(' <table:calculation-settings table:case-…
23061 if((wb.Workbook||{}).Names) o.push(write_names_ods(wb.Workbook.Names, wb.SheetNames, -1));
25127 function parse_zip(zip/*:ZIP*/, opts/*:?ParseOpts*/)/*:Workbook*/ {
25291 Workbook: wb, property in out
25326 function parse_xlsxcfb(cfb, _opts/*:?ParseOpts*/)/*:Workbook*/ {
25328 var f = 'Workbook', data = CFB.find(cfb, f);
25371 function write_zip_xlsb(wb/*:Workbook*/, opts/*:WriteOpts*/)/*:ZIP*/ {
25405 else if(!wb.Workbook || !wb.Workbook.Sheets) wb.Props.SheetNames = wb.SheetNames;
25409 if((wb.Workbook.Sheets[_i]||{}).Hidden != 2) _sn.push(wb.SheetNames[_i]);
25506 function write_zip_xlsx(wb/*:Workbook*/, opts/*:WriteOpts*/)/*:ZIP*/ {
25540 else if(!wb.Workbook || !wb.Workbook.Sheets) wb.Props.SheetNames = wb.SheetNames;
25544 if((wb.Workbook.Sheets[_i]||{}).Hidden != 2) _sn.push(wb.SheetNames[_i]);
25673 function read_cfb(cfb/*:CFBContainer*/, opts/*:?ParseOpts*/)/*:Workbook*/ {
25678 function read_zip(data/*:RawData*/, opts/*:?ParseOpts*/)/*:Workbook*/ {
25686 function read_plaintext(data/*:string*/, o/*:ParseOpts*/)/*:Workbook*/ {
25696 function read_plaintext_raw(data/*:RawData*/, o/*:ParseOpts*/)/*:Workbook*/ {
25710 function read_utf16(data/*:RawData*/, o/*:ParseOpts*/)/*:Workbook*/ {
25727 function readSync(data/*:RawData*/, opts/*:?ParseOpts*/)/*:Workbook*/ {
25781 function readFileSync(filename/*:string*/, opts/*:?ParseOpts*/)/*:Workbook*/ {
25796 function write_zip(wb/*:Workbook*/, opts/*:WriteOpts*/)/*:ZIP*/ {
25806 function write_zip_type(wb/*:Workbook*/, opts/*:?WriteOpts*/)/*:any*/ {
25811 function write_zip_typeXLSX(wb/*:Workbook*/, opts/*:?WriteOpts*/)/*:any*/ {
25843 function write_cfb_type(wb/*:Workbook*/, opts/*:?WriteOpts*/)/*:any*/ {
25896 function writeSyncXLSX(wb/*:Workbook*/, opts/*:?WriteOpts*/) {
25905 function writeSync(wb/*:Workbook*/, opts/*:?WriteOpts*/) {
25965 function writeFileSync(wb/*:Workbook*/, filename/*:string*/, opts/*:?WriteFileOpts*/) {
25972 function writeFileSyncXLSX(wb/*:Workbook*/, filename/*:string*/, opts/*:?WriteFileOpts*/) {
25980 function writeFileAsync(filename/*:string*/, wb/*:Workbook*/, opts/*:?WriteFileOpts*/, cb/*:?(e?:Er…
26269 function wb_sheet_idx(wb/*:Workbook*/, sh/*:number|string*/) {
26281 function book_new()/*:Workbook*/ {
26286 function book_append_sheet(wb/*:Workbook*/, ws/*:Worksheet*/, name/*:?string*/, roll/*:?boolean*/)/…
26305 function book_set_sheet_visibility(wb/*:Workbook*/, sh/*:number|string*/, vis/*:number*/) {
26306 if(!wb.Workbook) wb.Workbook = {};
26307 if(!wb.Workbook.Sheets) wb.Workbook.Sheets = [];
26311 if(!wb.Workbook.Sheets[idx]) wb.Workbook.Sheets[idx] = {};
26318 wb.Workbook.Sheets[idx].Hidden = vis;