L.2.3.5 The XML
L.2.3.5 The XML
The shared string table XML for this example looks like this:
<sst … count="35" uniqueCount="22">
<si>
<t>United States</t>
</si>
<si>
<t>Seattle</t>
</si>
<si>
<t>Denver</t>
</si>
<si>
<t>New York</t>
</si>
<si>
<t>Philadelphia</t>
</si>
<si>
<t>Houton</t>
</si>
<si>
<t>San Diego</t>
</si>
<si>
<t>San Francisco</t>
</si>
<si>
<t>Argentina</t>
</si>
<si>
<t>Buenos Aires</t>
</si>
<si>
<t>San Juan</t>
</si>
<si>
<t>Salta</t>
</si>
<si>
<t>Rosario</t>
</si>
<si>
<t>La Plata</t>
</si>
<si>
<t>Japan</t>
</si>
<si>
<t>Tokyo</t>
</si>
<si>
<t>Nagoya</t>
</si>
<si>
<t>Yokohama</t>
</si>
<si>
<t>Sendai</t>
</si>
<si>
<t>Country</t>
</si>
<si>
<t>City</t>
</si>
<si>
<t>Data</t>
</si>
</sst>The cell table for this example looks like this:
<sheetData>
<row r="2" spans="2:4" customFormat="1">
<c r="B2" s="1" t="s">
<v>19</v>
</c>
<c r="C2" s="1" t="s">
<v>20</v>
</c>
<c r="D2" s="1" t="s">
<v>21</v>
</c>
</row>
<row r="3" spans="2:4" customFormat="1">
<c r="B3" t="s">
<v>0</v>
</c>
<c r="C3" t="s">
<v>1</v>
</c>
<c r="D3">
<f t="shared" ref="D3:D18" ca="1" si="0">ROUND(RAND()*1000,2)</f>
<v>374.9</v>
</c>
</row>
<row r="4" spans="2:4" customFormat="1">
<c r="B4" t="s">
<v>0</v>
</c>
<c r="C4" t="s">
<v>2</v>
</c>
<c r="D4">
<f t="shared" ca="1" si="0"/>
<v>452.82</v>
</c>
</row>
<row r="5" spans="2:4" customFormat="1">
<c r="B5" t="s">
<v>0</v>
</c>
<c r="C5" t="s">
<v>3</v>
</c>
<c r="D5">
<f t="shared" ca="1" si="0"/>
<v>632.1</v>
</c>
</row>
<row r="6" spans="2:4" customFormat="1">
<c r="B6" t="s">
<v>0</v>
</c>
<c r="C6" t="s">
<v>4</v>
</c>
<c r="D6">
<f t="shared" ca="1" si="0"/>
<v>886.37</v>
</c>
</row>
<row r="7" spans="2:4" customFormat="1">
<c r="B7" t="s">
<v>0</v>
</c>
<c r="C7" t="s">
<v>5</v>
</c>
<c r="D7">
<f t="shared" ca="1" si="0"/>
<v>291.14</v>
</c>
</row>
<row r="8" spans="2:4" customFormat="1">
<c r="B8" t="s">
<v>0</v>
</c>
<c r="C8" t="s">
<v>6</v>
</c>
<c r="D8">
<f t="shared" ca="1" si="0"/>
<v>114.97</v>
</c>
</row>
<row r="9" spans="2:4" customFormat="1">
<c r="B9" t="s">
<v>0</v>
</c>
<c r="C9" t="s">
<v>7</v>
</c>
<c r="D9">
<f t="shared" ca="1" si="0"/>
<v>291.99</v>
</c>
</row>
<row r="10" spans="2:4" customFormat="1">
<c r="B10" t="s">
<v>8</v>
</c>
<c r="C10" t="s">
<v>9</v>
</c>
<c r="D10">
<f t="shared" ca="1" si="0"/>
<v>335.42</v>
</c>
</row>
<row r="11" spans="2:4" customFormat="1">
<c r="B11" t="s">
<v>8</v>
</c>
<c r="C11" t="s">
<v>10</v>
</c>
<c r="D11">
<f t="shared" ca="1" si="0"/>
<v>664.72</v>
</c>
</row>
<row r="12" spans="2:4" customFormat="1">
<c r="B12" t="s">
<v>8</v>
</c>
<c r="C12" t="s">
<v>11</v>
</c>
<c r="D12">
<f t="shared" ca="1" si="0"/>
<v>992.62</v>
</c>
</row>
<row r="13" spans="2:4" customFormat="1">
<c r="B13" t="s">
<v>8</v>
</c>
<c r="C13" t="s">
<v>12</v>
</c>
<c r="D13">
<f t="shared" ca="1" si="0"/>
<v>148.5</v>
</c>
</row>
<row r="14" spans="2:4" customFormat="1">
<c r="B14" t="s">
<v>8</v>
</c>
<c r="C14" t="s">
<v>13</v>
</c>
<c r="D14">
<f t="shared" ca="1" si="0"/>
<v>193.53</v>
</c>
</row>
<row r="15" spans="2:4" customFormat="1">
<c r="B15" t="s">
<v>14</v>
</c>
<c r="C15" t="s">
<v>15</v>
</c>
<c r="D15">
<f t="shared" ca="1" si="0"/>
<v>849.36</v>
</c>
</row>
<row r="16" spans="2:4" customFormat="1">
<c r="B16" t="s">
<v>14</v>
</c>
<c r="C16" t="s">
<v>16</v>
</c>
<c r="D16">
<f t="shared" ca="1" si="0"/>
<v>765.46</v>
</c>
</row>
<row r="17" spans="2:4" customFormat="1">
<c r="B17" t="s">
<v>14</v>
</c>
<c r="C17" t="s">
<v>17</v>
</c>
<c r="D17">
<f t="shared" ca="1" si="0"/>
<v>350.26</v>
</c>
</row>
<row r="18" spans="2:4" customFormat="1">
<c r="B18" t="s">
<v>14</v>
</c>
<c r="C18" t="s">
<v>18</v>
</c>
<c r="D18">
<f t="shared" ca="1" si="0"/>
<v>979.22</v>
</c>
</row>
</sheetData>Last updated on