org.apache.poi.ss.usermodel.Sheet.setDefaultColumnStyle()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(11.3k)|赞(0)|评价(0)|浏览(154)

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

Sheet.setDefaultColumnStyle介绍

[英]Sets the default column style for a given column. POI will only apply this style to new cells added to the sheet.
[中]

代码示例

代码示例来源：origin: looly/hutool

/**
 * 获取或创建某一行的样式，返回样式后可以设置样式内容
 * 
 * @param x X坐标，从0计数，既列号
 * @return {@link CellStyle}
 * @since 4.1.4
 */
public CellStyle getOrCreateColumnStyle(int x) {
  CellStyle columnStyle = this.sheet.getColumnStyle(x);
  if (null == columnStyle) {
    columnStyle = this.workbook.createCellStyle();
    this.sheet.setDefaultColumnStyle(x, columnStyle);
  }
  return columnStyle;
}

代码示例来源：origin: looly/hutool

/**
 * 获取或创建某一行的样式，返回样式后可以设置样式内容
 * 
 * @param x X坐标，从0计数，既列号
 * @return {@link CellStyle}
 * @since 4.1.4
 */
public CellStyle getOrCreateColumnStyle(int x) {
  CellStyle columnStyle = this.sheet.getColumnStyle(x);
  if (null == columnStyle) {
    columnStyle = this.workbook.createCellStyle();
    this.sheet.setDefaultColumnStyle(x, columnStyle);
  }
  return columnStyle;
}

代码示例来源：origin: cn.hutool/hutool-all

/**
 * 获取或创建某一行的样式，返回样式后可以设置样式内容
 * 
 * @param x X坐标，从0计数，既列号
 * @return {@link CellStyle}
 * @since 4.1.4
 */
public CellStyle getOrCreateColumnStyle(int x) {
  CellStyle columnStyle = this.sheet.getColumnStyle(x);
  if (null == columnStyle) {
    columnStyle = this.workbook.createCellStyle();
    this.sheet.setDefaultColumnStyle(x, columnStyle);
  }
  return columnStyle;
}

代码示例来源：origin: org.spdx/spdx-tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: org.spdx/spdx-tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: org.spdx/spdx-tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: spdx/tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: spdx/tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: spdx/tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: org.spdx/spdx-tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: org.spdx/spdx-tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: spdx/tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: org.spdx/spdx-tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: spdx/tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: spdx/tools

public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < HEADER_TITLES.length; i++) {
    sheet.setColumnWidth(i, COLUMN_WIDTHS[i]*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
    cell.setCellValue(HEADER_TITLES[i]);
  }
}

代码示例来源：origin: org.spdx/spdx-tools

/**
 * @param wb
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
    sheet.setColumnWidth(i, COL_WIDTH*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
  }
}

代码示例来源：origin: org.spdx/spdx-tools

/**
 * @param wb
 * @param reviewerSheetName
 */
public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
    sheet.setColumnWidth(i, COL_WIDTH*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
  }
}

代码示例来源：origin: org.spdx/spdx-tools

/**
 * @param wb
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
    sheet.setColumnWidth(i, COL_WIDTH*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
  }
}

代码示例来源：origin: spdx/tools

/**
 * @param wb
 * @param reviewerSheetName
 */
public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
    sheet.setColumnWidth(i, COL_WIDTH*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
  }
}

代码示例来源：origin: spdx/tools

/**
 * @param wb
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
  int sheetNum = wb.getSheetIndex(sheetName);
  if (sheetNum >= 0) {
    wb.removeSheetAt(sheetNum);
  }
  Sheet sheet = wb.createSheet(sheetName);
  CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
  CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
  Row row = sheet.createRow(0);
  for (int i = 0; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
    sheet.setColumnWidth(i, COL_WIDTH*256);
    sheet.setDefaultColumnStyle(i, defaultStyle);
    Cell cell = row.createCell(i);
    cell.setCellStyle(headerStyle);
  }
}

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

sheet

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

    更多

    Sheet类方法

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