<% @?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();
%>