本文整理汇总了Java中org.apache.poi.ss.util.RegionUtil.setBorderLeft方法的典型用法代码示例。如果您正苦于以下问题：Java RegionUtil.setBorderLeft方法的具体用法？Java RegionUtil.setBorderLeft怎么用？Java RegionUtil.setBorderLeft使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.poi.ss.util.RegionUtil的用法示例。
在下文中一共展示了RegionUtil.setBorderLeft方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: setRegionBorder
import org.apache.poi.ss.util.RegionUtil; //导入方法依赖的package包/类
/**
* 获取合并单元格式
*
* @param sheet
* @param row
* @param columnFrom
* @param columnTo
* @return
*/
private static void setRegionBorder(HSSFSheet sheet, int row, int columnFrom, int columnTo) {
CellRangeAddress region = new CellRangeAddress(row, row, columnFrom, columnTo);
sheet.addMergedRegion(region);
final short border = CellStyle.BORDER_THIN;
HSSFWorkbook wb = sheet.getWorkbook();
RegionUtil.setBorderBottom(border, region, sheet, wb);
RegionUtil.setBorderTop(border, region, sheet, wb);
RegionUtil.setBorderLeft(border, region, sheet, wb);
RegionUtil.setBorderRight(border, region, sheet, wb);
RegionUtil.setBottomBorderColor(HSSFColor.BLACK.index, region, sheet, wb);
RegionUtil.setTopBorderColor(HSSFColor.BLACK.index, region, sheet, wb);
RegionUtil.setLeftBorderColor(HSSFColor.BLACK.index, region, sheet, wb);
RegionUtil.setRightBorderColor(HSSFColor.BLACK.index, region, sheet, wb);
}
示例2: setCellRangeAddressBorder
import org.apache.poi.ss.util.RegionUtil; //导入方法依赖的package包/类
private void setCellRangeAddressBorder(CellRangeAddress rangle, Sheet sheet) {
int border = 1;
Workbook wb = sheet.getWorkbook();
RegionUtil.setBorderBottom(border, rangle, sheet, wb);
RegionUtil.setBorderLeft(border, rangle, sheet, wb);
RegionUtil.setBorderRight(border, rangle, sheet, wb);
RegionUtil.setBorderTop(border, rangle, sheet, wb);
}
示例3: border
import org.apache.poi.ss.util.RegionUtil; //导入方法依赖的package包/类
/**
* Border 설정.
* @작성자 : KYJ
* @작성일 : 2016. 9. 8.
* @param region
* @param sheet
*/
static void border(CellRangeAddress region, Sheet sheet) {
Workbook wb = sheet.getWorkbook();
// sheet.addMergedRegion(region);
final short borderMediumDashed = CellStyle.BORDER_THIN;
RegionUtil.setBorderBottom(borderMediumDashed, region, sheet, wb);
RegionUtil.setBorderTop(borderMediumDashed, region, sheet, wb);
RegionUtil.setBorderLeft(borderMediumDashed, region, sheet, wb);
RegionUtil.setBorderRight(borderMediumDashed, region, sheet, wb);
}
示例4: addRegions
import org.apache.poi.ss.util.RegionUtil; //导入方法依赖的package包/类
private void addRegions(XSSFSheet xlsSheet, List<XlsxRegion> regions, XSSFWorkbook wb ) {
for (int r = 0, size = regions.size(); r < size; r++) {
XlsxRegion xlsRegion = regions.get(r);
CellRangeAddress region = xlsRegion.getCellRangeAddress();
Border border = xlsRegion.getBorder();
xlsSheet.addMergedRegion(region);
try {
if (border != null) {
short xlsBottomBorder = getXlsBorderValue(border.getBottom());
if (xlsBottomBorder > 0) {
RegionUtil.setBorderBottom(xlsBottomBorder, region, xlsSheet, wb);
RegionUtil.setBottomBorderColor(ExcelColorSupport.getNearestColor(border.getBottomColor()),
region, xlsSheet, wb);
}
short xlsTopBorder = getXlsBorderValue(border.getTop());
if (xlsTopBorder > 0) {
RegionUtil.setBorderTop(xlsTopBorder,region, xlsSheet, wb);
RegionUtil.setTopBorderColor(ExcelColorSupport.getNearestColor(border.getTopColor()),
region, xlsSheet, wb);
}
short xlsLeftBorder = getXlsBorderValue(border.getLeft());
if (xlsLeftBorder > 0) {
RegionUtil.setBorderLeft(xlsLeftBorder, region, xlsSheet, wb);
RegionUtil.setLeftBorderColor(ExcelColorSupport.getNearestColor(border.getLeftColor()),
region, xlsSheet, wb);
}
short xlsRightBorder = getXlsBorderValue(border.getRight());
if (xlsRightBorder > 0) {
RegionUtil.setBorderRight(xlsRightBorder, region, xlsSheet, wb);
RegionUtil.setRightBorderColor(ExcelColorSupport.getNearestColor(border.getRightColor()),
region, xlsSheet, wb);
}
}
} catch (Throwable t) {
// report with subreport and borders crashes in XSSF poi
// just log the error and let the report be generated (for now)
LOG.error(t.getMessage(), t);
}
}
regions.clear();
}