 |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
相关问题
订阅该问题
悬赏分：20 - 2007年06月04日
项目需要
本来是直接从文本中读数据的
后来改成要求从Excel文件中读数据
这个格式太不好弄
Office2003能直接将Excel文件另存为XML
但是Office2000只能另存成HTML文件
哪位大大帮看一下
给个从里面导出数据的思路
我知道这个也可以按XML格式来处理
但是没头绪
CODE: <html 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=??????"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 11"> <link rel=File-List href="Exam.files/filelist.xml"> <link rel=Edit-Time-Data href="Exam.files/editdata.mso"> <link rel=OLE-Object-Data href="Exam.files/oledata.mso"> <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>HCT1</o:Author> <o:LastAuthor>刘骏</o:LastAuthor> <o:Created>2004-02-03T03:15:55Z</o:Created> <o:LastSaved>2004-02-17T02:13:23Z</o:LastSaved> <o:Company>HCT</o:Company> <o:Version>11.5606</o:Version> </o:DocumentProperties> </xml><![endif]--> <style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} tr {mso-height-source:auto; mso-ruby-visibility:none;} col {mso-width-source:auto; mso-ruby-visibility:none;} br {mso-data-placement:same-cell;} .style0 {mso-number-format:General; text-align:general; vertical-align:middle; white-space:nowrap; mso-rotate:0; mso-background-source:auto; mso-pattern:auto; color:windowtext; font-size:12.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;} td {mso-style-parent:style0; padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; mso-number-format:General; text-align:general; vertical-align:middle; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl24 {mso-style-parent:style0; mso-number-format:"\@";} ruby {ruby-align:left;} rt {color:windowtext; font-size:9.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:宋体; mso-generic-font-family:auto; mso-font-charset:134; mso-char-type:none; display:none;} --> </style> <!--[if gte mso 9]><xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <x:ExcelWorksheet> <x:Name>Sheet1</x:Name> <x:WorksheetOptions> <x:DefaultRowHeight>285</x:DefaultRowHeight> <x:Selected/> <x:ProtectContents>False</x:ProtectContents> <x:ProtectObjects>False</x:ProtectObjects> <x:ProtectScenarios>False</x:ProtectScenarios> </x:WorksheetOptions> </x:ExcelWorksheet> <x:ExcelWorksheet> <x:Name>Sheet2</x:Name> <x:WorksheetOptions> <x:DefaultRowHeight>285</x:DefaultRowHeight> <x:ProtectContents>False</x:ProtectContents> <x:ProtectObjects>False</x:ProtectObjects> <x:ProtectScenarios>False</x:ProtectScenarios> </x:WorksheetOptions> </x:ExcelWorksheet> <x:ExcelWorksheet> <x:Name>Sheet3</x:Name> <x:WorksheetOptions> <x:DefaultRowHeight>285</x:DefaultRowHeight> <x:ProtectContents>False</x:ProtectContents> <x:ProtectObjects>False</x:ProtectObjects> <x:ProtectScenarios>False</x:ProtectScenarios> </x:WorksheetOptions> </x:ExcelWorksheet> </x:ExcelWorksheets> <x:WindowHeight>9225</x:WindowHeight> <x:WindowWidth>11700</x:WindowWidth> <x:WindowTopX>240</x:WindowTopX> <x:WindowTopY>120</x:WindowTopY> <x:ProtectStructure>False</x:ProtectStructure> <x:ProtectWindows>False</x:ProtectWindows> </x:ExcelWorkbook> </xml><![endif]--> </head> <body link=blue vlink=purple> <table x:str border=0 cellpadding=0 cellspacing=0 width=432 style='border-collapse: collapse;table-layout:fixed;width:324pt'> <col width=72 style='width:54pt'> <col class=xl24 width=72 style='width:54pt'> <col width=72 span=4 style='width:54pt'> <tr height=19 style='height:14.25pt'> <td height=19 width=72 style='height:14.25pt;width:54pt'>问题1</td> <td class=xl24 width=72 style='width:54pt'>0001</td> <td width=72 style='width:54pt'>答案A</td> <td width=72 style='width:54pt'>答案B</td> <td width=72 style='width:54pt'>答案C</td> <td width=72 style='width:54pt'>答案D</td> </tr> <tr height=19 style='height:14.25pt'> <td height=19 style='height:14.25pt'>问题2</td> <td class=xl24>0010</td> <td>答案A</td> <td>答案B</td> <td>答案C</td> <td>答案D</td> </tr> <tr height=19 style='height:14.25pt'> <td height=19 style='height:14.25pt'>问题3</td> <td class=xl24>0100</td> <td>答案A</td> <td>答案B</td> <td>答案C</td> <td>答案D</td> </tr> <tr height=19 style='height:14.25pt'> <td height=19 style='height:14.25pt'>问题4</td> <td class=xl24>1000</td> <td>答案A</td> <td>答案B</td> <td>答案C</td> <td>答案D</td> </tr> <tr height=19 style='height:14.25pt'> <td height=19 style='height:14.25pt'>问题5</td> <td class=xl24>1000</td> <td>答案A</td> <td>答案B</td> <td>答案C</td> <td>答案D</td> </tr> <tr height=19 style='height:14.25pt'> <td height=19 style='height:14.25pt'>问题6</td> <td class=xl24>0100</td> <td>答案A</td> <td>答案B</td> <td>答案C</td> <td>答案D</td> </tr> <tr height=19 style='height:14.25pt'> <td height=19 style='height:14.25pt'>问题7</td> <td class=xl24>0010</td> <td>答案A</td> <td>答案B</td> <td>答案C</td> <td>答案D</td> </tr> <tr height=19 style='height:14.25pt'> <td height=19 style='height:14.25pt'>问题8</td> <td class=xl24>0001</td> <td>答案A</td> <td>答案B</td> <td>答案C</td> <td>答案D</td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=72 style='width:54pt'></td> <td width=72 style='width:54pt'></td> <td width=72 style='width:54pt'></td> <td width=72 style='width:54pt'></td> <td width=72 style='width:54pt'></td> <td width=72 style='width:54pt'></td> </tr> <![endif]> </table> </body> </html> |
提问者：donyad 06-04 11:11
答复