asp 怎么把选中的数据导出到Excel表格中?

asp 怎么把选中的数据导出到Excel表格中?,第1张

提交用户选中的简历ID,进入下面这个页面,根据简历ID号查询数据库

顶部加入ResponseContentType = "application/vndms-excel" 这行代码,指明这是excel文件

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 401 Transitional//EN">

<%

ResponseBuffer = True

ResponseContentType = "application/vndms-excel"

ResponseAddHeader "content-disposition", "inline; filename = ASP_Excelxls"

%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title>Untitled Document</title>

</head>

<body>

<p>asgagsah</p>

<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">

<tr>

<td width="30%" bgcolor="#CCCCCC">sdafsagsgdsgds</td>

<td bgcolor="#FFFFFF">sdafsagsgdsgdssdafsagsgdsgdssdafsagsgdsgdssdafsagsgdsg<br>

dssdafsagsgdsgdssdafsagsgdsgdssdafsagsgdsgdssdafsagsgdsgdssdafsagsgdsgds</td>

</tr>

<tr>

<td width="30%" bgcolor="#CCCCCC">sdgdsagdsgdsgsd</td>

<td bgcolor="#FFFFFF">sdafsagsgdsgds</td>

</tr>

<tr>

<td width="30%" bgcolor="#CCCCCC"> </td>

<td bgcolor="#FFFFFF"> </td>

</tr>

<tr>

<td width="30%" bgcolor="#CCCCCC">sdgdssdgdsdsg</td>

<td bgcolor="#FFFFFF">sfsafsddsgsd</td>

</tr>

</table>

<p>fsddssadgsa<img src="joyren/images/ADDJPG" width="12" height="24">dgsdgds<img src="joyren/images/back_greenjpg" width="842" height="50"></p>

<table width="70%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">

<tr>

<td bgcolor="#CCCCCC">sfsadfsadfdsag</td>

<td bgcolor="#FFFFFF"> </td>

</tr>

<tr>

<td bgcolor="#CCCCCC">gasdgsdagsgs</td>

<td bgcolor="#FFFFFF"> </td>

</tr>

<tr>

<td bgcolor="#CCCCCC">sdgsddsgsgs</td>

<td bgcolor="#FFFFFF"> </td>

</tr>

<tr>

<td bgcolor="#CCCCCC">sdgsdgdsgsgsgdsadgsagsd</td>

<td bgcolor="#FFFFFF"> </td>

</tr>

</table>

<p> </p>

<p>sdsaddsagsddsgds</p>

</body>

</html>

我想用VC做一个C/S结构的工具,要求是带注册功能,也就是用户需要注册才可以使用。

请问各位大师,这个项目可行吗?除了VC,我还需要掌握哪方面的知识?比如注册时需要个加密知识,不知道是否需要,谢谢大家参与!

在你显示记录集的页面前面加上:

<%

nowfilename=replace(replace(replace(now,":","")," ",""),"/","")

ResponseBuffer = True

ResponseContentType = "application/vndms-excel"

ResponseAddHeader "content-disposition", "inline; filename = "&nowfilename&"xls"

%>

欢迎分享,转载请注明来源:内存溢出

原文地址: https://outofmemory.cn/bake/11680926.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-05-17
下一篇 2023-05-17

发表评论

登录后才能评论

评论列表(0条)

保存