contentType="application/vnd.ms-excel;charset=utf-8"
pageEncoding="utf-8"
%>
//导入要用的包
import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
import="java.io.FileOutputStream"%>
import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
import="java.util.Vector"%>
import="org.apache.poi.hssf.usermodel.HSSFRow"%>
import="java.io.FileNotFoundException"%>
import="java.io.IOException"%>
import="org.apache.poi.hssf.util.Region"%>
import="org.apache.poi.hssf.usermodel.HSSFCell"%>
%>
HSSFWorkbook wb = new HSSFWorkbook();
try {
HSSFSheet sheet1 =
wb.createSheet("名字");
org.apache.poi.hssf.usermodel.HSSFSheet
sheet = wb.getSheetAt(0);
…………//构建Excel
//写入到本地
wb.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
out.clear();
out = pageContext.pushBody();
}catch(IOException e){
e.printStackTrace();
}
%>