function parse_rpr(rpr) { var font = {}, m = rpr.match(tagregex), i = 0; var pass = false; if(m) for(;i!=m.length; ++i) { var y = parsexmltag(m[i]); switch(y[0].replace(/\w*:/g,"")) { case '<condense': break; case '<extend': break; case '<shadow': if(!y.val) break; case '<shadow>': case '<shadow/>': font.shadow = 1; break; case '</shadow>': break;
case '<charset': if(y.val == '1') break; font.cp = CS2CP[parseInt(y.val, 10)]; break;
case '<outline': if(!y.val) break; case '<outline>': case '<outline/>': font.outline = 1; break; case '</outline>': break;
case '<rFont': font.name = y.val; break;
case '<sz': font.sz = y.val; break;
case '<strike': if(!y.val) break; case '<strike>': case '<strike/>': font.strike = 1; break; case '</strike>': break;
case '<u': if(!y.val) break; switch(y.val) { case 'double': font.uval = "double"; break; case 'singleAccounting': font.uval = "single-accounting"; break; case 'doubleAccounting': font.uval = "double-accounting"; break; } case '<u>': case '<u/>': font.u = 1; break; case '</u>': break;
case '<b': if(y.val == '0') break; case '<b>': case '<b/>': font.b = 1; break; case '</b>': break;
case '<i': if(y.val == '0') break; case '<i>': case '<i/>': font.i = 1; break; case '</i>': break;
case '<color': if(y.rgb) font.color = y.rgb.slice(2,8); break; case '<color>': case '<color/>': case '</color>': break;
case '<family': font.family = y.val; break; case '<family>': case '<family/>': case '</family>': break;
case '<vertAlign': font.valign = y.val; break; case '<vertAlign>': case '<vertAlign/>': case '</vertAlign>': break;
case '<scheme': break; case '<scheme>': case '<scheme/>': case '</scheme>': break;
case '<extLst': case '<extLst>': case '</extLst>': break; case '<ext': pass = true; break; case '</ext>': pass = false; break; default: if(y[0].charCodeAt(1) !== 47 && !pass) throw new Error('Unrecognized rich format ' + y[0]); } } return font;}
var parse_rs = (function() { var tregex = matchtag("t"), rpregex = matchtag("rPr"); function parse_r(r) { var t = r.match(tregex); if(!t) return {t:"s", v:""};
var o = ({t:'s', v:unescapexml(t[1])}); var rpr = r.match(rpregex); if(rpr) o.s = parse_rpr(rpr[1]); return o; } var rregex = /<(?:\w+:)?r>/g, rend = /<\/(?:\w+:)?r>/; return function parse_rs(rs) { return rs.replace(rregex,"").split(rend).map(parse_r).filter(function(r) { return r.v; }); };})();
var rs_to_html = (function parse_rs_factory() { var nlregex = /(\r\n|\n)/g; function parse_rpr2(font, intro, outro) { var style = [];
if(font.u) style.push("text-decoration: underline;"); if(font.uval) style.push("text-underline-style:" + font.uval + ";"); if(font.sz) style.push("font-size:" + font.sz + "pt;"); if(font.outline) style.push("text-effect: outline;"); if(font.shadow) style.push("text-shadow: auto;"); intro.push('<span style="' + style.join("") + '">');
if(font.b) { intro.push("<b>"); outro.push("</b>"); } if(font.i) { intro.push("<i>"); outro.push("</i>"); } if(font.strike) { intro.push("<s>"); outro.push("</s>"); }
var align = font.valign || ""; if(align == "superscript" || align == "super") align = "sup"; else if(align == "subscript") align = "sub"; if(align != "") { intro.push("<" + align + ">"); outro.push("</" + align + ">"); }
outro.push("</span>"); return font; }
function r_to_html(r) { var terms = [[],r.v,[]]; if(!r.v) return "";
if(r.s) parse_rpr2(r.s, terms[0], terms[2]);
return terms[0].join("") + terms[1].replace(nlregex,'<br/>') + terms[2].join(""); }
return function parse_rs(rs) { return rs.map(r_to_html).join(""); };})();
var sitregex = /<(?:\w+:)?t[^>]*>([^<]*)<\/(?:\w+:)?t>/g, sirregex = /<(?:\w+:)?r>/;var sirphregex = /<(?:\w+:)?rPh.*?>([\s\S]*?)<\/(?:\w+:)?rPh>/g;function parse_si(x, opts) { var html = opts ? opts.cellHTML : true; var z = {}; if(!x) return { t: "" }; if(x.match(/^\s*<(?:\w+:)?t[^>]*>/)) { z.t = unescapexml(utf8read(x.slice(x.indexOf(">")+1).split(/<\/(?:\w+:)?t>/)[0]||"")); z.r = utf8read(x); if(html) z.h = escapehtml(z.t); } else if((x.match(sirregex))) { z.r = utf8read(x); z.t = unescapexml(utf8read((x.replace(sirphregex, '').match(sitregex)||[]).join("").replace(tagregex,""))); if(html) z.h = rs_to_html(parse_rs(z.r)); } return z;}
var sstr0 = /<(?:\w+:)?sst([^>]*)>([\s\S]*)<\/(?:\w+:)?sst>/;var sstr1 = /<(?:\w+:)?(?:si|sstItem)>/g;var sstr2 = /<\/(?:\w+:)?(?:si|sstItem)>/;function parse_sst_xml(data, opts) { var s = ([]), ss = ""; if(!data) return s; var sst = data.match(sstr0); if(sst) { ss = sst[2].replace(sstr1,"").split(sstr2); for(var i = 0; i != ss.length; ++i) { var o = parse_si(ss[i].trim(), opts); if(o != null) s[s.length] = o; } sst = parsexmltag(sst[1]); s.Count = sst.count; s.Unique = sst.uniqueCount; } return s;}
RELS.SST = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings";var straywsregex = /^\s|\s$|[\t\n\r]/;function write_sst_xml(sst, opts) { if(!opts.bookSST) return ""; var o = [XML_HEADER]; o[o.length] = (writextag('sst', null, { xmlns: XMLNS.main[0], count: sst.Count, uniqueCount: sst.Unique })); for(var i = 0; i != sst.length; ++i) { if(sst[i] == null) continue; var s = sst[i]; var sitag = "<si>"; if(s.r) sitag += s.r; else { sitag += "<t"; if(!s.t) s.t = ""; if(s.t.match(straywsregex)) sitag += ' xml:space="preserve"'; sitag += ">" + escapexml(s.t) + "</t>"; } sitag += "</si>"; o[o.length] = (sitag); } if(o.length>2){ o[o.length] = ('</sst>'); o[1]=o[1].replace("/>",">"); } return o.join("");}