《java生成excel模板导出》由会员分享,可在线阅读,更多相关《java生成excel模板导出(6页珍藏版)》请在金锄头文库上搜索。
1、java生成excel模板导出getTimeStr方法:public static String getTimeStr(Date date, String format) SimpleDateFormat simpleDateFormat = new SimpleDateFormat(format);return simpleDateFormat.format(date);createExcelModel方法全部代码:public static HSSFWorkbook createExcelModel()throws ExceptionHSSFWorkbook wb = new HSSFWo
2、rkbook();/创建工作薄HSSFSheet sheet = wb.createSheet(任务模板);/新建工作表HSSFRow row = sheet.createRow(short)0);/创建行row.setHeightInPoints(short)20);/设置excel单元格高度HSSFRichTextString text = null;HSSFFont font = wb.createFont();font.setColor(HSSFFont.COLOR_RED);font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);HSSFCellSt
3、yle style = wb.createCellStyle();style.setFont(font);for (int i = 0; i 21; i+) /创建列HSSFCell cell = row.createCell(i);/创建单元格switch(i)case 0:if(i=0)text=new HSSFRichTextString(客户编号);cell.setCellValue(text);cell.setCellStyle(style);cell.setCellType(HSSFCell.CELL_TYPE_STRING);case 1:if(i=1)text=new HSSF
4、RichTextString(客户姓名);cell.setCellValue(text);cell.setCellStyle(style);cell.setCellType(HSSFCell.CELL_TYPE_STRING);case 2:if(i=2)text=new HSSFRichTextString(英文名称);cell.setCellValue(text);cell.setCellType(HSSFCell.CELL_TYPE_STRING);case 3:if(i=3)text=new HSSFRichTextString(英文简称);cell.setCellValue(text
5、);cell.setCellType(HSSFCell.CELL_TYPE_STRING);case 4:if(i=4)text=new HSSFRichTextString(客户级别);cell.setCellValue(text);cell.setCellStyle(style);/cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);case 5:if(i=5)text=new HSSFRichTextString(证件类别);cell.setCellValue(text);cell.setCellStyle(style);/cell.setCellT
6、ype(HSSFCell.CELL_TYPE_NUMERIC);case 6:if(i=6)text=new HSSFRichTextString(证件号码);cell.setCellValue(text);cell.setCellStyle(style);/cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);case 7:if(i=7)text=new HSSFRichTextString(性别);cell.setCellValue(text);cell.setCellType(HSSFCell.CELL_TYPE_STRING);case 8:if(i
7、=8)text=new HSSFRichTextString(电话);cell.setCellValue(text);/cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);case 9:if(i=9)text=new HSSFRichTextString(传真);cell.setCellValue(text);/cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);case 10:if(i=10)text=new HSSFRichTextString(手机);cell.setCellValue(text);cell.se
8、tCellStyle(style);/cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);case 11:if(i=11)text=new HSSFRichTextString(邮编);cell.setCellValue(text);cell.setCellStyle(style);/cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);case 12:if(i=12)text=new HSSFRichTextString(电子邮件地址);cell.setCellValue(text);cell.setCellStyle
9、(style);cell.setCellType(HSSFCell.CELL_TYPE_STRING);case 13:if(i=13)text=new HSSFRichTextString(备注);cell.setCellValue(text);cell.setCellType(HSSFCell.CELL_TYPE_STRING);case 14:if(i=14)text=new HSSFRichTextString(省份);cell.setCellValue(text);cell.setCellStyle(style);case 15:if(i=15)text=new HSSFRichTe
10、xtString(城市);cell.setCellValue(text);case 16:if(i=16)text=new HSSFRichTextString(地址);cell.setCellValue(text);case 17:if(i=17)text=new HSSFRichTextString(客户类别);cell.setCellValue(text);/cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);case 18:if(i=18)text=new HSSFRichTextString(客户来源);cell.setCellValue(text);/cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);case 19:if(i=19)text=new HSSFRichTextString(行业);cell.setCellValue(text);case 20:if(i=20)text=new HSSFRichTextString(行业细分);cell.setCellValue(text);return wb ;