<%
@ page language
=
"
java
"
contentType
=
"
text/html;charset=gb2312
"
%>
<% @ page language = " java "
import = " java.util.*,org.apache.poi.hssf.usermodel.HSSFWorkbook,org.apache.poi.hssf.usermodel.HSSFSheet,org.apache.poi.hssf.usermodel.HSSFRow,org.apache.poi.hssf.usermodel.HSSFCell " %>
<%
response.setContentType( " APPLICATION/OCTET-STREAM " );
response.setHeader( " Content-Disposition " ,
" attachment; filename=/ " test.xls " +
" / "" );
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet( " sheet1 " );
// 以下以写表头
// 表头为第一行
HSSFRow row = sheet.createRow(( short ) 0 );
HSSFCell cell1 = row.createCell(( short ) 0 );
HSSFCell cell2 = row.createCell(( short ) 1 );
HSSFCell cell3 = row.createCell(( short ) 2 );
cell1.setEncoding(( short ) 1 );
cell1.setCellType( 1 );
cell2.setEncoding(( short ) 1 );
cell2.setCellType( 1 );
cell3.setEncoding(( short ) 1 );
cell3.setCellType( 1 );
// 定义表头的内容
cell1.setCellValue( " 测试 " );
cell2.setCellValue( " 测试2 " );
cell3.setCellValue( " 测试3 " );
for ( int i = 0 ; i < 4 ; i ++ ) {
// 定义数据从第二行开始
row = sheet.createRow(( short ) i + 1 );
cell1 = row.createCell(( short ) 0 );
cell2 = row.createCell(( short ) 1 );
cell3 = row.createCell(( short ) 2 );
cell1.setEncoding(( short ) 1 );
cell1.setCellType( 1 );
cell2.setEncoding(( short ) 1 );
cell2.setCellType( 1 );
cell3.setEncoding(( short ) 1 );
cell3.setCellType( 1 );
// 填充内容
cell1.setCellValue( " ggg " );
cell2.setCellValue( " 00000 " );
cell3.setCellValue( " adfasdf " );
}
wb.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
%>
<% @ page language = " java "
import = " java.util.*,org.apache.poi.hssf.usermodel.HSSFWorkbook,org.apache.poi.hssf.usermodel.HSSFSheet,org.apache.poi.hssf.usermodel.HSSFRow,org.apache.poi.hssf.usermodel.HSSFCell " %>
<%
response.setContentType( " APPLICATION/OCTET-STREAM " );
response.setHeader( " Content-Disposition " ,
" attachment; filename=/ " test.xls " +
" / "" );
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet( " sheet1 " );
// 以下以写表头
// 表头为第一行
HSSFRow row = sheet.createRow(( short ) 0 );
HSSFCell cell1 = row.createCell(( short ) 0 );
HSSFCell cell2 = row.createCell(( short ) 1 );
HSSFCell cell3 = row.createCell(( short ) 2 );
cell1.setEncoding(( short ) 1 );
cell1.setCellType( 1 );
cell2.setEncoding(( short ) 1 );
cell2.setCellType( 1 );
cell3.setEncoding(( short ) 1 );
cell3.setCellType( 1 );
// 定义表头的内容
cell1.setCellValue( " 测试 " );
cell2.setCellValue( " 测试2 " );
cell3.setCellValue( " 测试3 " );
for ( int i = 0 ; i < 4 ; i ++ ) {
// 定义数据从第二行开始
row = sheet.createRow(( short ) i + 1 );
cell1 = row.createCell(( short ) 0 );
cell2 = row.createCell(( short ) 1 );
cell3 = row.createCell(( short ) 2 );
cell1.setEncoding(( short ) 1 );
cell1.setCellType( 1 );
cell2.setEncoding(( short ) 1 );
cell2.setCellType( 1 );
cell3.setEncoding(( short ) 1 );
cell3.setCellType( 1 );
// 填充内容
cell1.setCellValue( " ggg " );
cell2.setCellValue( " 00000 " );
cell3.setCellValue( " adfasdf " );
}
wb.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
%>