poi--excel --匯出例項
package com.wanju.project001.zonghe.common.controller;
import java.awt.Label;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
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.usermodel.Workbook;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import com.wanju.project001.zonghe.test.CreateSimpleExcelToDisk;
@Controller
@RequestMapping("/extro")
public class ExtroFuncIndexExportImportController {
@RequestMapping("/init")
public ModelAndView index(HttpServletRequest request,
HttpServletResponse response) {
ModelAndView view = new ModelAndView("/extro/extro");
return view;
}
@RequestMapping("/import")
public ModelAndView importFile(HttpServletRequest request,HttpServletResponse response)
{
String path = request.getParameterMap().get("filepath")[0];
if (null !=path&&!"".equals(path)) {
}
return null;
}
@RequestMapping("/export")
public ModelAndView export(HttpServletRequest request,
HttpServletResponse response) {
ModelAndView view = new ModelAndView("/extro/test");
String tabname = request.getParameterMap().get("tabname")[0];
System.out.println("comon");
if ("user".equals(tabname)) {
// 第一步,建立一個webbook,對應一個Excel檔案
HSSFWorkbook wb = new HSSFWorkbook();
// 第二步,在webbook中新增一個sheet,對應Excel檔案中的sheet
HSSFSheet sheet = wb.createSheet("學生表一");
// 第三步,在sheet中新增表頭第0行,注意老版本poi對Excel的行數列數有限制short
HSSFRow row = sheet.createRow((int) 0);
// 第四步,建立單元格,並設定值表頭 設定表頭居中
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 建立一個居中格式
HSSFCell cell = row.createCell((short) 0);
cell.setCellValue("id");
cell.setCellStyle(style);
cell = row.createCell((short) 1);
cell.setCellValue("name");
cell.setCellStyle(style);
cell = row.createCell((short) 2);
cell.setCellValue("password");
cell.setCellStyle(style);
// 第五步,寫入實體資料 實際應用中這些資料從資料庫得到,
for (int i = 0; i < users.length; i++) {
row = sheet.createRow((int) i + 1);
row.createCell((short) 0).setCellValue(users[i].getId());
row.createCell((short) 1).setCellValue(users[i].getName());
row.createCell((short) 2).setCellValue(users[i].getPassword());
}
// 第六步,將檔案存到指定位置
try
{
FileOutputStream fout = new FileOutputStream("D:/students.xls");
wb.write(fout);
fout.close();
}
catch (Exception e)
{
e.printStackTrace();
}
PrintWriter writer;
try {
writer = response.getWriter();
writer.println("資料已經匯入完畢,匯入了"+users.length+"條資料");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return null;
}
public static final User[] users = { new User(1, "33", "99"),
new User(1, "33", "99"), new User(1, "33", "99") };
}
class User {
private int id;
private String name;
private String password;
public User() {
// TODO Auto-generated constructor stub
}
public User(int id, String name, String password) {
this.id = id;
this.name = name;
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
import java.awt.Label;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
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.usermodel.Workbook;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import com.wanju.project001.zonghe.test.CreateSimpleExcelToDisk;
@Controller
@RequestMapping("/extro")
public class ExtroFuncIndexExportImportController {
@RequestMapping("/init")
public ModelAndView index(HttpServletRequest request,
HttpServletResponse response) {
ModelAndView view = new ModelAndView("/extro/extro");
return view;
}
@RequestMapping("/import")
public ModelAndView importFile(HttpServletRequest request,HttpServletResponse response)
{
String path = request.getParameterMap().get("filepath")[0];
if (null !=path&&!"".equals(path)) {
}
return null;
}
@RequestMapping("/export")
public ModelAndView export(HttpServletRequest request,
HttpServletResponse response) {
ModelAndView view = new ModelAndView("/extro/test");
String tabname = request.getParameterMap().get("tabname")[0];
System.out.println("comon");
if ("user".equals(tabname)) {
// 第一步,建立一個webbook,對應一個Excel檔案
HSSFWorkbook wb = new HSSFWorkbook();
// 第二步,在webbook中新增一個sheet,對應Excel檔案中的sheet
HSSFSheet sheet = wb.createSheet("學生表一");
// 第三步,在sheet中新增表頭第0行,注意老版本poi對Excel的行數列數有限制short
HSSFRow row = sheet.createRow((int) 0);
// 第四步,建立單元格,並設定值表頭 設定表頭居中
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 建立一個居中格式
HSSFCell cell = row.createCell((short) 0);
cell.setCellValue("id");
cell.setCellStyle(style);
cell = row.createCell((short) 1);
cell.setCellValue("name");
cell.setCellStyle(style);
cell = row.createCell((short) 2);
cell.setCellValue("password");
cell.setCellStyle(style);
// 第五步,寫入實體資料 實際應用中這些資料從資料庫得到,
for (int i = 0; i < users.length; i++) {
row = sheet.createRow((int) i + 1);
row.createCell((short) 0).setCellValue(users[i].getId());
row.createCell((short) 1).setCellValue(users[i].getName());
row.createCell((short) 2).setCellValue(users[i].getPassword());
}
// 第六步,將檔案存到指定位置
try
{
FileOutputStream fout = new FileOutputStream("D:/students.xls");
wb.write(fout);
fout.close();
}
catch (Exception e)
{
e.printStackTrace();
}
PrintWriter writer;
try {
writer = response.getWriter();
writer.println("資料已經匯入完畢,匯入了"+users.length+"條資料");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return null;
}
public static final User[] users = { new User(1, "33", "99"),
new User(1, "33", "99"), new User(1, "33", "99") };
}
class User {
private int id;
private String name;
private String password;
public User() {
// TODO Auto-generated constructor stub
}
public User(int id, String name, String password) {
this.id = id;
this.name = name;
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
相關文章
- Java使用jxl.jar匯出Excel例項JavaJARExcel
- SPOOL 命令使用例項【oracle匯出純文字格式檔案】Oracle
- PhpSpreadsheet 匯出excel範例PHPExcel
- Oracle 資料匯出注意事項Oracle
- RDS按量付費例項、只讀例項、OPENAPI正式釋出API
- 原生PHP網頁匯出和匯入excel檔案例項PHP網頁Excel
- 單例項opatch出現RAC資訊單例
- android的Log輸出(例項)Android
- 將表格資料匯入Excel表程式碼例項Excel
- js將表格匯入到Execel表例項程式碼JS
- exp匯出命令中的query選項(轉)
- 【匯出匯入】匯出匯入 大物件物件
- Oracle中exp,imp(匯入匯出)資料遷移注意事項Oracle
- ASM例項出現ORA-4031錯誤導致例項崩潰ASM
- 純真QQIP庫匯入到SQL Server例項詳解SQLServer
- 新手求助高手,message例項出錯.
- C# 中 釋出訂閱例項C#
- 銷售管理系統“eSalesManager”匯入例項 / 泰爾茂上海
- 從例項出發,瞭解單例模式和靜態塊單例模式
- 【匯出匯入】% 在匯入匯出中的應用。
- javascript輸出菱形圖形程式碼例項JavaScript
- 深入淺出檢查點和例項recovery
- 單例項刪除ASM例項單例ASM
- Xcode匯出ipa包四個選項的意思XCode
- Activity 流程模型匯入匯出-activity流程模型匯入匯出模型
- js匯出EXCELjs匯出EXCELJSExcel
- Mysql匯入&匯出MySql
- Mysql匯入匯出MySql
- doris匯入匯出
- esayExcel匯入匯出Excel
- 將table表格內容匯入到word或者Excel程式碼例項Excel
- 資料泵(expdp,impdp)高版本匯入低版本操作例項
- php例項化物件的例項方法PHP物件
- javascript自帶的彈出輸出視窗程式碼例項JavaScript
- ruby中的類例項變數和例項的例項變數變數
- 點選彈出鎖屏層例項程式碼
- 點選彈出半透明層程式碼例項
- 用IDA匯出map檔案時的注意事項