jxl caozuo execl_54cao-CSDN博客

本文链接：https://blog.csdn.net/epng54/article/details/2234571

<%@ page contentType="text/html; charset=big5" language="java" import="java.sql.*" %>
<%@ page import="jxl.*"%>
<%@ page import="jxl.write.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>

try{
WritableWorkbook workbook = Workbook.createWorkbook(new File(request.getRealPath("/")+"mis/"+"/企業信息.xls"));
WritableSheet sheet=workbook.createSheet("企業信息",0);

Label label=new Label(0,0,"test");
sheet.addCell(label);

jxl.write.Number number = new jxl.write.Number(1,0,789.123);
sheet.addCell(number);

Label label2=new Label(2,0,"afdafafdsatest");
sheet.addCell(label2);

Label label3=new Label(2,2,"afdafafdsatest");
sheet.addCell(label3);

workbook.write();
workbook.close();
}
catch (Exception e)
{
e.printStackTrace();
}
%>

<html>
<head>
<title>操作Excel表</title>

</head>

<body>
<table width="653" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td height="46"><div align="center"><a href="e.jsp">xiazai</a></div></td>
</tr>
<tr>
<td><br></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</body>
</html>

<%@ page contentType="text/html; charset=big5" language="java" import="java.sql.*" %>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%
try{
String path = request.getRealPath("");
path=path+"/mis/";
byte b[]=new byte[1000];
String name="企業信息.xls";
File fileLoad=new File(path,name);
response.setHeader("Content-Disposition", "attachment; filename=" + new String(name.getBytes("big5"), "iso-8859-1"));
response.setContentType("application/x-tar");
long fileLength=fileLoad.length();
String length=String.valueOf(fileLength);
response.setHeader("Content_length",length);
FileInputStream in=new FileInputStream(fileLoad);
int n=0;
OutputStream os=response.getOutputStream();
while((n=in.read(b))!=-1)
{
os.write(b,0,n);
}
in.close();
os.flush();
os.close();
}
catch (Exception e)
{
e.printStackTrace();
}
%>