1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
RELS.XLMETA = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/sheetMetadata";function parse_xlmeta_xml(data, name, opts) {  var out = { Types: [] };  if (!data)    return out;  var pass = false;  data.replace(tagregex, function(x, idx) {    var y = parsexmltag(x);    switch (strip_ns(y[0])) {      case "<?xml":        break;      case "<metadata":      case "</metadata>":        break;      case "<metadataTypes":      case "</metadataTypes>":        break;      case "<metadataType":        out.Types.push({ name: y.name });        break;      case "<futureMetadata":        break;      case "</futureMetadata>":        break;      case "<bk>":        break;      case "</bk>":        break;      case "<rc":        break;      case "</rc>":        break;      case "<cellMetadata":      case "</cellMetadata>":        break;      case "<valueMetadata":        break;      case "</valueMetadata>":        break;      case "<extLst":      case "<extLst>":      case "</extLst>":      case "<extLst/>":        break;      case "<ext":        pass = true;        break;      case "</ext>":        pass = false;        break;      default:        if (!pass && opts.WTF)          throw new Error("unrecognized " + y[0] + " in metadata");    }    return x;  });  return out;}function write_xlmeta_xml() {  var o = [XML_HEADER];  o.push('<metadata xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xlrd="http://schemas.microsoft.com/office/spreadsheetml/2017/richdata" xmlns:xda="http://schemas.microsoft.com/office/spreadsheetml/2017/dynamicarray">\n  <metadataTypes count="1">\n    <metadataType name="XLDAPR" minSupportedVersion="120000" copy="1" pasteAll="1" pasteValues="1" merge="1" splitFirst="1" rowColShift="1" clearFormats="1" clearComments="1" assign="1" coerce="1" cellMeta="1"/>\n  </metadataTypes>\n  <futureMetadata name="XLDAPR" count="1">\n    <bk>\n      <extLst>\n        <ext uri="{bdbb8cdc-fa1e-496e-a857-3c3f30c029c3}">\n          <xda:dynamicArrayProperties fDynamic="1" fCollapsed="0"/>\n        </ext>\n      </extLst>\n    </bk>\n  </futureMetadata>\n  <cellMetadata count="1">\n    <bk>\n      <rc t="1" v="0"/>\n    </bk>\n  </cellMetadata>\n</metadata>');  return o.join("");}function parse_BrtMdtinfo(data, length) {  return {    flags: data.read_shift(4),    version: data.read_shift(4),    name: parse_XLWideString(data, length - 8)  };}function write_BrtMdtinfo(data) {  var o = new_buf(12 + 2 * data.name.length);  o.write_shift(4, data.flags);  o.write_shift(4, data.version);  write_XLWideString(data.name, o);  return o.slice(0, o.l);}function write_BrtMdb(mdb) {  var o = new_buf(4 + 8 * mdb.length);  o.write_shift(4, mdb.length);  for (var i = 0; i < mdb.length; ++i) {    o.write_shift(4, mdb[i][0]);    o.write_shift(4, mdb[i][1]);  }  return o;}function write_BrtBeginEsfmd(cnt, name) {  var o = new_buf(8 + 2 * name.length);  o.write_shift(4, cnt);  write_XLWideString(name, o);  return o.slice(0, o.l);}function write_BrtBeginEsmdb(cnt, cm) {  var o = new_buf(8);  o.write_shift(4, cnt);  o.write_shift(4, cm ? 1 : 0);  return o;}function parse_xlmeta_bin(data, name, _opts) {  var out = { Types: [] };  var opts = _opts || {};  var state = [];  var pass = false;  recordhopper(data, function(val, R_n, RT) {    switch (RT) {      case 335:        out.Types.push({ name: val.name });        break;      case 51:        break;      case 35:        state.push(R_n);        pass = true;        break;      case 36:        state.pop();        pass = false;        break;      default:        if ((R_n || "").indexOf("Begin") > 0) {        } else if ((R_n || "").indexOf("End") > 0) {        } else if (!pass || opts.WTF && state[state.length - 1] != "BrtFRTBegin")          throw new Error("Unexpected record " + RT + " " + R_n);    }  });  return out;}function write_xlmeta_bin() {  var ba = buf_array();  write_record(ba, "BrtBeginMetadata");  write_record(ba, "BrtBeginEsmdtinfo", write_UInt32LE(1));  write_record(ba, "BrtMdtinfo", write_BrtMdtinfo({    name: "XLDAPR",    version: 12e4,    flags: 3496657072  }));  write_record(ba, "BrtEndEsmdtinfo");  write_record(ba, "BrtBeginEsfmd", write_BrtBeginEsfmd(1, "XLDAPR"));  write_record(ba, "BrtBeginFmd");  write_record(ba, "BrtFRTBegin", write_UInt32LE(514));  write_record(ba, "BrtBeginDynamicArrayPr", write_UInt32LE(0));  write_record(ba, "BrtEndDynamicArrayPr", writeuint16(1));  write_record(ba, "BrtFRTEnd");  write_record(ba, "BrtEndFmd");  write_record(ba, "BrtEndEsfmd");  write_record(ba, "BrtBeginEsmdb", write_BrtBeginEsmdb(1, true));  write_record(ba, "BrtMdb", write_BrtMdb([[1, 0]]));  write_record(ba, "BrtEndEsmdb");  write_record(ba, "BrtEndMetadata");  return ba.end();}