1.引入jar包依赖
org.apache.poi
poi
3.9
org.apache.poi
poi-ooxml
3.8
View Code
2.编写代码测试
1 packagetestweb;2
3 importjava.io.File;4 importjava.io.FileNotFoundException;5 importjava.io.FileOutputStream;6 importjava.io.IOException;7 importjava.io.OutputStream;8 importjava.util.LinkedList;9 importjava.util.List;10
11 importorg.apache.poi.hssf.usermodel.HSSFCell;12 importorg.apache.poi.hssf.usermodel.HSSFCellStyle;13 importorg.apache.poi.hssf.usermodel.HSSFFont;14 importorg.apache.poi.hssf.usermodel.HSSFRichTextString;15 importorg.apache.poi.hssf.usermodel.HSSFRow;16 importorg.apache.poi.hssf.usermodel.HSSFSheet;17 importorg.apache.poi.hssf.usermodel.HSSFWorkbook;18 importorg.apache.poi.hssf.util.HSSFColor;19
20
21 public classTestExcel {22
23 public static voidmain(String[] args) {24 List l=new LinkedList<>();25 l.add("zs");26 l.add("ls");27 l.add("we");28 l.add("mz");29 String[] headers=new String[]{"tou1","tou2","tou3","tou4"};30 try{31 OutputStream o= new FileOutputStream(new File("C:/Users/yanan/Desktop/yanantest.xls"));32 exportDataExcel("nihao",headers,l,o);33 } catch(FileNotFoundException e) {34 e.printStackTrace();35 }36 }37
38 protected static void exportDataExcel(String title,String[] headers,ListmapList,OutputStream out){39 //声明一个工作簿
40 HSSFWorkbook workbook = newHSSFWorkbook();41 //生成一个表格
42 HSSFSheet sheet =workbook.createSheet(title);43 //设置表格默认列宽度字符
44 sheet.setDefaultColumnWidth(20);45 //生成一个样式,用来设置标题样式
46 HSSFCellStyle style =workbook.createCellStyle();47 //设置这些样式
48 style.setFillForegroundColor(HSSFColor.SKY_BLUE.index);49 style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);50 style.setBorderBottom(HSSFCellStyle.BORDER_THIN);51 style.setBorderLeft(HSSFCellStyle.BORDER_THIN);52 style.setBorderRight(HSSFCellStyle.BORDER_THIN);53 style.setBorderTop(HSSFCellStyle.BORDER_THIN);54 style.setAlignment(HSSFCellStyle.ALIGN_CENTER);55 //生成一个字体
56 HSSFFont font =workbook.createFont();57 font.setColor(HSSFColor.VIOLET.index);58 font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);59 //把字体应用到当前的样式
60 style.setFont(font);61 //生成并设置另一个样式,用于设置内容样式
62 HSSFCellStyle style2 =workbook.createCellStyle();63 style2.setFillForegroundCo