poi--excel --匯出例項

瓜瓜東西發表於2014-08-01
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;
}


}

相關文章