EXCEL导出
导出功能
jsp搞一个点击事件就好。然后跳转
/** * 导出活动报名人员信息 * @param request * @param response */ @RequestMapping("exportApplyToExcel.html") public void exportApplyToExcel(HttpServletRequest request, HttpServletResponse response ) throws Exception{ response.setContentType("text/html;charset=UTF-8"); String realName="活动报名人员名单.xlsx"; response.setContentType("text/html; charset=UTF-8"); response.setHeader("Content-disposition", "attachment; filename=" + new String(realName.getBytes("utf-8"), "ISO8859-1")); String id=request.getParameter("activityId"); Integer activity_id=Integer.parseInt(request.getParameter("activityId")) ; Map<String,String> edcutationType=dictionaryService.findCodeAndNameMapByType(DatabaseConstants.EDUCATION); List<ParkActivityApplicantEntity> applyList= parkActivityApplicantService.findListByActivityId(activity_id); List<ExcelParkActivityApplicantEntity> tempApplyList=new ArrayList<ExcelParkActivityApplicantEntity>(); for(ParkActivityApplicantEntity entity:applyList){ ExcelParkActivityApplicantEntity excelEntity=new ExcelParkActivityApplicantEntity(); excelEntity.setName(entity.getName()); excelEntity.setSex(entity.getSex()==null?"":(entity.getSex()==0?"男":"女")); excelEntity.setAge(entity.getAge()); excelEntity.setEducation(edcutationType.get(entity.getEducation())); excelEntity.setCompanyName(entity.getCompanyName()); excelEntity.setContactNumber(entity.getContactNumber()); excelEntity.setApplyTime(entity.getApplyTime()); tempApplyList.add(excelEntity); } String[] headers = { "姓名", "性别", "年龄", "学历", "单位名称","手机号码","报名时间"}; ExcelUtil excelUtil=new ExcelUtil(); excelUtil.exportExcleHigh(realName,headers,tempApplyList,response.getOutputStream(),"yyyy-MM-dd HH:mm:ss"); }
excel导出的实体类
package com.iport.cs.parkActivity.model.po; import com.iport.base.common.model.po.BaseEntity; import com.iport.base.sys.model.po.UserEntity; import java.util.Date; /** * 报名情况用于EXCLE导出 */ public class ExcelParkActivityApplicantEntity extends BaseEntity { private String name ; private String sex; private Integer age ; private String education ; private String companyName ; private String contactNumber; private Date applyTime; public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public Integer getAge() { return age; } public void setAge(Integer age) { this.age = age; } public String getEducation() { return education; } public void setEducation(String education) { this.education = education; } public String getCompanyName() { return companyName; } public void setCompanyName(String companyName) { this.companyName = companyName; } public String getContactNumber() { return contactNumber; } public void setContactNumber(String contactNumber) { this.contactNumber = contactNumber; } public Date getApplyTime() { return applyTime; } public void setApplyTime(Date applyTime) { this.applyTime = applyTime; } }
excel的工具类
package com.iport.base.utils; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.hssf.util.HSSFColor; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.Color; import org.apache.poi.ss.usermodel.IndexedColors; import org.apache.poi.xssf.usermodel.*; import java.io.IOException; import java.io.OutputStream; import java.io.Serializable; import java.lang.reflect.Field; import java.lang.reflect.Method; import java.text.SimpleDateFormat; import java.util.Collection; import java.util.Date; import java.util.Iterator; import java.util.List; import java.util.regex.Matcher; import java.util.regex.Pattern; public class ExcelUtil<T> { /** * 导出EXCEL2003数据 * @param title * @param headers * @param dataList * @param out * @param pattern */ public void exportExcle(String title, String[] headers, List<T> dataList, OutputStream out, String pattern) { // 声明一个工作薄 HSSFWorkbook workbook = new HSSFWorkbook(); // 生成一个表格 HSSFSheet sheet = workbook.createSheet(title); // 设置表格默认列宽度为15个字节 sheet.setDefaultColumnWidth((short) 15); // 生成一个样式 HSSFCellStyle style = workbook.createCellStyle(); // 设置这些样式 style.setFillForegroundColor(HSSFColor.SKY_BLUE.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderTop(HSSFCellStyle.BORDER_THIN); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 生成一个字体 HSSFFont font = workbook.createFont(); font.setColor(HSSFColor.VIOLET.index); font.setFontHeightInPoints((short) 12); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); // 把字体应用到当前的样式 style.setFont(font); // 生成并设置另一个样式 HSSFCellStyle style2 = workbook.createCellStyle(); style2.setFillForegroundColor(HSSFColor.LIGHT_YELLOW.index); style2.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); style2.setBorderBottom(HSSFCellStyle.BORDER_THIN); style2.setBorderLeft(HSSFCellStyle.BORDER_THIN); style2.setBorderRight(HSSFCellStyle.BORDER_THIN); style2.setBorderTop(HSSFCellStyle.BORDER_THIN); style2.setAlignment(HSSFCellStyle.ALIGN_CENTER); style2.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 生成另一个字体 HSSFFont font2 = workbook.createFont(); font2.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL); // 把字体应用到当前的样式 style2.setFont(font2); // 声明一个画图的顶级管理器 HSSFPatriarch patriarch = sheet.createDrawingPatriarch(); // 定义注释的大小和位置,详见文档 HSSFComment comment = patriarch.createComment(new HSSFClientAnchor(0, 0, 0, 0, (short) 4, 2, (short) 6, 5)); // 设置注释内容 comment.setString(new HSSFRichTextString("可以在POI中添加注释！")); // 设置注释作者，当鼠标移动到单元格上是可以在状态栏中看到该内容. comment.setAuthor("leno"); //产生表格标题行 HSSFRow row = sheet.createRow(0); for (short i = 0; i < headers.length; i++) { HSSFCell cell = row.createCell(i); cell.setCellStyle(style); HSSFRichTextString text = new HSSFRichTextString(headers[i]); cell.setCellValue(text); } int index = 0; for(T t:dataList){ index++; row = sheet.createRow(index); //利用反射，根据javabean属性的先后顺序，动态调用getXxx()方法得到属性值 Field[] fields = t.getClass().getDeclaredFields(); for (short i = 0; i < fields.length; i++) { HSSFCell cell = row.createCell(i); cell.setCellStyle(style2); Field field = fields[i]; String fieldName = field.getName(); String getMethodName = "get" + fieldName.substring(0, 1).toUpperCase() + fieldName.substring(1); try { Class tCls = t.getClass(); Method getMethod = tCls.getMethod(getMethodName, new Class[]{}); Object value = getMethod.invoke(t, new Object[]{}); //判断值的类型后进行强制类型转换 String textValue = null; if(value != null) { if (value instanceof Date ) { Date date = (Date) value; SimpleDateFormat sdf = new SimpleDateFormat(pattern); textValue = sdf.format(date); // } else if (value instanceof byte[]) { // // 有图片时，设置行高为60px; // row.setHeightInPoints(60); // // 设置图片所在列宽度为80px,注意这里单位的一个换算 // sheet.setColumnWidth(i, (short) (35.7 * 80)); // // sheet.autoSizeColumn(i); // byte[] bsValue = (byte[]) value; // HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, // 1023, 255, (short) 6, index, (short) 6, index); // anchor.setAnchorType(2); // patriarch.createPicture(anchor, workbook.addPicture( // bsValue, HSSFWorkbook.PICTURE_TYPE_JPEG)); } else { //其它数据类型都当作字符串简单处理 textValue = value.toString(); } } //如果不是图片数据，就利用正则表达式判断textValue是否全部由数字组成 if (textValue != null) { Pattern p = Pattern.compile("^//d+(//.//d+)?$"); Matcher matcher = p.matcher(textValue); if (matcher.matches()) { //是数字当作double处理 cell.setCellValue(Double.parseDouble(textValue)); } else { HSSFRichTextString richString = new HSSFRichTextString(textValue); HSSFFont font3 = workbook.createFont(); font3.setColor(HSSFColor.BLUE.index); richString.applyFont(font3); cell.setCellValue(richString); } } } catch (Exception e) { e.printStackTrace(); } } } try { workbook.write(out); } catch (IOException e) { e.printStackTrace(); } } /** * 导出EXCEL2007数据 * @param title * @param headers * @param dataList * @param out * @param pattern */ public void exportExcleHigh(String title, String[] headers, List<T> dataList, OutputStream out, String pattern) { // 声明一个工作薄 XSSFWorkbook workbook = new XSSFWorkbook(); // 生成一个表格 XSSFSheet sheet = workbook.createSheet(title); // 设置表格默认列宽度为15个字节 sheet.setDefaultColumnWidth((short) 20); // 生成一个样式 XSSFCellStyle style = workbook.createCellStyle(); // 设置这些样式 style.setFillForegroundColor(IndexedColors.SKY_BLUE.index); style.setFillPattern(CellStyle.SOLID_FOREGROUND); style.setBorderBottom(CellStyle.SOLID_FOREGROUND); style.setBorderLeft(CellStyle.BORDER_THIN); style.setBorderRight(CellStyle.BORDER_THIN); style.setBorderTop(CellStyle.BORDER_THIN); style.setAlignment(CellStyle.BORDER_THIN); style.setVerticalAlignment(XSSFCellStyle.ALIGN_CENTER); style.setAlignment(XSSFCellStyle.ALIGN_CENTER); // 生成一个字体 XSSFFont font = workbook.createFont(); font.setColor(HSSFColor.BLACK.index); font.setFontHeightInPoints((short) 12); font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD); // 把字体应用到当前的样式 style.setFont(font); // 生成并设置另一个样式 XSSFCellStyle style2 = workbook.createCellStyle(); style2.setBorderBottom(CellStyle.BORDER_THIN); style2.setBorderLeft(CellStyle.BORDER_THIN); style2.setBorderRight(CellStyle.BORDER_THIN); style2.setBorderTop(CellStyle.BORDER_THIN); style2.setAlignment(CellStyle.BORDER_THIN); style2.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 生成另一个字体 XSSFFont font2 = workbook.createFont(); font2.setColor(HSSFColor.BLACK.index); // font2.setBoldweight(XSSFFont.BOLDWEIGHT_NORMAL); // 把字体应用到当前的样式 style2.setFont(font2); // 声明一个画图的顶级管理器 // XSSFPatriarch patriarch = sheet.createDrawingPatriarch(); // // 定义注释的大小和位置,详见文档 // XSSFComment comment = patriarch.createComment(new HSSFClientAnchor(0, 0, 0, 0, (short) 4, 2, (short) 6, 5)); // // 设置注释内容 // comment.setString(new HSSFRichTextString("可以在POI中添加注释！")); // // 设置注释作者，当鼠标移动到单元格上是可以在状态栏中看到该内容. // comment.setAuthor("leno"); // // //产生表格标题行 XSSFRow row = sheet.createRow(0); for (short i = 0; i < headers.length; i++) { XSSFCell cell = row.createCell(i); cell.setCellStyle(style); XSSFRichTextString text = new XSSFRichTextString(headers[i]); cell.setCellValue(text); } int index = 0; for(T t:dataList){ index++; row = sheet.createRow(index); //利用反射，根据javabean属性的先后顺序，动态调用getXxx()方法得到属性值 Field[] fields = t.getClass().getDeclaredFields(); for (short i = 0; i < fields.length; i++) { XSSFCell cell = row.createCell(i); cell.setCellStyle(style2); Field field = fields[i]; String fieldName = field.getName(); String getMethodName = "get" + fieldName.substring(0, 1).toUpperCase() + fieldName.substring(1); try { Class tCls = t.getClass(); Method getMethod = tCls.getMethod(getMethodName, new Class[]{}); Object value = getMethod.invoke(t, new Object[]{}); //判断值的类型后进行强制类型转换 String textValue = null; if(value != null) { if (value instanceof Date ) { Date date = (Date) value; SimpleDateFormat sdf = new SimpleDateFormat(pattern); textValue = sdf.format(date); // } else if (value instanceof byte[]) { // // 有图片时，设置行高为60px; // row.setHeightInPoints(60); // // 设置图片所在列宽度为80px,注意这里单位的一个换算 // sheet.setColumnWidth(i, (short) (35.7 * 80)); // // sheet.autoSizeColumn(i); // byte[] bsValue = (byte[]) value; // HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, // 1023, 255, (short) 6, index, (short) 6, index); // anchor.setAnchorType(2); // patriarch.createPicture(anchor, workbook.addPicture( // bsValue, HSSFWorkbook.PICTURE_TYPE_JPEG)); } else { //其它数据类型都当作字符串简单处理 textValue = value.toString(); } } //如果不是图片数据，就利用正则表达式判断textValue是否全部由数字组成 if (textValue != null) { Pattern p = Pattern.compile("^//d+(//.//d+)?$"); Matcher matcher = p.matcher(textValue); if (matcher.matches()) { //是数字当作double处理 cell.setCellValue(Double.parseDouble(textValue)); } else { XSSFRichTextString richString = new XSSFRichTextString(textValue); cell.setCellValue(richString); } } } catch (Exception e) { e.printStackTrace(); } } } try { workbook.write(out); } catch (IOException e) { e.printStackTrace(); } } }
样式
/* ==================================================================== Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ==================================================================== */ package org.apache.poi.ss.usermodel; public interface CellStyle { /** * general (normal) horizontal alignment */ short ALIGN_GENERAL = 0x0; /** * left-justified horizontal alignment */ short ALIGN_LEFT = 0x1; /** * center horizontal alignment */ short ALIGN_CENTER = 0x2; /** * right-justified horizontal alignment */ short ALIGN_RIGHT = 0x3; /** * fill? horizontal alignment */ short ALIGN_FILL = 0x4; /** * justified horizontal alignment */ short ALIGN_JUSTIFY = 0x5; /** * center-selection? horizontal alignment */ short ALIGN_CENTER_SELECTION = 0x6; /** * top-aligned vertical alignment */ short VERTICAL_TOP = 0x0; /** * center-aligned vertical alignment */ short VERTICAL_CENTER = 0x1; /** * bottom-aligned vertical alignment */ short VERTICAL_BOTTOM = 0x2; /** * vertically justified vertical alignment */ short VERTICAL_JUSTIFY = 0x3; /** * No border */ short BORDER_NONE = 0x0; /** * Thin border */ short BORDER_THIN = 0x1; /** * Medium border */ short BORDER_MEDIUM = 0x2; /** * dash border */ short BORDER_DASHED = 0x3; /** * dot border */ short BORDER_HAIR = 0x7; /** * Thick border */ short BORDER_THICK = 0x5; /** * double-line border */ short BORDER_DOUBLE = 0x6; /** * hair-line border */ short BORDER_DOTTED = 0x4; /** * Medium dashed border */ short BORDER_MEDIUM_DASHED = 0x8; /** * dash-dot border */ short BORDER_DASH_DOT = 0x9; /** * medium dash-dot border */ short BORDER_MEDIUM_DASH_DOT = 0xA; /** * dash-dot-dot border */ short BORDER_DASH_DOT_DOT = 0xB; /** * medium dash-dot-dot border */ short BORDER_MEDIUM_DASH_DOT_DOT = 0xC; /** * slanted dash-dot border */ short BORDER_SLANTED_DASH_DOT = 0xD; /** No background */ short NO_FILL = 0; /** Solidly filled */ short SOLID_FOREGROUND = 1; /** Small fine dots */ short FINE_DOTS = 2; /** Wide dots */ short ALT_BARS = 3; /** Sparse dots */ short SPARSE_DOTS = 4; /** Thick horizontal bands */ short THICK_HORZ_BANDS = 5; /** Thick vertical bands */ short THICK_VERT_BANDS = 6; /** Thick backward facing diagonals */ short THICK_BACKWARD_DIAG = 7; /** Thick forward facing diagonals */ short THICK_FORWARD_DIAG = 8; /** Large spots */ short BIG_SPOTS = 9; /** Brick-like layout */ short BRICKS = 10; /** Thin horizontal bands */ short THIN_HORZ_BANDS = 11; /** Thin vertical bands */ short THIN_VERT_BANDS = 12; /** Thin backward diagonal */ short THIN_BACKWARD_DIAG = 13; /** Thin forward diagonal */ short THIN_FORWARD_DIAG = 14; /** Squares */ short SQUARES = 15; /** Diamonds */ short DIAMONDS = 16; /** Less Dots */ short LESS_DOTS = 17; /** Least Dots */ short LEAST_DOTS = 18; /** * get the index within the Workbook (sequence within the collection of ExtnededFormat objects) * @return unique index number of the underlying record this style represents (probably you don't care * unless you're comparing which one is which) */ short getIndex(); /** * set the data format (must be a valid format) * @see DataFormat */ void setDataFormat(short fmt); /** * get the index of the format * @see DataFormat */ short getDataFormat(); /** * Get the format string */ public String getDataFormatString(); /** * set the font for this style * @param font a font object created or retrieved from the Workbook object * @see Workbook#createFont() * @see Workbook#getFontAt(short) */ void setFont(Font font); /** * gets the index of the font for this style * @see Workbook#getFontAt(short) */ short getFontIndex(); /** * set the cell's using this style to be hidden * @param hidden - whether the cell using this style should be hidden */ void setHidden(boolean hidden); /** * get whether the cell's using this style are to be hidden * @return hidden - whether the cell using this style should be hidden */ boolean getHidden(); /** * set the cell's using this style to be locked * @param locked - whether the cell using this style should be locked */ void setLocked(boolean locked); /** * get whether the cell's using this style are to be locked * @return hidden - whether the cell using this style should be locked */ boolean getLocked(); /** * set the type of horizontal alignment for the cell * @param align - the type of alignment * @see #ALIGN_GENERAL * @see #ALIGN_LEFT * @see #ALIGN_CENTER * @see #ALIGN_RIGHT * @see #ALIGN_FILL * @see #ALIGN_JUSTIFY * @see #ALIGN_CENTER_SELECTION */ void setAlignment(short align); /** * get the type of horizontal alignment for the cell * @return align - the type of alignment * @see #ALIGN_GENERAL * @see #ALIGN_LEFT * @see #ALIGN_CENTER * @see #ALIGN_RIGHT * @see #ALIGN_FILL * @see #ALIGN_JUSTIFY * @see #ALIGN_CENTER_SELECTION */ short getAlignment(); /** * Set whether the text should be wrapped. * Setting this flag to <code>true</code> make all content visible * whithin a cell by displaying it on multiple lines * * @param wrapped wrap text or not */ void setWrapText(boolean wrapped); /** * get whether the text should be wrapped * @return wrap text or not */ boolean getWrapText(); /** * set the type of vertical alignment for the cell * @param align the type of alignment * @see #VERTICAL_TOP * @see #VERTICAL_CENTER * @see #VERTICAL_BOTTOM * @see #VERTICAL_JUSTIFY */ void setVerticalAlignment(short align); /** * get the type of vertical alignment for the cell * @return align the type of alignment * @see #VERTICAL_TOP * @see #VERTICAL_CENTER * @see #VERTICAL_BOTTOM * @see #VERTICAL_JUSTIFY */ short getVerticalAlignment(); /** * set the degree of rotation for the text in the cell. * * Note: HSSF uses values from -90 to 90 degrees, whereas XSSF * uses values from 0 to 180 degrees. The implementations of this method will map between these two value-ranges * accordingly, however the corresponding getter is returning values in the range mandated by the current type * of Excel file-format that this CellStyle is applied to. * * @param rotation degrees (see note above) */ void setRotation(short rotation); /** * get the degree of rotation for the text in the cell. * * Note: HSSF uses values from -90 to 90 degrees, whereas XSSF * uses values from 0 to 180 degrees. The implementations of this method will map between these two value-ranges * value-range as used by the type of Excel file-format that this CellStyle is applied to. * * @return rotation degrees (see note above) */ short getRotation(); /** * set the number of spaces to indent the text in the cell * @param indent - number of spaces */ void setIndention(short indent); /** * get the number of spaces to indent the text in the cell * @return indent - number of spaces */ short getIndention(); /** * set the type of border to use for the left border of the cell * @param border type * @see #BORDER_NONE * @see #BORDER_THIN * @see #BORDER_MEDIUM * @see #BORDER_DASHED * @see #BORDER_DOTTED * @see #BORDER_THICK * @see #BORDER_DOUBLE * @see #BORDER_HAIR * @see #BORDER_MEDIUM_DASHED * @see #BORDER_DASH_DOT * @see #BORDER_MEDIUM_DASH_DOT * @see #BORDER_DASH_DOT_DOT * @see #BORDER_MEDIUM_DASH_DOT_DOT * @see #BORDER_SLANTED_DASH_DOT */ void setBorderLeft(short border); /** * get the type of border to use for the left border of the cell * @return border type * @see #BORDER_NONE * @see #BORDER_THIN * @see #BORDER_MEDIUM * @see #BORDER_DASHED * @see #BORDER_DOTTED * @see #BORDER_THICK * @see #BORDER_DOUBLE * @see #BORDER_HAIR * @see #BORDER_MEDIUM_DASHED * @see #BORDER_DASH_DOT * @see #BORDER_MEDIUM_DASH_DOT * @see #BORDER_DASH_DOT_DOT * @see #BORDER_MEDIUM_DASH_DOT_DOT * @see #BORDER_SLANTED_DASH_DOT */ short getBorderLeft(); /** * set the type of border to use for the right border of the cell * @param border type * @see #BORDER_NONE * @see #BORDER_THIN * @see #BORDER_MEDIUM * @see #BORDER_DASHED * @see #BORDER_DOTTED * @see #BORDER_THICK * @see #BORDER_DOUBLE * @see #BORDER_HAIR * @see #BORDER_MEDIUM_DASHED * @see #BORDER_DASH_DOT * @see #BORDER_MEDIUM_DASH_DOT * @see #BORDER_DASH_DOT_DOT * @see #BORDER_MEDIUM_DASH_DOT_DOT * @see #BORDER_SLANTED_DASH_DOT */ void setBorderRight(short border); /** * get the type of border to use for the right border of the cell * @return border type * @see #BORDER_NONE * @see #BORDER_THIN * @see #BORDER_MEDIUM * @see #BORDER_DASHED * @see #BORDER_DOTTED * @see #BORDER_THICK * @see #BORDER_DOUBLE * @see #BORDER_HAIR * @see #BORDER_MEDIUM_DASHED * @see #BORDER_DASH_DOT * @see #BORDER_MEDIUM_DASH_DOT * @see #BORDER_DASH_DOT_DOT * @see #BORDER_MEDIUM_DASH_DOT_DOT * @see #BORDER_SLANTED_DASH_DOT */ short getBorderRight(); /** * set the type of border to use for the top border of the cell * @param border type * @see #BORDER_NONE * @see #BORDER_THIN * @see #BORDER_MEDIUM * @see #BORDER_DASHED * @see #BORDER_DOTTED * @see #BORDER_THICK * @see #BORDER_DOUBLE * @see #BORDER_HAIR * @see #BORDER_MEDIUM_DASHED * @see #BORDER_DASH_DOT * @see #BORDER_MEDIUM_DASH_DOT * @see #BORDER_DASH_DOT_DOT * @see #BORDER_MEDIUM_DASH_DOT_DOT * @see #BORDER_SLANTED_DASH_DOT */ void setBorderTop(short border); /** * get the type of border to use for the top border of the cell * @return border type * @see #BORDER_NONE * @see #BORDER_THIN * @see #BORDER_MEDIUM * @see #BORDER_DASHED * @see #BORDER_DOTTED * @see #BORDER_THICK * @see #BORDER_DOUBLE * @see #BORDER_HAIR * @see #BORDER_MEDIUM_DASHED * @see #BORDER_DASH_DOT * @see #BORDER_MEDIUM_DASH_DOT * @see #BORDER_DASH_DOT_DOT * @see #BORDER_MEDIUM_DASH_DOT_DOT * @see #BORDER_SLANTED_DASH_DOT */ short getBorderTop(); /** * set the type of border to use for the bottom border of the cell * @param border type * @see #BORDER_NONE * @see #BORDER_THIN * @see #BORDER_MEDIUM * @see #BORDER_DASHED * @see #BORDER_DOTTED * @see #BORDER_THICK * @see #BORDER_DOUBLE * @see #BORDER_HAIR * @see #BORDER_MEDIUM_DASHED * @see #BORDER_DASH_DOT * @see #BORDER_MEDIUM_DASH_DOT * @see #BORDER_DASH_DOT_DOT * @see #BORDER_MEDIUM_DASH_DOT_DOT * @see #BORDER_SLANTED_DASH_DOT */ void setBorderBottom(short border); /** * get the type of border to use for the bottom border of the cell * @return border type * @see #BORDER_NONE * @see #BORDER_THIN * @see #BORDER_MEDIUM * @see #BORDER_DASHED * @see #BORDER_DOTTED * @see #BORDER_THICK * @see #BORDER_DOUBLE * @see #BORDER_HAIR * @see #BORDER_MEDIUM_DASHED * @see #BORDER_DASH_DOT * @see #BORDER_MEDIUM_DASH_DOT * @see #BORDER_DASH_DOT_DOT * @see #BORDER_MEDIUM_DASH_DOT_DOT * @see #BORDER_SLANTED_DASH_DOT */ short getBorderBottom(); /** * set the color to use for the left border * @param color The index of the color definition */ void setLeftBorderColor(short color); /** * get the color to use for the left border */ short getLeftBorderColor(); /** * set the color to use for the right border * @param color The index of the color definition */ void setRightBorderColor(short color); /** * get the color to use for the left border * @return the index of the color definition */ short getRightBorderColor(); /** * set the color to use for the top border * @param color The index of the color definition */ void setTopBorderColor(short color); /** * get the color to use for the top border * @return hhe index of the color definition */ short getTopBorderColor(); /** * set the color to use for the bottom border * @param color The index of the color definition */ void setBottomBorderColor(short color); /** * get the color to use for the left border * @return the index of the color definition */ short getBottomBorderColor(); /** * setting to one fills the cell with the foreground color... No idea about * other values * * @see #NO_FILL * @see #SOLID_FOREGROUND * @see #FINE_DOTS * @see #ALT_BARS * @see #SPARSE_DOTS * @see #THICK_HORZ_BANDS * @see #THICK_VERT_BANDS * @see #THICK_BACKWARD_DIAG * @see #THICK_FORWARD_DIAG * @see #BIG_SPOTS * @see #BRICKS * @see #THIN_HORZ_BANDS * @see #THIN_VERT_BANDS * @see #THIN_BACKWARD_DIAG * @see #THIN_FORWARD_DIAG * @see #SQUARES * @see #DIAMONDS * * @param fp fill pattern (set to 1 to fill w/foreground color) */ void setFillPattern(short fp); /** * get the fill pattern (??) - set to 1 to fill with foreground color * @return fill pattern */ short getFillPattern(); /** * set the background fill color. * * @param bg color */ void setFillBackgroundColor(short bg); /** * get the background fill color, if the fill * is defined with an indexed color. * @return fill color index, or 0 if not indexed (XSSF only) */ short getFillBackgroundColor(); /** * Gets the color object representing the current * background fill, resolving indexes using * the supplied workbook. * This will work for both indexed and rgb * defined colors. */ Color getFillBackgroundColorColor(); /** * set the foreground fill color * <i>Note: Ensure Foreground color is set prior to background color.</i> * @param bg color */ void setFillForegroundColor(short bg); /** * get the foreground fill color, if the fill * is defined with an indexed color. * @return fill color, or 0 if not indexed (XSSF only) */ short getFillForegroundColor(); /** * Gets the color object representing the current * foreground fill, resolving indexes using * the supplied workbook. * This will work for both indexed and rgb * defined colors. */ Color getFillForegroundColorColor(); /** * Clones all the style information from another * CellStyle, onto this one. This * CellStyle will then have all the same * properties as the source, but the two may * be edited independently. * Any stylings on this CellStyle will be lost! * * The source CellStyle could be from another * Workbook if you like. This allows you to * copy styles from one Workbook to another. * * However, both of the CellStyles will need * to be of the same type (HSSFCellStyle or * XSSFCellStyle) */ public void cloneStyleFrom(CellStyle source); /** * Controls if the Cell should be auto-sized * to shrink to fit if the text is too long */ public void setShrinkToFit(boolean shrinkToFit); /** * Should the Cell be auto-sized by Excel to shrink * it to fit if this text is too long? */ public boolean getShrinkToFit(); }
