九州编程
public class ExporTest {
private Map smap;// 存储模板中单元格样式
@Test
public void test() {
Workbook wb = getWorkbook(path);
initStyle(wb);
writeSheet(wb.getSheetAt(1));
writeExcel(wb);
}private Workbook getWorkbook(String filepath) {
Workbook wb = null;
try {
wb = new XSSFWorkbook(filepath);
} catch (Exception ex) {
ex.printStackTrace();
}
return wb;
}
/**
* 从模板中取单元格样式，
*
* @param wb
*/
private void initStyle(Workbook wb) {
CellStyle normal = wb.getSheetAt(0).getRow(5).getCell(0).getCellStyle();
smap.put("normal", normal);
}
private void writeSheet(Sheet sh) {
for (int i = 0; i < ps.size(); i++) {
Row row = sh.createRow(i + 1);
Cell cell = row.createCell(0);
cell.setCellStyle(smap.get("normal"));
cell.setCellValue(permission.getName());
}
}
private void writeExcel(Workbook wb) {
try {
FileOutputStream out = new FileOutputStream("test.xls");
wb.write(out);
out.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}