excel mine

最新推荐文章于 2021-03-22 03:53:02 发布

Bruce54

最新推荐文章于 2021-03-22 03:53:02 发布

阅读量684

点赞数

文章标签： excel import exception string file path

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

版权

<%@ 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>

String rootPath=getServletContext().getRealPath("/");

jxl.Workbook rw = jxl.Workbook.getWorkbook(new File(rootPath+"//aa.xls"));
Sheet rs = rw.getSheet(0);

jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(rootPath+"//aa1.xls"), rw);

jxl.write.WritableSheet ws = wwb.getSheet(0);

jxl.write.WritableFont wfc=new jxl.write.WritableFont(WritableFont.ARIAL,20,WritableFont.BOLD,false, xl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.GREEN);
jxl.write.WritableCellFormat wcfFC=new jxl.write.WritableCellFormat(wfc);
wcfFC.setBackground(jxl.format.Colour.BLUE);
jxl.write.WritableCell wc = ws.getWritableCell(0, 2);

Label label=new Label(5,5,"气喘吁吁",wcfFC);
ws.addCell(label);

ws.mergeCells(16,16,19,21);

jxl.write.WritableImage   wi=new   jxl.write.WritableImage(7,7,3,3,new   File(rootPath+"//cc.png"));
ws.addImage(wi);

wwb.write();

wwb.close();

rw.close();

%>

<%@ 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();
}
%>