org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(6.5k)|赞(0)|评价(0)|浏览(283)

本文整理了Java中org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle()方法的一些代码示例，展示了HSSFWorkbook.createCellStyle()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。HSSFWorkbook.createCellStyle()方法的具体详情如下：
包路径：org.apache.poi.hssf.usermodel.HSSFWorkbook
类名称：HSSFWorkbook
方法名：createCellStyle

HSSFWorkbook.createCellStyle介绍

[英]Create a new Cell style and add it to the workbook's style table. You can define up to 4000 unique styles in a .xls workbook.
[中]创建新的单元格样式并将其添加到工作簿的样式表中。您最多可以在一个文档中定义4000个独特样式。xls工作簿。

代码示例

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook workbook=new HSSFWorkbook();
  2.      HSSFSheet sheet =  workbook.createSheet("FirstSheet");  
  3.      HSSFRow rowhead=   sheet.createRow((short)0);
  4.      HSSFCellStyle style = workbook.createCellStyle();
  5.      style.setWrapText(true);
  6.      row.setRowStyle(style);
  7.      row.getCell(0).setCellStyle(style);

代码示例来源：origin: rakam-io/rakam

  1. boldFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  2. HSSFCellStyle headerSyle = workbook.createCellStyle();
  3. headerSyle.setBorderBottom(CellStyle.BORDER_THIN);
  4. headerSyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());

代码示例来源：origin: stackoverflow.com

  1. HSSFCellStyle style = wb.createCellStyle();
  2. style.setFillForegroundColor(HSSFColor.LIME.index);
  3. style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

代码示例来源：origin: cuba-platform/yarg

  1. public static HSSFCellStyle adoptDetachedCellStyle(HSSFWorkbook workbook, HSSFCellStyle detachedCellStyle) {
  2.     HSSFCellStyle cellStyle = workbook.createCellStyle();
  3.     XslStyleHelper.cloneStyleRelations(detachedCellStyle, cellStyle);
  4.     return cellStyle;
  5.   }
  6. }

代码示例来源：origin: paypal/SeLion

  1. private static HSSFCellStyle createCustomStyle(HSSFFont fontStyle, Short... alignment) {
  2.   HSSFCellStyle style = wb1.createCellStyle();
  3.   style.setFont(fontStyle);
  4.   if (alignment.length > 0) {
  5.     style.setAlignment(alignment[0]);
  6.   }
  7.   return style;
  8. }

代码示例来源：origin: com.github.hazendaz/displaytag

  1. /**
  2.  * Gets the new cell style.
  3.  *
  4.  * @return the new cell style
  5.  */
  6. public HSSFCellStyle getNewCellStyle()
  7. {
  8.   return getWb() == null ? null : getWb().createCellStyle();
  9. }

代码示例来源：origin: com.github.hazendaz/displaytag

  1. /**
  2.  * Gets the new cell style.
  3.  *
  4.  * @return the new cell style
  5.  */
  6. public HSSFCellStyle getNewCellStyle()
  7. {
  8.   return getWb() == null ? null : getWb().createCellStyle();
  9. }

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook wb = ...;
  2. DataFormat format = wb.createDataFormat();
  4. HSSFCellStyle cellStyle = wb.createCellStyle();
  5. style.setDataFormat(format.getFormat("@")); // or "text"
  6. cell.setCellStyle(cellStyle);

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook wb = new HSSFWorkbook();
  2. HSSFRow row = wb.createSheet().createRow(0);
  3. CellStyle cellStyle = wb.createCellStyle();
  4. cellStyle.setDataFormat(wb.getCreationHelper().createDataFormat().getFormat("HH:mm:ss"));
  5. HSSFCell cell = row.createCell(1);
  6. Calendar cal = Calendar.getInstance();
  7. cal.set(Calendar.YEAR, 1970);
  8. cal.set(Calendar.MONTH, 0);
  9. cal.set(Calendar.DATE, 1);
  10. //you can set the time you need here ...
  11. cell.setCellValue(cal);
  12. cell.setCellStyle(cellStyle);

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook wb = new HSSFWorkbook();
  2. HSSFSheet sheet = wb.createSheet("Test");
  4. Row row = sheet.createRow(0);
  6. CellStyle style = wb.createCellStyle();
  7. style.setLocked(true);
  8. cell = row.createCell(0);
  9. cell.setCellStyle(style);
  11. // this is important as locking is pnly activated if sheet is protected
  12. sheet.protectSheet("");

代码示例来源：origin: com.haulmont.charts/charts-web

  1. protected void createCellStyle() {
  2.   HSSFFont boldFont = wb.createFont();
  3.   boldFont.setBold(true);
  4.   boldStyle = wb.createCellStyle();
  5.   boldStyle.setFont(boldFont);
  6. }

代码示例来源：origin: TomasKypta/android-lang-tool

  1. private static HSSFCellStyle createTextStyle(HSSFWorkbook wb) {
  2.   HSSFFont plain = wb.createFont();
  3.   plain.setFontHeightInPoints((short)12);
  4.   HSSFCellStyle textStyle = wb.createCellStyle();
  5.   textStyle.setFont(plain);
  6.   return textStyle;
  7. }

代码示例来源：origin: jasperreports/jasperreports

  1. protected void openWorkbook(OutputStream os)
  2. {
  3.   workbook = new HSSFWorkbook();
  4.   emptyCellStyle = workbook.createCellStyle();
  5.   emptyCellStyle.setFillForegroundColor((new HSSFColor.WHITE()).getIndex());
  6.   emptyCellStyle.setFillPattern(backgroundMode);
  7.   dataFormat = workbook.createDataFormat();
  8. }

代码示例来源：origin: qcadoo/mes

  1. private HSSFCellStyle createStyle(final HSSFWorkbook workbook, boolean isFirst, short align) {
  2.   HSSFCellStyle style = workbook.createCellStyle();
  3.   if (isFirst) {
  4.     style.setBorderTop(HSSFCellStyle.BORDER_THIN);
  5.   }
  6.   if (align == RIGHT) {
  7.     style.setAlignment(RIGHT);
  8.     style.setDataFormat(dataFormat.getFormat("[HH]:MM:SS"));
  9.   }
  10.   return style;
  11. }

代码示例来源：origin: qcadoo/mes

  1. public static HSSFCellStyle rowStyle2(final HSSFSheet sheet) {
  2.     HSSFCellStyle style = sheet.getWorkbook().createCellStyle();
  4.     style.setBorderTop(HSSFCellStyle.BORDER_MEDIUM);
  5.     style.setBorderLeft(HSSFCellStyle.BORDER_MEDIUM);
  6.     style.setBorderRight(HSSFCellStyle.BORDER_MEDIUM);
  7.     style.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM);
  9.     return style;
  10.   }
  11. }

代码示例来源：origin: TomasKypta/android-lang-tool

  1. private static HSSFCellStyle createCommentStyle(HSSFWorkbook wb) {
  2.   HSSFFont commentFont = wb.createFont();
  3.   commentFont.setColor(HSSFColor.GREEN.index);
  4.   commentFont.setItalic(true);
  5.   commentFont.setFontHeightInPoints((short)12);
  6.   HSSFCellStyle commentStyle = wb.createCellStyle();
  7.   commentStyle.setFont(commentFont);
  8.   return commentStyle;
  9. }

代码示例来源：origin: org.sakaiproject.assignment/sakai-assignment-impl

  1. private HSSFCellStyle createHeaderStyle(){
  2.   //TO-DO read style information from sakai.properties
  3.   HSSFFont font = gradesWorkbook.createFont();
  4.   font.setFontName(HSSFFont.FONT_ARIAL);
  5.   font.setColor(IndexedColors.PLUM.getIndex());
  6.   font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  7.   HSSFCellStyle cellStyle = gradesWorkbook.createCellStyle();
  8.   cellStyle.setFont(font);
  9.   return cellStyle;
  10. }

代码示例来源：origin: qcadoo/mes

  1. private void whiteDataStyle(HSSFSheet sheet) {
  2.   HSSFCellStyle style = sheet.getWorkbook().createCellStyle();
  3.   style.setBorderTop(HSSFCellStyle.BORDER_THIN);
  4.   style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
  5.   style.setBorderRight(HSSFCellStyle.BORDER_THIN);
  6.   style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
  7.   style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
  8.   style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
  9.   style.setWrapText(true);
  10.   style.setFont(fontNormal);
  11.   styles.put(I_WhiteDataStyle, style);
  12. }

代码示例来源：origin: youseries/ureport

  1. CellStyle rowStyle=cell.getRow().getCustomCellStyle();
  2. CellStyle colStyle=cell.getColumn().getCustomCellStyle();
  3. HSSFCellStyle style=wb.createCellStyle();
  4. style.setWrapText(true);
  5. String bgcolor=cellStyle.getBgcolor();

代码示例来源：origin: TomasKypta/android-lang-tool

  1. private static HSSFCellStyle createTilteStyle(HSSFWorkbook wb) {
  2.   HSSFFont bold = wb.createFont();
  3.   bold.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  4.   HSSFCellStyle style = wb.createCellStyle();
  5.   style.setFont(bold);
  6.   style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
  7.   style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
  8.   style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
  9.   style.setWrapText(true);
  10.   return style;
  11. }

内容来源于网络，如有侵权，请联系作者删除！

HSSFWorkbook

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    HSSFWorkbook类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com