sheet.xml中主要设置单元格的内容，其中数字部分直接写在单元格中，其他则只写引用ID，实际内容统一存储在sharedStrings.xml中
sheet1.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"> <sheetPr codeName="Sheet3"/> <dimension ref="A1:G24"/> <sheetViews> <sheetView workbookViewId="0"> <selection activeCell="K14" sqref="K14"/> </sheetView> </sheetViews> <sheetFormatPr defaultRowHeight="14.4"/> <cols> <col min="1" max="1" width="30.44140625" bestFit="1" customWidth="1"/> <col min="2" max="2" width="16.21875" customWidth="1"/> <col min="3" max="3" width="14.6640625" customWidth="1"/> <col min="4" max="4" width="13" customWidth="1"/> <col min="5" max="5" width="24.33203125" customWidth="1"/> <col min="6" max="6" width="30.109375" customWidth="1"/> <col min="7" max="7" width="28.109375" customWidth="1"/> <col min="8" max="8" width="18.109375" customWidth="1"/> </cols> <sheetData> <!--row:一行 r:第几行下标从1开始 spans:1-7列有内容下标从1开始--> <row r="1" spans="1:7"> <!-- c:一个单元格 r:单位格位置 s: t="s":type="string" 字符内容分两种String和Number Number直接写实际内容在当前单元格 String内容引用sharedStrings.xml中的si.id 就是这里的<v>48</v>表示第48个si(下标从0开始) --> <c r="A1" s="20" t="s"><v>48</v></c> <c r="B1" s="1"/> <c r="C1" s="1"/> <c r="D1" s="1"/> <c r="E1" s="1"/> <c r="F1" s="1"/> <c r="G1" s="1"/> </row> <row r="2" spans="1:7" ht="17.399999999999999"> <c r="A2" s="31" t="s"><v>0</v></c> <c r="B2" s="31"/> <c r="C2" s="31"/> <c r="D2" s="31"/> <c r="E2" s="31"/> <c r="F2" s="31"/> <c r="G2" s="31"/> </row> <row r="3" spans="1:7" ht="13.5" customHeight="1"> <c r="A3" s="2" t="s"><v>1</v></c> <c r="B3" s="32" t="s"><v>49</v></c> <c r="C3" s="32"/> <c r="D3" s="4" t="s"><v>2</v></c> <c r="E3" s="11" t="s"><v>54</v></c> <c r="F3" s="4" t="s"><v>3</v></c> <c r="G3" s="11" t="s"><v>50</v></c></row><row r="4" spans="1:7"> <c r="A4" s="3" t="s"><v>4</v></c> <c r="B4" s="33" t="s"><v>53</v></c> <c r="C4" s="33"/> <c r="D4" s="3" t="s"><v>5</v></c> <c r="E4" s="12" t="s"><v>52</v></c> <c r="F4" s="3" t="s"><v>6</v></c> <c r="G4" s="12" t="s"><v>51</v></c></row><row r="5" spans="1:7"> <c r="A5" s="4" t="s"><v>7</v></c> <c r="B5" s="28" t="s"><v>55</v></c> <c r="C5" s="29"/> <c r="D5" s="29"/> <c r="E5" s="29"/> <c r="F5" s="29"/> <c r="G5" s="30"/> </row> <row r="6" spans="1:7"> <c r="A6" s="34" t="s"><v>8</v></c> <c r="B6" s="4" t="s"><v>9</v></c> <c r="C6" s="15"><v>101.1</v></c> <c r="D6" s="4" t="s"><v>10</v></c> <c r="E6" s="17"><v>24.7</v></c> <c r="F6" s="2" t="s"><v>11</v></c> <c r="G6" s="17"><v>55</v></c> </row> <row r="7" spans="1:7" ht="28.8"> <c r="A7" s="34"/> <c r="B7" s="4" t="s"><v>12</v></c> <c r="C7" s="16"><v>81.599999999999994</v></c> <c r="D7" s="6"/> <c r="E7" s="5"/> <c r="F7" s="7"/> <c r="G7" s="7"/> </row> <row r="8" spans="1:7"> <c r="A8" s="25" t="s"><v>47</v></c> <c r="B8" s="26"/> <c r="C8" s="26"/> <c r="D8" s="26"/> <c r="E8" s="26"/> <c r="F8" s="26"/> <c r="G8" s="27"/> </row> <row r="9" spans="1:7" ht="28.5" customHeight="1"> <c r="A9" s="4" t="s"><v>42</v></c> <c r="B9" s="24" t="s"><v>57</v></c> <c r="C9" s="24"/> <c r="D9" s="24"/> <c r="E9" s="24"/> <c r="F9" s="24"/> <c r="G9" s="24"/> </row> <row r="10" spans="1:7" ht="28.8"> <c r="A10" s="4" t="s"><v>43</v></c> <c r="B10" s="23" t="s"><v>58</v></c> <c r="C10" s="24"/> <c r="D10" s="24"/> <c r="E10" s="24"/> <c r="F10" s="24"/> <c r="G10" s="24"/> </row> <row r="11" spans="1:7" ht="28.8"> <c r="A11" s="2" t="s"><v>13</v></c> <c r="B11" s="8" t="s"><v>14</v></c> <c r="C11" s="8" t="s"><v>15</v></c> <c r="D11" s="10" t="s"><v>45</v></c> <c r="E11" s="4" t="s"><v>46</v></c> <c r="F11" s="4" t="s"><v>41</v></c> <c r="G11" s="4" t="s"><v>56</v></c> </row> <row r="12" spans="1:7"> <c r="A12" s="6"><v>57</v></c> <c r="B12" s="9" t="s"><v>16</v></c> <c r="C12" s="18" t="s"><v>17</v></c> <c r="D12" s="14"><v>0.21</v></c> <c r="E12" s="14"><v>5.74</v></c> <c r="F12" s="13"/> <c r="G12" s="14"><v>5.78</v></c> </row> <row r="13" spans="1:7"> <c r="A13" s="6"><v>58</v></c> <c r="B13" s="9" t="s"><v>18</v></c> <c r="C13" s="18" t="s"><v>19</v></c> <c r="D13" s="14"><v>0.22</v></c> <c r="E13" s="14"><v>2.71</v></c> <c r="F13" s="13"/> <c r="G13" s="14"><v>2.63</v></c> </row> <row r="14" spans="1:7"> <c r="A14" s="6"><v>59</v></c> <c r="B14" s="9" t="s"><v>20</v></c> <c r="C14" s="18" t="s"><v>21</v></c> <c r="D14" s="14"><v>0.19</v></c> <c r="E14" s="21"><v>-999</v></c> <c r="F14" s="13"/> <c r="G14" s="21"><v>-999</v></c> </row> <row r="15" spans="1:7"> <c r="A15" s="6"><v>60</v></c> <c r="B15" s="9" t="s"><v>22</v></c> <c r="C15" s="18" t="s"><v>23</v></c> <c r="D15" s="14"><v>0.19</v></c> <c r="E15" s="14"><v>9.3000000000000007</v></c> <c r="F15" s="19"/> <c r="G15" s="14"><v>8.94</v></c> </row> <row r="16" spans="1:7"> <c r="A16" s="6"><v>61</v></c> <c r="B16" s="9" t="s"><v>24</v></c> <c r="C16" s="18" t="s"><v>25</v></c> <c r="D16" s="14"><v>0.28000000000000003</v></c> <c r="E16" s="21"><v>-999</v></c> <c r="F16" s="13"/> <c r="G16" s="21"><v>-999</v></c> </row> <row r="17" spans="1:7"> <c r="A17" s="6"><v>62</v></c> <c r="B17" s="9" t="s"><v>26</v></c> <c r="C17" s="18" t="s"><v>27</v></c> <c r="D17" s="14"><v>0.25</v></c> <c r="E17" s="21"><v>-999</v></c> <c r="F17" s="13"/> <c r="G17" s="21"><v>-999</v></c> </row> <row r="18" spans="1:7"> <c r="A18" s="6"><v>63</v></c> <c r="B18" s="9" t="s"><v>28</v></c> <c r="C18" s="18" t="s"><v>29</v></c> <c r="D18" s="14"><v>0.22</v></c> <c r="E18" s="21"><v>-999</v></c> <c r="F18" s="13"/> <c r="G18" s="21"><v>-999</v></c> </row> <row r="19" spans="1:7"> <c r="A19" s="6"><v>64</v></c> <c r="B19" s="6" t="s"><v>30</v></c> <c r="C19" s="18" t="s"><v>31</v></c> <c r="D19" s="14"><v>0.21</v></c> <c r="E19" s="21"><v>-999</v></c> <c r="F19" s="13"/> <c r="G19" s="21"><v>-999</v></c> </row> <row r="20" spans="1:7"> <c r="A20" s="6"><v>65</v></c> <c r="B20" s="9" t="s"><v>32</v></c> <c r="C20" s="18" t="s"><v>33</v></c> <c r="D20" s="14"><v>0.24</v></c> <c r="E20" s="21"><v>-999</v></c> <c r="F20" s="13"/> <c r="G20" s="21"><v>-999</v></c> </row> <row r="21" spans="1:7"> <c r="A21" s="6"><v>66</v></c> <c r="B21" s="9" t="s"><v>34</v></c> <c r="C21" s="18" t="s"><v>35</v></c> <c r="D21" s="14"><v>0.28999999999999998</v></c> <c r="E21" s="21"><v>-999</v></c> <c r="F21" s="13"/> <c r="G21" s="21"><v>-999</v></c> </row> <row r="22" spans="1:7"> <c r="A22" s="6"><v>67</v></c> <c r="B22" s="9" t="s"><v>36</v></c> <c r="C22" s="18" t="s"><v>37</v></c> <c r="D22" s="14"><v>0.24</v></c> <c r="E22" s="21"><v>-999</v></c> <c r="F22" s="13"/> <c r="G22" s="21"><v>-999</v></c> </row> <row r="23" spans="1:7"> <c r="A23" s="6"><v>68</v></c> <c r="B23" s="9" t="s"><v>38</v></c> <c r="C23" s="18" t="s"><v>39</v></c> <c r="D23" s="14"><v>0.32</v></c> <c r="E23" s="21"><v>-999</v></c> <c r="F23" s="13"/> <c r="G23" s="21"><v>-999</v></c> </row> <row r="24" spans="1:7"> <c r="A24" s="6"><v>69</v></c> <c r="B24" s="9" t="s"><v>40</v></c> <c r="C24" s="18" t="s"><v>44</v></c> <c r="D24" s="14"><v>0.32</v></c> <c r="E24" s="21"><v>-999</v></c> <c r="F24" s="13"/> <c r="G24" s="21"><v>-999</v></c> </row> </sheetData> <mergeCells count="8"> <mergeCell ref="B10:G10"/> <mergeCell ref="A8:G8"/> <mergeCell ref="B5:G5"/> <mergeCell ref="A2:G2"/> <mergeCell ref="B3:C3"/> <mergeCell ref="B4:C4"/> <mergeCell ref="A6:A7"/> <mergeCell ref="B9:G9"/> </mergeCells> <phoneticPr fontId="1" type="noConversion"/> <conditionalFormatting sqref="C3"> <cfRule type="duplicateValues" dxfId="3" priority="5"/> </conditionalFormatting> <conditionalFormatting sqref="C8"> <cfRule type="duplicateValues" dxfId="2" priority="1"/> </conditionalFormatting> <conditionalFormatting sqref="C9:C10"> <cfRule type="duplicateValues" dxfId="1" priority="4"/> </conditionalFormatting> <conditionalFormatting sqref="C1:C2 C4:C7 C11:C1048576"> <cfRule type="duplicateValues" dxfId="0" priority="8"/> </conditionalFormatting> <pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/> <pageSetup paperSize="9" orientation="portrait" horizontalDpi="200" verticalDpi="200" r:id="rId1"/> </worksheet>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"> <dimension ref="A1:F6"/> <sheetViews> <sheetView tabSelected="1" workbookViewId="0"> <selection activeCell="E6" sqref="E6"/> </sheetView> </sheetViews> <sheetFormatPr defaultRowHeight="14.4"/> <cols> <col min="1" max="1" width="12.109375" customWidth="1"/> </cols> <sheetData> <row r="1" spans="1:6"> <c r="A1" s="35"><v>111</v></c> <c r="B1" s="35"><v>222</v></c> <c r="C1" s="35"/><c r="D1" s="22"/> <c r="E1" s="35"><v>333</v></c> <c r="F1" s="35"/> </row> <row r="2" spans="1:6"> <c r="A2" s="35"/> <c r="E2" s="35"/> <c r="F2" s="35"/> </row> <row r="3" spans="1:6" ht="15" thickBot="1"> <c r="A3" s="35"/> <c r="E3" s="35"/> <c r="F3" s="35"/> </row> <row r="4" spans="1:6" ht="15" thickBot="1"> <c r="A4" t="s"><v>59</v></c> <c r="B4" t="s"><v>60</v></c> <c r="C4" s="38"><v>123</v></c> </row> <row r="5" spans="1:6"> <c r="A5" s="37"><v>1</v></c> <c r="B5"><v>2</v></c> <c r="C5"><v>3</v></c> <c r="D5" s="36" t="s"><v>61</v></c> <c r="E5"><f>SUM(A5:C5)</f><v>6</v></c> </row> <row r="6" spans="1:6" ht="55.2" customHeight="1"/> </sheetData> <mergeCells count="3"> <mergeCell ref="A1:A3"/> <mergeCell ref="B1:C1"/> <mergeCell ref="E1:F3"/> </mergeCells> <phoneticPr fontId="1" type="noConversion"/> <pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/> <pageSetup paperSize="9" orientation="portrait" r:id="rId1"/> <drawing r:id="rId2"/> </worksheet>