多应用+插件架构,代码干净,二开方便,首家独创一键云编译技术,文档视频完善,免费商用码云13.8K 广告
## 4.3.**输入** ### 4.3.1.**数据背景** <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <meta name="ProgId" content="Excel.Sheet"/> <meta name="Generator" content="WPS Office ET"/> <!--[if gte mso 9]> <xml> <o:DocumentProperties> <o:Author>86188</o:Author> <o:Created>2021-09-15T09:29:00</o:Created> <o:LastAuthor>LF情玖、罗格</o:LastAuthor> <o:LastSaved>2021-09-15T10:57:59</o:LastSaved> </o:DocumentProperties> <o:CustomDocumentProperties> <o:KSOProductBuildVer dt:dt="string">2052-11.1.0.10132</o:KSOProductBuildVer> </o:CustomDocumentProperties> </xml> <![endif]--> <style> <!-- @page {margin:1.00in 0.75in 1.00in 0.75in; mso-header-margin:0.50in; mso-footer-margin:0.50in;} tr {mso-height-source:auto; mso-ruby-visibility:none;} col {mso-width-source:auto; mso-ruby-visibility:none;} br {mso-data-placement:same-cell;} .font0 {color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font1 {color:#000000; font-size:12.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font2 {color:#000000; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font3 {color:#44546A; font-size:15.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font4 {color:#800080; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font5 {color:#FFFFFF; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font6 {color:#44546A; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font7 {color:#FA7D00; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font8 {color:#3F3F76; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font9 {color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font10 {color:#9C0006; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font11 {color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font12 {color:#7F7F7F; font-size:11.0pt; font-weight:400; font-style:italic; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font13 {color:#0000FF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font14 {color:#44546A; font-size:18.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font15 {color:#3F3F3F; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font16 {color:#44546A; font-size:13.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font17 {color:#FF0000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font18 {color:#000000; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font19 {color:#FA7D00; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font20 {color:#006100; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font21 {color:#9C6500; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .style0 {mso-number-format:"General"; text-align:general; vertical-align:middle; white-space:nowrap; mso-rotate:0; mso-pattern:auto; mso-background-source:auto; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border:none; mso-protection:locked visible; mso-style-name:"常规"; mso-style-id:0;} .style16 {mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0_ \;_ \0022\00A5\0022* \\-\#\,\#\#0_ \;_ \0022\00A5\0022* \0022-\0022_ \;_ \@_ "; mso-style-name:"货币[0]"; mso-style-id:7;} .style17 {mso-pattern:auto none; background:#EDEDED; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 3";} .style18 {mso-pattern:auto none; background:#FFCC99; color:#3F3F76; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border:.5pt solid #7F7F7F; mso-style-name:"输入";} .style19 {mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0\.00_ \;_ \0022\00A5\0022* \\-\#\,\#\#0\.00_ \;_ \0022\00A5\0022* \0022-\0022??_ \;_ \@_ "; mso-style-name:"货币"; mso-style-id:4;} .style20 {mso-number-format:"_ * \#\,\#\#0_ \;_ * \\-\#\,\#\#0_ \;_ * \0022-\0022_ \;_ \@_ "; mso-style-name:"千位分隔[0]"; mso-style-id:6;} .style21 {mso-pattern:auto none; background:#DBDBDB; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 3";} .style22 {mso-pattern:auto none; background:#FFC7CE; color:#9C0006; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"差";} .style23 {mso-number-format:"_ * \#\,\#\#0\.00_ \;_ * \\-\#\,\#\#0\.00_ \;_ * \0022-\0022??_ \;_ \@_ "; mso-style-name:"千位分隔"; mso-style-id:3;} .style24 {mso-pattern:auto none; background:#C9C9C9; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 3";} .style25 {color:#0000FF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"超链接"; mso-style-id:8;} .style26 {mso-number-format:"0%"; mso-style-name:"百分比"; mso-style-id:5;} .style27 {color:#800080; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"已访问的超链接"; mso-style-id:9;} .style28 {mso-pattern:auto none; background:#FFFFCC; border:.5pt solid #B2B2B2; mso-style-name:"注释";} .style29 {mso-pattern:auto none; background:#F4B084; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 2";} .style30 {color:#44546A; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; mso-style-name:"标题 4";} .style31 {color:#FF0000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"警告文本";} .style32 {color:#44546A; font-size:18.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; mso-style-name:"标题";} .style33 {color:#7F7F7F; font-size:11.0pt; font-weight:400; font-style:italic; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"解释性文本";} .style34 {color:#44546A; font-size:15.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border-left:none; border-top:none; border-right:none; border-bottom:1.0pt solid #5B9BD5; mso-style-name:"标题 1";} .style35 {color:#44546A; font-size:13.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border-left:none; border-top:none; border-right:none; border-bottom:1.0pt solid #5B9BD5; mso-style-name:"标题 2";} .style36 {mso-pattern:auto none; background:#9BC2E6; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 1";} .style37 {color:#44546A; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border-left:none; border-top:none; border-right:none; border-bottom:1.0pt solid #ACCCEA; mso-style-name:"标题 3";} .style38 {mso-pattern:auto none; background:#FFD966; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 4";} .style39 {mso-pattern:auto none; background:#F2F2F2; color:#3F3F3F; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border:.5pt solid #3F3F3F; mso-style-name:"输出";} .style40 {mso-pattern:auto none; background:#F2F2F2; color:#FA7D00; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border:.5pt solid #7F7F7F; mso-style-name:"计算";} .style41 {mso-pattern:auto none; background:#A5A5A5; color:#FFFFFF; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border:2.0pt double #3F3F3F; mso-style-name:"检查单元格";} .style42 {mso-pattern:auto none; background:#E2EFDA; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 6";} .style43 {mso-pattern:auto none; background:#ED7D31; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 2";} .style44 {color:#FA7D00; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border-left:none; border-top:none; border-right:none; border-bottom:2.0pt double #FF8001; mso-style-name:"链接单元格";} .style45 {color:#000000; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border-left:none; border-top:.5pt solid #5B9BD5; border-right:none; border-bottom:2.0pt double #5B9BD5; mso-style-name:"汇总";} .style46 {mso-pattern:auto none; background:#C6EFCE; color:#006100; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"好";} .style47 {mso-pattern:auto none; background:#FFEB9C; color:#9C6500; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"适中";} .style48 {mso-pattern:auto none; background:#D9E1F2; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 5";} .style49 {mso-pattern:auto none; background:#5B9BD5; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 1";} .style50 {mso-pattern:auto none; background:#DDEBF7; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 1";} .style51 {mso-pattern:auto none; background:#BDD7EE; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 1";} .style52 {mso-pattern:auto none; background:#FCE4D6; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 2";} .style53 {mso-pattern:auto none; background:#F8CBAD; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 2";} .style54 {mso-pattern:auto none; background:#A5A5A5; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 3";} .style55 {mso-pattern:auto none; background:#FFC000; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 4";} .style56 {mso-pattern:auto none; background:#FFF2CC; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 4";} .style57 {mso-pattern:auto none; background:#FFE699; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 4";} .style58 {mso-pattern:auto none; background:#4472C4; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 5";} .style59 {mso-pattern:auto none; background:#B4C6E7; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 5";} .style60 {mso-pattern:auto none; background:#8EA9DB; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 5";} .style61 {mso-pattern:auto none; background:#70AD47; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 6";} .style62 {mso-pattern:auto none; background:#C6E0B4; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 6";} .style63 {mso-pattern:auto none; background:#A9D08E; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 6";} td {mso-style-parent:style0; padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; mso-number-format:"General"; text-align:general; vertical-align:middle; white-space:nowrap; mso-rotate:0; mso-pattern:auto; mso-background-source:auto; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border:none; mso-protection:locked visible;} .xl65 {mso-style-parent:style0; text-align:center; white-space:normal; mso-pattern:auto none; background:#FFFF00; font-size:12.0pt; font-weight:700; mso-font-charset:134;} .xl66 {mso-style-parent:style0; text-align:center; white-space:normal; font-size:12.0pt; mso-font-charset:134;} .xl67 {mso-style-parent:style0; text-align:center; white-space:normal; font-size:12.0pt; mso-font-charset:134;} .xl68 {mso-style-parent:style0; text-align:justify; white-space:normal; font-size:12.0pt; mso-font-charset:134;} --> </style> <!--[if gte mso 9]> <xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <x:ExcelWorksheet> <x:Name>Sheet1</x:Name> <x:WorksheetOptions> <x:DefaultRowHeight>270</x:DefaultRowHeight> <x:Selected/> <x:Panes> <x:Pane> <x:Number>3</x:Number> <x:ActiveCol>4</x:ActiveCol> <x:ActiveRow>6</x:ActiveRow> <x:RangeSelection>A1:E7</x:RangeSelection> </x:Pane> </x:Panes> <x:ProtectContents>False</x:ProtectContents> <x:ProtectObjects>False</x:ProtectObjects> <x:ProtectScenarios>False</x:ProtectScenarios> <x:PageBreakZoom>100</x:PageBreakZoom> <x:Print> <x:PaperSizeIndex>9</x:PaperSizeIndex> </x:Print> </x:WorksheetOptions> </x:ExcelWorksheet> </x:ExcelWorksheets> <x:ProtectStructure>False</x:ProtectStructure> <x:ProtectWindows>False</x:ProtectWindows> <x:SelectedSheets>0</x:SelectedSheets> <x:WindowHeight>8385</x:WindowHeight> <x:WindowWidth>19800</x:WindowWidth> </x:ExcelWorkbook> <x:SupBook> <x:Path>C:\Users\86188\Desktop\</x:Path> </x:SupBook> </xml> <![endif]--> </head> <body link="blue" vlink="purple"> <table width="514" border="0" cellpadding="0" cellspacing="0" style='width:385.50pt;border-collapse:collapse;table-layout:fixed;'> <col width="72" span="4" style='width:54.00pt;'/> <col width="226" style='mso-width-source:userset;mso-width-alt:7232;'/> <tr height="38" style='height:28.50pt;'> <td class="xl65" height="38" width="72" style='height:28.50pt;width:54.00pt;' x:str>序号</td> <td class="xl65" width="72" style='width:54.00pt;' x:str>数据来源</td> <td class="xl65" width="72" style='width:54.00pt;' x:str>存储媒体</td> <td class="xl65" width="72" style='width:54.00pt;' x:str>限制条件</td> <td class="xl65" width="226" style='width:169.50pt;' x:str>质量管理</td> </tr> <tr height="76" style='height:57.00pt;mso-height-source:userset;mso-height-alt:1140;'> <td class="xl66" height="94" rowspan="2" style='height:70.50pt;border-right:none;border-bottom:none;' x:str>A</td> <td class="xl66" rowspan="2" style='border-right:none;border-bottom:none;' x:str>用户</td> <td class="xl66" rowspan="2" style='border-right:none;border-bottom:none;' x:str>数据库</td> <td class="xl67" rowspan="2" style='border-right:none;border-bottom:none;' x:str>聊天信息<br/>搜索信息</td> <td class="xl68" rowspan="2" style='border-right:none;border-bottom:none;' x:str>如果输入的数据不合理,系统就会报错</td> </tr> <tr height="18" style='height:13.50pt;'/> <tr height="76" style='height:57.00pt;mso-height-source:userset;mso-height-alt:1140;'> <td class="xl66" height="94" rowspan="2" style='height:70.50pt;border-right:none;border-bottom:none;' x:str>B</td> <td class="xl66" rowspan="2" style='border-right:none;border-bottom:none;' x:str>用户</td> <td class="xl66" rowspan="2" style='border-right:none;border-bottom:none;' x:str>数据库</td> <td class="xl67" rowspan="2" style='border-right:none;border-bottom:none;' x:str>账号<br/>手机号</td> <td class="xl68" rowspan="2" style='border-right:none;border-bottom:none;' x:str>如果输入的数据不合理,系统就会报错</td> </tr> <tr height="18" style='height:13.50pt;'/> <tr height="38" style='height:28.50pt;'> <td class="xl66" height="38" style='height:28.50pt;' x:str>C</td> <td class="xl66" x:str>用户</td> <td class="xl66" x:str>数据库</td> <td class="xl66" x:str>密码</td> <td class="xl68" x:str>如果输入的数据不合理,系统就会报错</td> </tr> <tr height="38" style='height:28.50pt;'> <td class="xl66" height="38" style='height:28.50pt;' x:str>D</td> <td class="xl66" x:str>用户</td> <td class="xl66" x:str>后台</td> <td class="xl66" x:str>图片</td> <td class="xl68" x:str>如果输入的数据不合理,系统将转为文件发送</td> </tr> <![if supportMisalignedColumns]> <tr width="0" style='display:none;'> <td width="226" style='width:170;'></td> </tr> <![endif]> </table> </body> </html> ### 4.3.2.**数据格式** <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <meta name="ProgId" content="Excel.Sheet"/> <meta name="Generator" content="WPS Office ET"/> <!--[if gte mso 9]> <xml> <o:DocumentProperties> <o:Author>86188</o:Author> <o:Created>2021-09-15T09:29:00</o:Created> <o:LastAuthor>LF情玖、罗格</o:LastAuthor> <o:LastSaved>2021-09-15T10:58:41</o:LastSaved> </o:DocumentProperties> <o:CustomDocumentProperties> <o:KSOProductBuildVer dt:dt="string">2052-11.1.0.10132</o:KSOProductBuildVer> </o:CustomDocumentProperties> </xml> <![endif]--> <style> <!-- @page {margin:1.00in 0.75in 1.00in 0.75in; mso-header-margin:0.50in; mso-footer-margin:0.50in;} tr {mso-height-source:auto; mso-ruby-visibility:none;} col {mso-width-source:auto; mso-ruby-visibility:none;} br {mso-data-placement:same-cell;} .font0 {color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font1 {color:#000000; font-size:12.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font2 {color:#000000; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font3 {color:#44546A; font-size:15.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font4 {color:#800080; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font5 {color:#FFFFFF; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font6 {color:#44546A; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font7 {color:#FA7D00; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font8 {color:#3F3F76; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font9 {color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font10 {color:#9C0006; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font11 {color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font12 {color:#7F7F7F; font-size:11.0pt; font-weight:400; font-style:italic; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font13 {color:#0000FF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font14 {color:#44546A; font-size:18.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font15 {color:#3F3F3F; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font16 {color:#44546A; font-size:13.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:134;} .font17 {color:#FF0000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font18 {color:#000000; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font19 {color:#FA7D00; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font20 {color:#006100; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .font21 {color:#9C6500; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"宋体"; mso-generic-font-family:auto; mso-font-charset:0;} .style0 {mso-number-format:"General"; text-align:general; vertical-align:middle; white-space:nowrap; mso-rotate:0; mso-pattern:auto; mso-background-source:auto; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border:none; mso-protection:locked visible; mso-style-name:"常规"; mso-style-id:0;} .style16 {mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0_ \;_ \0022\00A5\0022* \\-\#\,\#\#0_ \;_ \0022\00A5\0022* \0022-\0022_ \;_ \@_ "; mso-style-name:"货币[0]"; mso-style-id:7;} .style17 {mso-pattern:auto none; background:#EDEDED; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 3";} .style18 {mso-pattern:auto none; background:#FFCC99; color:#3F3F76; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border:.5pt solid #7F7F7F; mso-style-name:"输入";} .style19 {mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0\.00_ \;_ \0022\00A5\0022* \\-\#\,\#\#0\.00_ \;_ \0022\00A5\0022* \0022-\0022??_ \;_ \@_ "; mso-style-name:"货币"; mso-style-id:4;} .style20 {mso-number-format:"_ * \#\,\#\#0_ \;_ * \\-\#\,\#\#0_ \;_ * \0022-\0022_ \;_ \@_ "; mso-style-name:"千位分隔[0]"; mso-style-id:6;} .style21 {mso-pattern:auto none; background:#DBDBDB; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 3";} .style22 {mso-pattern:auto none; background:#FFC7CE; color:#9C0006; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"差";} .style23 {mso-number-format:"_ * \#\,\#\#0\.00_ \;_ * \\-\#\,\#\#0\.00_ \;_ * \0022-\0022??_ \;_ \@_ "; mso-style-name:"千位分隔"; mso-style-id:3;} .style24 {mso-pattern:auto none; background:#C9C9C9; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 3";} .style25 {color:#0000FF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"超链接"; mso-style-id:8;} .style26 {mso-number-format:"0%"; mso-style-name:"百分比"; mso-style-id:5;} .style27 {color:#800080; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"已访问的超链接"; mso-style-id:9;} .style28 {mso-pattern:auto none; background:#FFFFCC; border:.5pt solid #B2B2B2; mso-style-name:"注释";} .style29 {mso-pattern:auto none; background:#F4B084; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 2";} .style30 {color:#44546A; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; mso-style-name:"标题 4";} .style31 {color:#FF0000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"警告文本";} .style32 {color:#44546A; font-size:18.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; mso-style-name:"标题";} .style33 {color:#7F7F7F; font-size:11.0pt; font-weight:400; font-style:italic; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"解释性文本";} .style34 {color:#44546A; font-size:15.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border-left:none; border-top:none; border-right:none; border-bottom:1.0pt solid #5B9BD5; mso-style-name:"标题 1";} .style35 {color:#44546A; font-size:13.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border-left:none; border-top:none; border-right:none; border-bottom:1.0pt solid #5B9BD5; mso-style-name:"标题 2";} .style36 {mso-pattern:auto none; background:#9BC2E6; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 1";} .style37 {color:#44546A; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border-left:none; border-top:none; border-right:none; border-bottom:1.0pt solid #ACCCEA; mso-style-name:"标题 3";} .style38 {mso-pattern:auto none; background:#FFD966; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 4";} .style39 {mso-pattern:auto none; background:#F2F2F2; color:#3F3F3F; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border:.5pt solid #3F3F3F; mso-style-name:"输出";} .style40 {mso-pattern:auto none; background:#F2F2F2; color:#FA7D00; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border:.5pt solid #7F7F7F; mso-style-name:"计算";} .style41 {mso-pattern:auto none; background:#A5A5A5; color:#FFFFFF; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border:2.0pt double #3F3F3F; mso-style-name:"检查单元格";} .style42 {mso-pattern:auto none; background:#E2EFDA; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 6";} .style43 {mso-pattern:auto none; background:#ED7D31; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 2";} .style44 {color:#FA7D00; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border-left:none; border-top:none; border-right:none; border-bottom:2.0pt double #FF8001; mso-style-name:"链接单元格";} .style45 {color:#000000; font-size:11.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; border-left:none; border-top:.5pt solid #5B9BD5; border-right:none; border-bottom:2.0pt double #5B9BD5; mso-style-name:"汇总";} .style46 {mso-pattern:auto none; background:#C6EFCE; color:#006100; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"好";} .style47 {mso-pattern:auto none; background:#FFEB9C; color:#9C6500; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"适中";} .style48 {mso-pattern:auto none; background:#D9E1F2; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 5";} .style49 {mso-pattern:auto none; background:#5B9BD5; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 1";} .style50 {mso-pattern:auto none; background:#DDEBF7; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 1";} .style51 {mso-pattern:auto none; background:#BDD7EE; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 1";} .style52 {mso-pattern:auto none; background:#FCE4D6; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 2";} .style53 {mso-pattern:auto none; background:#F8CBAD; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 2";} .style54 {mso-pattern:auto none; background:#A5A5A5; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 3";} .style55 {mso-pattern:auto none; background:#FFC000; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 4";} .style56 {mso-pattern:auto none; background:#FFF2CC; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"20% - 强调文字颜色 4";} .style57 {mso-pattern:auto none; background:#FFE699; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 4";} .style58 {mso-pattern:auto none; background:#4472C4; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 5";} .style59 {mso-pattern:auto none; background:#B4C6E7; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 5";} .style60 {mso-pattern:auto none; background:#8EA9DB; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 5";} .style61 {mso-pattern:auto none; background:#70AD47; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"强调文字颜色 6";} .style62 {mso-pattern:auto none; background:#C6E0B4; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"40% - 强调文字颜色 6";} .style63 {mso-pattern:auto none; background:#A9D08E; color:#FFFFFF; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:0; mso-style-name:"60% - 强调文字颜色 6";} td {mso-style-parent:style0; padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; mso-number-format:"General"; text-align:general; vertical-align:middle; white-space:nowrap; mso-rotate:0; mso-pattern:auto; mso-background-source:auto; color:#000000; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; border:none; mso-protection:locked visible;} .xl65 {mso-style-parent:style0; text-align:center; white-space:normal; mso-pattern:auto none; background:#FFFF00; font-size:12.0pt; font-weight:700; mso-font-charset:134;} .xl66 {mso-style-parent:style0; text-align:center; white-space:normal; font-size:12.0pt; mso-font-charset:134;} .xl67 {mso-style-parent:style0; text-align:justify; white-space:normal; font-size:12.0pt; mso-font-charset:134;} --> </style> <!--[if gte mso 9]> <xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <x:ExcelWorksheet> <x:Name>Sheet1</x:Name> <x:WorksheetOptions> <x:DefaultRowHeight>270</x:DefaultRowHeight> <x:Selected/> <x:Panes> <x:Pane> <x:Number>3</x:Number> <x:ActiveCol>3</x:ActiveCol> <x:ActiveRow>7</x:ActiveRow> <x:RangeSelection>D8</x:RangeSelection> </x:Pane> </x:Panes> <x:ProtectContents>False</x:ProtectContents> <x:ProtectObjects>False</x:ProtectObjects> <x:ProtectScenarios>False</x:ProtectScenarios> <x:PageBreakZoom>100</x:PageBreakZoom> <x:Print> <x:PaperSizeIndex>9</x:PaperSizeIndex> </x:Print> </x:WorksheetOptions> </x:ExcelWorksheet> </x:ExcelWorksheets> <x:ProtectStructure>False</x:ProtectStructure> <x:ProtectWindows>False</x:ProtectWindows> <x:SelectedSheets>0</x:SelectedSheets> <x:WindowHeight>8385</x:WindowHeight> <x:WindowWidth>19800</x:WindowWidth> </x:ExcelWorkbook> <x:SupBook> <x:Path>C:\Users\86188\Desktop\</x:Path> </x:SupBook> </xml> <![endif]--> </head> <body link="blue" vlink="purple"> <table width="514" border="0" cellpadding="0" cellspacing="0" style='width:385.50pt;border-collapse:collapse;table-layout:fixed;'> <col width="72" span="4" style='width:54.00pt;'/> <col width="226" style='mso-width-source:userset;mso-width-alt:7232;'/> <tr height="19" style='height:14.25pt;'> <td class="xl65" height="19" width="72" style='height:14.25pt;width:54.00pt;' x:str>序号</td> <td class="xl65" width="72" style='width:54.00pt;' x:str>长度</td> <td class="xl65" width="72" style='width:54.00pt;' x:str>格式</td> <td class="xl65" width="72" style='width:54.00pt;' x:str>顺序</td> <td class="xl65" width="226" style='width:169.50pt;' x:str>词汇表</td> </tr> <tr height="38" style='height:28.50pt;'> <td class="xl66" height="38" style='height:28.50pt;' x:str>A</td> <td class="xl66" x:str>1<font class="font2">个字节</font><font class="font2">及</font><font class="font2">以上</font></td> <td class="xl66" x:str>字符串</td> <td class="xl66" x:str>从左至右</td> <td class="xl67" x:str>只限字母、符号、数字</td> </tr> <tr height="57" style='height:42.75pt;'> <td class="xl66" height="57" style='height:42.75pt;' x:str>B</td> <td class="xl66" x:str>14/11个字节<font class="font2">及</font><font class="font2">以上</font></td> <td class="xl66" x:str>整形</td> <td class="xl66" x:str>从左至右</td> <td class="xl67" x:str>只限数字</td> </tr> <tr height="57" style='height:42.75pt;'> <td class="xl66" height="57" style='height:42.75pt;' x:str>C</td> <td class="xl66" x:str>8<font class="font2">个字节</font><font class="font2">及</font><font class="font2">以上</font></td> <td class="xl66" x:str>字符串</td> <td class="xl66" x:str>从左至右</td> <td class="xl67" x:str>只限大写字母、小写字母、符号、数字,且至少包含四种中的三种</td> </tr> <tr height="38" style='height:28.50pt;'> <td class="xl66" height="38" style='height:28.50pt;' x:str>D</td> <td class="xl66" x:str>1<font class="font2">个字节</font><font class="font2">及</font><font class="font2">以上</font></td> <td class="xl66" x:str>png,jpg,jfif</td> <td class="xl66" x:str>-</td> <td class="xl66" x:str>-</td> </tr> <![if supportMisalignedColumns]> <tr width="0" style='display:none;'> <td width="226" style='width:170;'></td> </tr> <![endif]> </table> </body> </html> ### 4.3.3.**输入举例** #### A. 国服牛魔(搜索信息) #### B. 18812345678(手机号) #### C. Ceshimima123456(密码) #### D. 5.2.28-1.png(图片)