????JAVA EXCEL API:????????????????????Java?????????????Excel???????????????μ?Excel?????????????????Excel?????????API??Windows????????????????Java?????????Excel????????????????Java??д?????????????Web????п??????JSP??Servlet??????API????Excel??????????
?????????
??????????http://www.andykhan.com/jexcelapi/?????°汾???????μ???jexcelapi_2_6_12.tar.gz????????????jxl.jar?????WEB-INF/lib?????漴???
????Java Excel API??jar?????????????URL????
????http://sourceforge.net/projects/jexcelapi/files/jexcelapi/2.6.6/jexcelapi_2_6_6.zip/download
?????????????а汾????http://sourceforge.net/projects/jexcelapi/files/
????????????????????????????????
????http://nchc.dl.sourceforge.net/project/jexcelapi/jexcelapi/2.6.6/jexcelapi_2_6_6.zip
???????JSP???????Excel???
????package beans.excel;
????import java.io.IOException;
????import java.io.OutputStream;
????import jxl.Workbook;
????import jxl.write.Label;
????import jxl.write.WritableSheet;
????import jxl.write.WritableWorkbook;
????import jxl.write.WriteException;
????public class SimpleExcelWrite {
????public void createExcel(OutputStream os) throws WriteException??IOException{
????//??????????
????WritableWorkbook workbook = Workbook.createWorkbook(os);
????//?????μ???
????WritableSheet sheet = workbook.createSheet("First Sheet"??0);
????//??????????????????????????????????????????????????????????????????????????
????Label xuexiao = new Label(0??0??"?У");
????sheet.addCell(xuexiao);
????Label zhuanye = new Label(1??0??"??");
????sheet.addCell(zhuanye);
????Label jingzhengli = new Label(2??0??"????????");
????sheet.addCell(jingzhengli);
????Label qinghua = new Label(0??1??"?廩???");
????sheet.addCell(qinghua);
????Label jisuanji = new Label(1??1??"???????");
????sheet.addCell(jisuanji);
????Label gao = new Label(2??1??"??");
????sheet.addCell(gao);
????Label beida = new Label(0??2??"???????");
????sheet.addCell(beida);
????Label falv = new Label(1??2??"??????");
????sheet.addCell(falv);
????Label zhong = new Label(2??2??"??");
????sheet.addCell(zhong);
????Label ligong = new Label(0??3??"??????????");
????sheet.addCell(ligong);
????Label hangkong = new Label(1??3??"??????");
????sheet.addCell(hangkong);
????Label di = new Label(2??3??"??");
????sheet.addCell(di);
????//???????????д????????У???????????
????workbook.write();
????workbook.close();
????os.close();
????}
????}
????SimpleExcelWrite.jsp
????<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
????<%@ page import="java.io.*" %>
????<%@ page import="beans.excel.*" %>
????<%
????String fname = "?У?????????";
????OutputStream os = response.getOutputStream();//????????
????response.reset();//????????
????//?????????????????????
????response.setCharacterEncoding("UTF-8");//?????????????????
????fname = java.net.URLEncoder.encode(fname??"UTF-8");
????response.setHeader("Content-Disposition"??"attachment;filename="+new String(fname.getBytes("UTF-8")??"GBK")+".xls");
????response.setContentType("application/msexcel");//???????????
????SimpleExcelWrite sw = new SimpleExcelWrite();
????sw.createExcel(os);
????%>
????<html>
????<head>
????<title></title>
????</head>
????<body>
????</body>
????</html>