不懂java
不过估计原理是差不多的1 设置输出类型格式
如asp
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition", "attachment;filename=Excel.xls"
'这些用于说明输出一个excel格式的名为Excel.xls的文件2 设置输出内容
'以下是输出内容,用chr(9)分隔字段,用vbcrlf分隔记录response.Write "题目"&chr(9)&"内容"&vbcrlf
response.Write "excel"&chr(9)&"输出excel文件"&vbcrlf
不过估计原理是差不多的1 设置输出类型格式
如asp
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition", "attachment;filename=Excel.xls"
'这些用于说明输出一个excel格式的名为Excel.xls的文件2 设置输出内容
'以下是输出内容,用chr(9)分隔字段,用vbcrlf分隔记录response.Write "题目"&chr(9)&"内容"&vbcrlf
response.Write "excel"&chr(9)&"输出excel文件"&vbcrlf
也可以通过在页面上配置excel application对象,将指定的结果table,写出来到excel
发段代码给小弟 看看,谢谢啦!!
具体用法网上很多,也很简单~
<%
response.setBufferSize(0);
response.setContentType("application/vnd.ms-excel");
response.addHeader("content-disposition", "attachment;filename=Excel.xls");
%>
<table width="200" border="1">
<tr>
<td>11</td>
<td>22</td>
<td>33</td>
<td>44</td>
</tr>
<tr>
<td>55</td>
<td>66</td>
<td>77</td>
<td>88</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
Response.Buffer= true;
Response.AppendHeader("Content-Disposition","attachment;filename="+DateTime.Now.ToString("yyyyMMdd")+".xls");
Response.ContentEncoding=System.Text.Encoding.UTF8;
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false; 这里我们利用了ContentType属性,它默认的属性为text/html,这时将输出为超文本,即我们常见的网页格式到客户端,如果改为ms-excel将将输出excel格式,也就是说以电子表格的格式输出到客户端,这时浏览器将提示你下载保存。ContentType的属性还包括:image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword 。同理,我们也可以输出(导出)图片、word文档等。下面的方法,也均用了这个属性。
2. 用response将xml文件推送到用户端;主要是xml文件的格式问题,有点复杂,你若需要可以留个邮箱,发给你。
我是用JAVA写的,把代码发出来,让大家看看,指点下!!在此先谢谢啦!!
1、将查询结果在客户端用 <table> 表格形式显示出来。下面是 Servlet代码:
package mod;import java.io.IOException;
import java.io.PrintWriter;
import java.util.Iterator;
import java.util.Set;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import bean.OutScan;
import dao.CustomerDAO;
import daofactory.DaoFactory;public class SelectOtime extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = -5859092802494322046L;
/**
* Constructor of the object.
*/
public SelectOtime() {
super();
} /**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doDelete method of the servlet. <br>
*
* This method is called when a HTTP delete request is received.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doDelete(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException { // Put your code here
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { response.setContentType("text/html;charset=GBK");
PrintWriter out = response.getWriter();
request.setCharacterEncoding("GBK");
DaoFactory cloudscapeFactory =
DaoFactory.getDaoFactory(DaoFactory.mssql); CustomerDAO custDAO =
cloudscapeFactory.getCustomerDAO();
Set set=null;
OutScan outScan=null;
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><title>IPTV出货管理系统</title><link rel='stylesheet' type='text/css' rel='stylesheet' href='son.css'/></HEAD>");
out.println("<body link='#000066' vlink='#0066FF' alink='#99FF00'>");
String o_time= request.getParameter("o_time");//取值
set=custDAO.selectOtime(o_time);
Iterator it = set.iterator();
out.println("<center><h1 class='pp'><span class='9P'>出货时间:"+o_time+"</span></h1><hr>");
out.print("<form name='form1' action='/IPTV/ExportTime' method='post'>");
out.println("<table width='90%' border='1' bordercolor='ccccff' class='pp'>");
out.println("<tr><td width='100' align='center'>出货时间</td>"
+ "<td width='100' align='center'>序号</td>"
+ "<td width='100' align='center'>出货单号</td>"
+ "<td width='100' align='center'>出货人</td>"
+ "<td width='100' align='center'>包装箱序列号</td>"
+ "<td width='100' align='center'>产品序列号</td></tr> ");
while (it.hasNext()) {
outScan = (OutScan) it.next();
out.println("<tr><input type='hidden' name='o_time' value='"+ outScan.getO_time()+"'><td width='100' align='center'>"
+ outScan.getO_time()
+ "</a></td>"
+ "<td width='100' align='center'>"
+ outScan.getO_id()
+ "</td>"
+ "<td width='100' align='center'>"
+ outScan.getO_po()
+ "</td>"
+ "<td width='100' align='center'>"
+ outScan.getO_people()
+ "</td>"
+ "<td width='100' align='center'>"
+ outScan.getO_cartowtd()
+ "</td>"
+ "<td width='100' align='center'>"
+ outScan.getO_no()
+ "</td></tr>");
request.getSession().setAttribute("id",outScan.getO_time());
}
out.println("<tr><td class='9P'>导出生成Execl表格:</td><td><input type='submit' value='导出'></td></tr>");
out.println("</table></form>");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
}
}
///////////////////////////////////////////JAVA代码如上,不知道怎么将页面表格导出生成execl表格。我新建了个 ExportTime.java (Servlet)
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("application/vnd.ms-execl charset=GBK");
PrintWriter out=response.getWriter();
out.println("bfffff\t序号\\f出货单号\'出货人'\t包装箱序列号\t产品序列号");
request.setCharacterEncoding("GBK");
DaoFactory cloudscapeFactory =
DaoFactory.getDaoFactory(DaoFactory.mssql); CustomerDAO custDAO =
cloudscapeFactory.getCustomerDAO();
Set set=null;
OutScan outScan=null;
String o_time= request.getParameter("o_time");//取值
set=custDAO.selectOtime(o_time);
Iterator it = set.iterator();
...............各位大哥大姐帮忙看看,能给出详细代码的是最好了,偶是新手,好多问题都不知道,大家别笑话~~