在ASP中如何将ACCESS转换成EXCEL

本人是asp+access 做了个查询.现在要把查询到的数据转为EXCEL谁有这方面的代码.!!或实例!!

第1个回答  2013-11-06
直接将含有表格的HTM后缀名改为XLS,用EXCEL打开就成了EXCEL表格。例如:AA.XLS,,用EXCEL打开效果如下:而文件实际文本内容为:<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel">
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<!--[if gte mso 9]><xml><o:DocumentProperties>
<o:Author>心跳</o:Author>
<o:Company>角落电脑工作室</o:Company>
</o:DocumentProperties></xml><![endif]-->
<style>
<!--table@page {mso-page-orientation:landscape;}
tr {mso-height-source:auto;mso-ruby-visibility:none;}
col {mso-width-source:auto;mso-ruby-visibility:none;}
br {mso-data-placement:same-cell;}
td {font-size:12pt;padding-top:1px;padding-right:1px;padding-left:1px;mso-ignore:padding;font-weight:400;vertical-align:middle;text-align:center;}
._LT{font-size:12pt;border-top:1.5pt solid;border-right:.5pt solid;border-bottom:.5pt solid;border-left:1.5pt solid;}
._T{font-size:12pt;border-top:1.5pt solid;border-right:.5pt solid;border-bottom:.5pt solid;}
._RT{font-size:12pt;border-top:1.5pt solid;border-right:1.5pt solid;border-bottom:.5pt solid;}
._L{font-size:12pt;border-right:.5pt solid;border-bottom:.5pt solid;border-left:1.5pt solid;}
._C{font-size:12pt;border-right:.5pt solid;border-bottom:.5pt solid;}
._R{font-size:12pt;border-right:1.5pt solid;border-bottom:.5pt solid;}
._LB{font-size:12pt;border-right:.5pt solid;border-bottom:1.5pt solid;border-left:1.5pt solid;}
._B{font-size:12pt;border-right:.5pt solid;border-bottom:1.5pt solid;}
._RB{font-size:12pt;border-right:1.5pt solid;border-bottom:1.5pt solid;}
ruby{ruby-align:center;}
rt{font-size:12pt;font-weight:400;}-->
</style>
<!--[if gte mso 9]>
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>导出数据</x:Name>
<x:WorksheetOptions>
<x:DefaultRowHeight>285</x:DefaultRowHeight>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>180</x:HorizontalResolution>
<x:VerticalResolution>180</x:VerticalResolution>
<x:NumberofCopies>0</x:NumberofCopies>
</x:Print>
<x:Selected/><x:Panes><x:Pane><x:Number>3</x:Number><x:ActiveRow>1</x:ActiveRow><x:ActiveCol>0</x:ActiveCol></x:Pane></x:Panes><x:ProtectContents>False</x:ProtectContents><x:ProtectObjects>False</x:ProtectObjects><x:ProtectScenarios>False</x:ProtectScenarios></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets><x:WindowHeight>6930</x:WindowHeight><x:WindowWidth>11670</x:WindowWidth><x:WindowTopX>120</x:WindowTopX><x:WindowTopY>15</x:WindowTopY><x:ProtectStructure>False</x:ProtectStructure><x:ProtectWindows>False</x:ProtectWindows></x:ExcelWorkbook>
<x:ExcelName>
<x:Name>Print_Titles</x:Name>
<x:SheetIndex>1</x:SheetIndex>
<x:Formula>导出数据</x:Formula></x:ExcelName>
</xml>
<![endif]-->
</head>
<body>
<table x:num><tr><td colspan=6 style='text-align:center;font-size:24pt;'>201001工资构成明细表</td></tr><tr><td class=_LT>项目</td><td class=_T>合计</td><td class=_T>在岗职工工资</td><td class=_T>退养职工工资(80%)</td><td class=_T>备注</td><td class=_RT>本月变动说明</td></tr>
<tr><td class=_L>一、职工人数</td><td class=_C>50</td><td class=_C>49</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L>二、工资总额合计</td><td class=_C>153607.48</td><td class=_C>150842.48</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L>其中:1. 岗位(技能)工资</td><td class=_C>101810</td><td class=_C>99150</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 2. 保留工资</td><td class=_C>0</td><td class=_C>0</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 3. 工龄工资</td><td class=_C>0</td><td class=_C>0</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 4. 三费</td><td class=_C>4550</td><td class=_C>4445</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 5. 生产上岗津贴</td><td class=_C>1190</td><td class=_C>1190</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> (1)技师津贴</td><td class=_C>0</td><td class=_C>0</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> (2)护教贴</td><td class=_C>1190</td><td class=_C>1190</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 6. 加班</td><td class=_C>2628.98</td><td class=_C>2628.98</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 7. 夜班</td><td class=_C>240</td><td class=_C>240</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 8. 生产奖</td><td class=_C></td><td class=_C></td><td class=_C></td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 9. 单项奖</td><td class=_C></td><td class=_C></td><td class=_C></td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_L> 10.其他加1(车贴)</td><td class=_C>652.5</td><td class=_C>652.5</td><td class=_C>0</td><td class=_C></td><td class=_R></td></tr>
<tr><td class=_LB> 11.其他加2</td><td class=_B>42536</td><td class=_B>42536</td><td class=_B>0</td><td class=_B></td><td class=_RB></td></tr>
</table></body></html>
相似回答