java中利用poi生成excel，在页面中如何使用ajax提交请求？ 如何使用Java POI生成Excel表文件
jsp\u5982\u4f55\u5229\u7528POI\u76f4\u63a5\u751f\u6210Excel\u5e76\u5728\u9875\u9762\u4e2d\u5bfc\u51fajava\u4e2d\u5bfc\u51faExcel\u6709\u4e24\u4e2a\u7ec4\u4ef6\u53ef\u4ee5\u4f7f\u7528\uff0c\u4e00\u4e2a\u662fjxl\uff0c\u4e00\u4e2a\u662fPOI\uff0c\u6211\u8fd9\u91cc\u7528\u7684\u662fPOI\u3002\u5bfc\u51fa\u662f\u53ef\u4ee5\u5728\u670d\u52a1\u5668\u4e0a\u751f\u6210\u6587\u4ef6\uff0c\u7136\u540e\u4e0b\u8f7d\uff0c\u4e5f\u53ef\u4ee5\u5229\u7528\u8f93\u51fa\u6d41\u76f4\u63a5\u5728\u7f51\u9875
\u4e2d\u5f39\u51fa\u5bf9\u8bdd\u6846\u63d0\u793a\u7528\u6237\u4fdd\u5b58\u6216\u4e0b\u8f7d\u3002\u751f\u6210\u6587\u4ef6\u7684\u65b9\u5f0f\u4f1a\u5bfc\u81f4\u670d\u52a1\u5668\u4e2d\u5b58\u5728\u7740\u5783\u573e\u6587\u4ef6\uff0c\u5b9e\u73b0\u65b9\u5f0f\u4e0d\u592a\u4f18\u96c5\uff0c\u6240\u4ee5\u8fd9\u91cc\u6211\u91c7\u7528\u7684\u662f\u540e\u9762\u76f4\u63a5\u901a\u8fc7\u8f93\u51fa\u6d41\u7684\u65b9\u5f0f\u3002
1\u3001\u4fee\u6539WEB\u670d\u52a1\u5668\u7684CONF/web.xml,\u6dfb\u52a0
xls
application/vnd.ms-excel
\u5982\u679c\u4e0d\u6dfb\u52a0\u8fd9\u4e2a\uff0c\u90a3\u4e48\u5728\u7f51\u9875\u4e2d\u4e0b\u8f7d\u7684\u65f6\u5019\u5c31\u53d8\u6210\u4e86JSP\u6587\u4ef6
2\u3001download.jsp\u6587\u4ef6
<%
response.setHeader("Content-Disposition","attachment;filename=test123.xls");//\u6307\u5b9a\u4e0b\u8f7d\u7684\u6587\u4ef6\u540d
response.setContentType("application/vnd.ms-excel");
WriteExcel we=new WriteExcel();
we.getExcel("111.xls",response.getOutputStream());
%>
\u6ce8\u610f\u4e0d\u8981\u6709html\u4ee3\u7801\uff0c\u5e76\u4e14\u9664\u4e86 \u4e2d\u95f4\u7684\u4ee3\u7801\uff0c\u5176\u5b83\u7684\u5730\u65b9\u4e0d\u8981\u6709\u7a7a\u683c\u3002\u5426\u5219\u5728\u5bfc\u51fa\u6587\u4ef6\u7684\u65f6\u5019\u4f1a\u5728\u540e\u53f0\u51fa\u73b0\u5f02\u5e38\uff0c\u867d\u7136\u4e0d\u5f71\u54cd\u7a0b\u5e8f\u7684\u4f7f\u7528\uff0c\u5230\u65f6\u4ee4\u4eba\u770b\u8d77\u6765
\u4e0d\u592a\u8212\u670d
3\u3001WriteExcel.java \u751f\u6210Excel\u7684JavaBean\uff0c\u590d\u6742\u7684\u5e94\u7528\u8bf7\u67e5\u770bAPI
package com.shangyu.action;
import java.io.*;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
public class WriteExcel
{
public void getExcel(String sheetName,OutputStream output)
{
HSSFWorkbook wb=new HSSFWorkbook();
HSSFSheet sheet1=wb.createSheet("sheet1");
HSSFRow row=sheet1.createRow((short)0);
HSSFCell cell=row.createCell((short)0);
cell.setCellValue(1);
row.createCell((short)1).setCellValue(2);
row.createCell((short)2).setCellValue(3);
row.createCell((short)3).setCellValue("\u4e2d\u6587\u5b57\u7b26");
row=sheet1.createRow((short)1);
cell=row.createCell((short)0);
cell.setCellValue(1);
row.createCell((short)1).setCellValue(2);
row.createCell((short)2).setCellValue(3);
row.createCell((short)3).setCellValue("\u4e2d\u6587\u5b57\u7b26");
//FileOutputStream fileout=new FileOutputStream("workbook.xls");
try {
output.flush();
wb.write(output);
output.close();
} catch (IOException e) {
e.printStackTrace();
System.out.println( "Output is closed ");
}
}
}
\u901a\u8fc7\u4ee5\u4e0a\u4e09\u6b65\uff0c\u5e94\u8be5\u53ef\u4ee5\u76f4\u63a5\u751f\u6210Excel\u6587\u4ef6\u4e0b\u8f7d\u6216\u4fdd\u5b58\u4e86\uff0c\u8fd9\u5728\u4e00\u4e9b\u4fe1\u606f\u7cfb\u7edf\u4e2d\u76f8\u5f53\u6709\u7528\u3002
\u672c\u6587\u6765\u81eaCSDN\u535a\u5ba2\uff0c\u8f6c\u8f7d\u8bf7\u6807\u660e\u51fa\u5904\uff1ahttp://blog.csdn.net/shangyu79/archive/2008/07/21/2682541.aspx
1234567891011121314151617181920212223242526272829 private static void WriteExcel2010() throws IOException { String path="C:\\poi2.xlsx"; XSSFWorkbook workbook=new XSSFWorkbook(); XSSFSheet sheet=workbook.createSheet("\u6211\u7684Sheet"); XSSFRow row=sheet.createRow(0); XSSFCell cell=row.createCell(0); cell.setCellValue("\u6211\u662fPOI\u5199\u5165\u7684"); XSSFRow row1=sheet.createRow(1); XSSFCell cell1=row1.createCell(0); cell1.setCellValue("2010"); FileOutputStream outputStream=new FileOutputStream(path); workbook.write(outputStream); outputStream.close(); } private static void WriteExcel2003() throws IOException { String path="C:\\poi2.xls"; HSSFWorkbook workbook=new HSSFWorkbook(); HSSFSheet sheet=workbook.createSheet("\u6211\u7684Excel"); HSSFRow row=sheet.createRow(0); HSSFCell cell=row.createCell(0); cell.setCellValue("\u6211\u662fPOI\u5199\u5165\u7684"); FileOutputStream outputStream=new FileOutputStream(path); workbook.write(outputStream); outputStream.close(); }
简单的poiEXCEL操作。部分代码。嘿嘿/**
* 创建标准模板
* @param request
* @param response
* @throws Exception
*/
private void createEXCELTemplet(HttpServletRequest request,
HttpServletResponse response) throws Exception {
HSSFWorkbook hssfworkbook = new HSSFWorkbook();
HSSFSheet hssfsheet = hssfworkbook.createSheet();
String downloadFileName = sellActivityTitle;
createSheetTableTile(hssfsheet,ExcelConstantTitle.sellActivityTitleMap,TEMPLET_CELL_COUNT);
downloadEXCEL(hssfworkbook, downloadFileName, request, response);
}
/**
* 提供下载
* @param hssfworkbook
* @param downloadFileName
* @param request
* @param response
* @throws Exception
*/
private void downloadEXCEL(HSSFWorkbook hssfworkbook,
String downloadFileName, HttpServletRequest request,
HttpServletResponse response) throws Exception {
try {
//设置response,下载附件头设置
response.setContentType("application/vnd.ms-excel");
response.setHeader("content-disposition",
"attachment;filename=\""
+ new String(downloadFileName.getBytes("GBK"),
"ISO-8859-1") + "\";size="
+ hssfworkbook.getBytes().length);
OutputStream out = response.getOutputStream();
//将工作簿输出到response
hssfworkbook.write(out);
out.flush();
out.close();
} catch (Exception e) {
throw new Exception(e);
}
}
/**
* 创建校验数据之后的模板
*/
private void createValidateExcelAfterTemplet(HttpServletRequest request,
HttpServletResponse response,List list) throws Exception {
HSSFWorkbook hssfworkbook = new HSSFWorkbook();
HSSFSheet hssfsheet = hssfworkbook.createSheet();
// 创建正文
String downloadFileName = validateSellActivityAfterTitle;
createSheetTableTile(hssfsheet,ExcelConstantTitle.sellActivityTitleMap,VALIDATE_AFTER_CELL_COUNT);
//添加数据
addSheetContentList(hssfsheet,ExcelConstantTitle.sellActivityContentMap,list);
downloadEXCEL(hssfworkbook, downloadFileName, request, response);
}
/**
* 创建EXCEL表头
* @param hssfsheet
* @param titleMap
* @param size
* @return
*/
private HSSFSheet createSheetTableTile(HSSFSheet hssfsheet,Map titleMap,int size){
// 创建正文
HSSFRow hssfrow = hssfsheet.createRow(0);
for (int i = 0; i < size; i++) {
// 设置列宽度
hssfsheet.setColumnWidth((short) i, (short) 4000);
HSSFCell hssfcell = hssfrow.createCell((short) i);
hssfcell.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
switch (i) {
case 0:
hssfcell.setCellValue((String)titleMap.get(String.valueOf(i)));
break;
case 1:
hssfcell.setCellValue((String)titleMap.get(String.valueOf(i)));
break;
case 2:
hssfcell.setCellValue((String)titleMap.get(String.valueOf(i)));
break;
case 3:
hssfcell.setCellValue((String)titleMap.get(String.valueOf(i)));
break;
case 4:
hssfcell.setCellValue((String)titleMap.get(String.valueOf(i)));
break;
case 5:
hssfcell.setCellValue((String)titleMap.get(String.valueOf(i)));
break;
case 6:
hssfcell.setCellValue((String)titleMap.get(String.valueOf(i)));
break;
}
}
return hssfsheet;
}
/**
* 添加excel正文数据
*/
private HSSFSheet addSheetContentList(HSSFSheet hssfsheet,Map contentMap,List contentList){
for(int k = 0;k < contentList.size();k++){
HSSFRow hssfrow = hssfsheet.createRow(k+1);
for (int i = 0; i < VALIDATE_AFTER_CELL_COUNT; i++) {
Map map = (Map) contentList.get(k);
HSSFCell hssfcell = hssfrow.createCell((short) i);
hssfcell.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
switch (i) {
case 0:
hssfcell.setCellValue((String)map.get(contentMap.get(String.valueOf(i))));
break;
case 1:
hssfcell.setCellValue((String)map.get(contentMap.get(String.valueOf(i))));
break;
case 2:
hssfcell.setCellValue((String)map.get(contentMap.get(String.valueOf(i))));
break;
case 3:
hssfcell.setCellValue((String)map.get(contentMap.get(String.valueOf(i))));
break;
case 4:
hssfcell.setCellValue((String)map.get(contentMap.get(String.valueOf(i))));
break;
case 5:
hssfcell.setCellValue((String)map.get(contentMap.get(String.valueOf(i))));
break;
case 6:
hssfcell.setCellValue((String)map.get(contentMap.get(String.valueOf(i))));
break;
}
}
}
return hssfsheet;
}
吧不知道能不能帮你，我也不动感我在csdn看看的。实在不行你在那问问。。。。。。。。。。。。。
绛旓細import java.lang.reflect.Method;import java.text.SimpleDateFormat;import java.util.Date;import java.util.List;import org.apache.log4j.Logger;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.hssf.usermodel.HSSFRichTextString;import ...
绛旓細2007鐗堟湰鐨闇瑕浣跨敤XSSFWorkbook鏉ュ鐞,濡傛灉涓嶇‘瀹氳鍙栫殑excel鐗堟湰鐨勮瘽鍙互鍐欑殑if鍒ゆ柇涓嬪鏋滃悗缂涓".xls"鍒涘缓HSSFWorkbook 鍚﹀垯鍒涘缓 XSSFWorkbook鏉ュ鏂囦欢杩涜鎿嶄綔鍗冲彲.Workbook excelWB = null;Sheet oneSheet = null;Row oneRow = null;Cell oneCell = null;...if("xls".equals(excFilSuff)){ exce...
绛旓細璇诲彇excel鏂囦欢涓棩鏈熷唴瀹规槸閫氳繃poi鑾峰彇鐨,浠ｇ爜濡備笅:HSSFWorkbook excbook = new HSSFWorkbook(ExcFile);//鑾峰彇绗竴涓猻heet椤 HSSFSheet excSheet = excbook.getSheetAt(0);//鑾峰彇绗竴琛孒SSFRow oneRow = excSheet.getRow(0);//鑾峰彇绗竴琛岀殑绗竴涓〃鏍 HSSFCell oneCell = oneRow.getCell(0)...
