Extremely Popular
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250/* 18.2 Workbook */var wbnsregex = /<\w+:workbook/;function parse_wb_xml(data, opts)/*:WorkbookFile*/ { if(!data) throw new Error("Could not find file"); var wb = /*::(*/{ AppVersion:{}, WBProps:{}, WBView:[], Sheets:[], CalcPr:{}, Names:[], xmlns: "" }/*::)*/; var pass = false, xmlns = "xmlns"; var dname = {}, dnstart = 0; data.replace(tagregex, function xml_wb(x, idx) { var y/*:any*/ = parsexmltag(x); switch(strip_ns(y[0])) { case '<?xml': break;
/* 18.2.27 workbook CT_Workbook 1 */ case '<workbook': if(x.match(wbnsregex)) xmlns = "xmlns" + x.match(/<(\w+):/)[1]; wb.xmlns = y[xmlns]; break; case '</workbook>': break;
/* 18.2.13 fileVersion CT_FileVersion ? */ case '<fileVersion': delete y[0]; wb.AppVersion = y; break; case '<fileVersion/>': case '</fileVersion>': break;
/* 18.2.12 fileSharing CT_FileSharing ? */ case '<fileSharing': break; case '<fileSharing/>': break;
/* 18.2.28 workbookPr CT_WorkbookPr ? */ case '<workbookPr': case '<workbookPr/>': WBPropsDef.forEach(function(w) { if(y[w[0]] == null) return; switch(w[2]) { case "bool": wb.WBProps[w[0]] = parsexmlbool(y[w[0]]); break; case "int": wb.WBProps[w[0]] = parseInt(y[w[0]], 10); break; default: wb.WBProps[w[0]] = y[w[0]]; } }); if(y.codeName) wb.WBProps.CodeName = utf8read(y.codeName); break; case '</workbookPr>': break;
/* 18.2.29 workbookProtection CT_WorkbookProtection ? */ case '<workbookProtection': break; case '<workbookProtection/>': break;
/* 18.2.1 bookViews CT_BookViews ? */ case '<bookViews': case '<bookViews>': case '</bookViews>': break; /* 18.2.30 workbookView CT_BookView + */ case '<workbookView': case '<workbookView/>': delete y[0]; wb.WBView.push(y); break; case '</workbookView>': break;
/* 18.2.20 sheets CT_Sheets 1 */ case '<sheets': case '<sheets>': case '</sheets>': break; // aggregate sheet /* 18.2.19 sheet CT_Sheet + */ case '<sheet': switch(y.state) { case "hidden": y.Hidden = 1; break; case "veryHidden": y.Hidden = 2; break; default: y.Hidden = 0; } delete y.state; y.name = unescapexml(utf8read(y.name)); delete y[0]; wb.Sheets.push(y); break; case '</sheet>': break;
/* 18.2.15 functionGroups CT_FunctionGroups ? */ case '<functionGroups': case '<functionGroups/>': break; /* 18.2.14 functionGroup CT_FunctionGroup + */ case '<functionGroup': break;
/* 18.2.9 externalReferences CT_ExternalReferences ? */ case '<externalReferences': case '</externalReferences>': case '<externalReferences>': break; /* 18.2.8 externalReference CT_ExternalReference + */ case '<externalReference': break;
/* 18.2.6 definedNames CT_DefinedNames ? */ case '<definedNames/>': break; case '<definedNames>': case '<definedNames': pass=true; break; case '</definedNames>': pass=false; break; /* 18.2.5 definedName CT_DefinedName + */ case '<definedName': { dname = {}; dname.Name = utf8read(y.name); if(y.comment) dname.Comment = y.comment; if(y.localSheetId) dname.Sheet = +y.localSheetId; if(parsexmlbool(y.hidden||"0")) dname.Hidden = true; dnstart = idx + x.length; } break; case '</definedName>': { dname.Ref = unescapexml(utf8read(data.slice(dnstart, idx))); wb.Names.push(dname); } break; case '<definedName/>': break;
/* 18.2.2 calcPr CT_CalcPr ? */ case '<calcPr': delete y[0]; wb.CalcPr = y; break; case '<calcPr/>': delete y[0]; wb.CalcPr = y; break; case '</calcPr>': break;
/* 18.2.16 oleSize CT_OleSize ? (ref required) */ case '<oleSize': break;
/* 18.2.4 customWorkbookViews CT_CustomWorkbookViews ? */ case '<customWorkbookViews>': case '</customWorkbookViews>': case '<customWorkbookViews': break; /* 18.2.3 customWorkbookView CT_CustomWorkbookView + */ case '<customWorkbookView': case '</customWorkbookView>': break;
/* 18.2.18 pivotCaches CT_PivotCaches ? */ case '<pivotCaches>': case '</pivotCaches>': case '<pivotCaches': break; /* 18.2.17 pivotCache CT_PivotCache ? */ case '<pivotCache': break;
/* 18.2.21 smartTagPr CT_SmartTagPr ? */ case '<smartTagPr': case '<smartTagPr/>': break;
/* 18.2.23 smartTagTypes CT_SmartTagTypes ? */ case '<smartTagTypes': case '<smartTagTypes>': case '</smartTagTypes>': break; /* 18.2.22 smartTagType CT_SmartTagType ? */ case '<smartTagType': break;
/* 18.2.24 webPublishing CT_WebPublishing ? */ case '<webPublishing': case '<webPublishing/>': break;
/* 18.2.11 fileRecoveryPr CT_FileRecoveryPr ? */ case '<fileRecoveryPr': case '<fileRecoveryPr/>': break;
/* 18.2.26 webPublishObjects CT_WebPublishObjects ? */ case '<webPublishObjects>': case '<webPublishObjects': case '</webPublishObjects>': break; /* 18.2.25 webPublishObject CT_WebPublishObject ? */ case '<webPublishObject': break;
/* 18.2.10 extLst CT_ExtensionList ? */ case '<extLst': case '<extLst>': case '</extLst>': case '<extLst/>': break; /* 18.2.7 ext CT_Extension + */ case '<ext': pass=true; break; //TODO: check with versions of excel case '</ext>': pass=false; break;
/* Others */ case '<ArchID': break; case '<AlternateContent': case '<AlternateContent>': pass=true; break; case '</AlternateContent>': pass=false; break;
/* TODO */ case '<revisionPtr': break;
default: if(!pass && opts.WTF) throw new Error('unrecognized ' + y[0] + ' in workbook'); } return x; }); if(XMLNS.main.indexOf(wb.xmlns) === -1) throw new Error("Unknown Namespace: " + wb.xmlns);
parse_wb_defaults(wb);
return wb;}
var WB_XML_ROOT = writextag('workbook', null, { 'xmlns': XMLNS.main[0], //'xmlns:mx': XMLNS.mx, //'xmlns:s': XMLNS.main[0], 'xmlns:r': XMLNS.r});
function write_wb_xml(wb/*:Workbook*//*::, opts:?WriteOpts*/)/*:string*/ { var o = [XML_HEADER]; o[o.length] = WB_XML_ROOT;
var write_names = (wb.Workbook && (wb.Workbook.Names||[]).length > 0);
/* fileVersion */ /* fileSharing */
var workbookPr/*:any*/ = ({codeName:"ThisWorkbook"}/*:any*/); if(wb.Workbook && wb.Workbook.WBProps) { WBPropsDef.forEach(function(x) { /*:: if(!wb.Workbook || !wb.Workbook.WBProps) throw "unreachable"; */ if((wb.Workbook.WBProps[x[0]]/*:any*/) == null) return; if((wb.Workbook.WBProps[x[0]]/*:any*/) == x[1]) return; workbookPr[x[0]] = (wb.Workbook.WBProps[x[0]]/*:any*/); }); /*:: if(!wb.Workbook || !wb.Workbook.WBProps) throw "unreachable"; */ if(wb.Workbook.WBProps.CodeName) { workbookPr.codeName = wb.Workbook.WBProps.CodeName; delete workbookPr.CodeName; } } o[o.length] = (writextag('workbookPr', null, workbookPr));
/* workbookProtection */
var sheets = wb.Workbook && wb.Workbook.Sheets || []; var i = 0;
/* bookViews only written if first worksheet is hidden */ if(sheets && sheets[0] && !!sheets[0].Hidden) { o[o.length] = "<bookViews>"; for(i = 0; i != wb.SheetNames.length; ++i) { if(!sheets[i]) break; if(!sheets[i].Hidden) break; } if(i == wb.SheetNames.length) i = 0; o[o.length] = '<workbookView firstSheet="' + i + '" activeTab="' + i + '"/>'; o[o.length] = "</bookViews>"; }
o[o.length] = "<sheets>"; for(i = 0; i != wb.SheetNames.length; ++i) { var sht = ({name:escapexml(wb.SheetNames[i].slice(0,31))}/*:any*/); sht.sheetId = ""+(i+1); sht["r:id"] = "rId"+(i+1); if(sheets[i]) switch(sheets[i].Hidden) { case 1: sht.state = "hidden"; break; case 2: sht.state = "veryHidden"; break; } o[o.length] = (writextag('sheet',null,sht)); } o[o.length] = "</sheets>";
/* functionGroups */ /* externalReferences */
if(write_names) { o[o.length] = "<definedNames>"; if(wb.Workbook && wb.Workbook.Names) wb.Workbook.Names.forEach(function(n) { var d/*:any*/ = {name:n.Name}; if(n.Comment) d.comment = n.Comment; if(n.Sheet != null) d.localSheetId = ""+n.Sheet; if(n.Hidden) d.hidden = "1"; if(!n.Ref) return; o[o.length] = writextag('definedName', escapexml(n.Ref), d); }); o[o.length] = "</definedNames>"; }
/* calcPr */ /* oleSize */ /* customWorkbookViews */ /* pivotCaches */ /* smartTagPr */ /* smartTagTypes */ /* webPublishing */ /* fileRecoveryPr */ /* webPublishObjects */ /* extLst */
if(o.length>2){ o[o.length] = '</workbook>'; o[1]=o[1].replace("/>",">"); } return o.join("");}