當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

将数据到处到Excel

發布時間：2025/3/20 编程问答 13 豆豆

生活随笔收集整理的這篇文章主要介紹了将数据到处到Excel 小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

使用開源的POI組件，包含實現對Excal文件的創建和寫入操作的類，使POI組件操作EXCEL文件的步驟

創建Excel的工作表，POI組件的HSSFWorkbook類提供了創建工作表的方法 public HSSFSheet
createSheet(String sheetname) //參數sheetname表示工作表的名稱

創建表格的行，在保存之前創建行對象，該對象由工作表對象創建 public HSSFRow createRow(int
rownum) //參數rownum表示工作表中行對象的行號

創建表格的單元格，由HSSFRow類的createRow()方法創建 public HSSFCell createCell(int
columnIndex) //參數columnIndex表示單元格對象的列編號

寫入單元格內容，常用的是String類型的字符串數據 public void setCellValue(String value)

index.jsp頁面

<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>

<title>用戶注冊</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><style type="text/css">table{font-size:12px;font-family: 隸書;color:gray;border: 1px green solid;}input{font-size:12px;font-family: 隸書;color:gray;}</style></head><body><form action="export" method="post"><table align="center"><tr><td>用戶名：</td><td><input type="text" name="name" /></td></tr><tr><td>密碼：</td><td><input type="password" name="pwd" /></td></tr><tr><td>性別：</td><td><input type="radio" name="sex" value="男" />男<input type="radio" name="sex" value="女" />女</td></tr><tr><td>年齡：</td><td><input type="text" name="age" /></td></tr><tr><td>Email：</td><td><input type="text" name="email" /></td></tr><tr><td colspan="2" align="center"><input type="submit" value="導出到Excel" /></td></tr></table></form></body> </html>

ExportServlet的Servlet類，doPost方法獲得信息，POI組件將信息導出到POI組件

public class ExportServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setCharacterEncoding("UTF-8");response.setContentType("application/vnd.ms-excel");//設置響應正文的MIME類型，該類型表示Excel//response.addHeader("Content-Disposition", "attachment;filename=logininfo.xls");String name = request.getParameter("name");String pwd =request.getParameter("pwd");String sex = request.getParameter("sex");String age = request.getParameter("age");String email = request.getParameter("email");ServletOutputStream out = response.getOutputStream();//響應輸出流對象HSSFWorkbook wb = new HSSFWorkbook(); //創建Excel表格HSSFSheet sheet = wb.createSheet("用戶注冊信息"); //創建工作簿sheet.setColumnWidth(4, 5000); //設置列寬HSSFRow titleRow = sheet.createRow(0); //創建Excel中的標題行HSSFCell titleCell1 =titleRow .createCell(0); //在行中創建第1個單元格titleCell1.setCellValue("用戶姓名"); //設置第1個單元格的值HSSFCell titleCell2= titleRow.createCell(1); //在行中創建第2個單元格titleCell2.setCellValue("密碼"); //設置第2個單元格的值HSSFCell titleCell3 =titleRow .createCell(2); //在行中創建第3個單元格titleCell3.setCellValue("性別"); //設置第3個單元格的值HSSFCell titleCell4= titleRow.createCell(3); //在行中創建第4個單元格titleCell4.setCellValue("年齡"); //設置第4個單元格的值HSSFCell titleCell5= titleRow.createCell(4); //在行中創建第5個單元格titleCell5.setCellValue("Email"); //設置第5個單元格的值HSSFRow valueRow = sheet.createRow(1); //創建第2行HSSFCell nameCell = valueRow.createCell(0); //在第2行中創建單元格nameCell.setCellValue(name);HSSFCell pwdCell = valueRow.createCell(1);pwdCell.setCellValue(pwd);HSSFCell sexCell = valueRow.createCell(2);sexCell.setCellValue(sex);HSSFCell ageCell = valueRow.createCell(3);ageCell.setCellValue(age);HSSFCell emailCell = valueRow.createCell(4);emailCell.setCellValue(email);HSSFCellStyle cellStyle = wb.createCellStyle();wb.write(out); //將響應流輸入到Excel表格中out.flush();out.close();}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}

web.xml文件配置

<servlet><description>This is the description of my J2EE component</description><display-name>This is the display name of my J2EE component</display-name><servlet-name>ExportServlet</servlet-name><servlet-class>com.lh.servlet.ExportServlet</servlet-class></servlet><servlet-mapping><servlet-name>ExportServlet</servlet-name><url-pattern>/export</url-pattern></servlet-mapping><welcome-file-list><welcome-file>index.jsp</welcome-file></welcome-file-list>

總結

以上是生活随笔為你收集整理的将数据到处到Excel的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

数据
EXCEL