并不是很完整,仅供参考,项目中写过,但是没有仔细研究过,今天拿出来学习下
package com.example.excelupload.commons;
import com.sun.deploy.net.HttpResponse;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.util.CellRangeAddress;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.util.ArrayList;
import java.util.List;
public class ExcelExport {
public void downloadExcel(HttpServletResponse response) throws IOException {
//创建HSSFWorkbook对象(Excel的文档对象)
HSSFWorkbook wb = new HSSFWorkbook();
//建立新的sheet对象(Excel的表单)
HSSFSheet sheet = wb.createSheet("成绩表");
//在sheet里创建第一行,参数为行索引(Excel的行),可以是0-65535之间的任何一个
HSSFRow row1 = sheet.createRow(0);
//创建单元格(Excel的单元格)参数为列索引,可以是0-255之间的任何一个
HSSFCell cell = row1.createCell(0);
//设置单元格内容
cell.setCellValue("学员考试成绩一览表");
//合并单元格CellRangeAddress构造参数一次表示起始行,截止行,起始列,截止列
sheet.addMergedRegion(new CellRangeAddress(0,0,0,3));
//sheet里创建第二行
HSSFRow row2 = sheet.createRow(1);
//创建单元格并设置单元格内容
row2.createCell(0).setCellValue("姓名");
row2.createCell(1).setCellValue("班级");
row2.createCell(2).setCellValue("笔试成绩");
row2.createCell(3).setCellValue("机试成绩");
List<String> list = new ArrayList<String>();
for(int i=2;i<list.size();i++){
HSSFRow row = sheet.createRow(i);
row.createCell(0).setCellValue(list.get(i));
row.createCell(1).setCellValue(list.get(i));
}
String fileName = "Excel-"+String.valueOf(System.currentTimeMillis()).substring(4,13)+".xls";
String headStr = "attachment;fileName=\""+fileName+"\"";
response.reset();
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition",headStr);
OutputStream out = response.getOutputStream();
wb.write(out);
out.close();
}
/**
* 文件名乱码
* @param s
* @return
*/
public static String toUtf8String(String s){
StringBuffer sb = new StringBuffer();
for(int i=0;i<s.length();i++){
char c = s.charAt(i);
if(c>=0 && c<=255){
sb.append(c);
}else{
byte[] b;
try {
b = Character.toString(c).getBytes("utf-8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
b = new byte[0];
}
for(int j=0;j<b.length;j++){
int k = b[j];
if(k<0){
k+=256;
sb.append("%"+Integer.toHexString(k).toUpperCase());
}
}
}
}
return sb.toString();
}
}