com.publiccms.common.tools

类 XSSFWorkbookUtils

java.lang.Object

com.publiccms.common.tools.XSSFWorkbookUtils

public class XSSFWorkbookUtils
extends java.lang.Object

字段概要

字段

限定符和类型	字段和说明
(专用程序包) static java.lang.String[]	borderStyles
(专用程序包) static java.lang.String[]	bordesr

构造器概要

构造器

限定符	构造器和说明
private	XSSFWorkbookUtils()

方法概要

限定符和类型	方法和说明
private static java.lang.String	convertAlignToHtml(org.apache.poi.ss.usermodel.HorizontalAlignment alignment) 单元格内容的水平对齐方式 331
private static java.lang.String	convertVerticalAlignToHtml(org.apache.poi.ss.usermodel.VerticalAlignment verticalAlignment)
private static void	dealExcelStyle(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Cell cell, java.lang.StringBuilder sb) 处理表格样式
private static java.lang.String	getBorderStyle(int b, short s, org.apache.poi.xssf.usermodel.XSSFColor xc)
private static java.lang.String	getCellValue(org.apache.poi.ss.usermodel.Cell cell) 获取表格单元格Cell内容
static java.lang.String	workbookToHtml(org.apache.poi.ss.usermodel.Workbook wb)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

bordesr

static java.lang.String[] bordesr

borderStyles

static java.lang.String[] borderStyles

构造器详细资料

XSSFWorkbookUtils

private XSSFWorkbookUtils()

方法详细资料

workbookToHtml

public static java.lang.String workbookToHtml(org.apache.poi.ss.usermodel.Workbook wb)

getCellValue

private static java.lang.String getCellValue(org.apache.poi.ss.usermodel.Cell cell)

获取表格单元格Cell内容

dealExcelStyle

private static void dealExcelStyle(org.apache.poi.ss.usermodel.Sheet sheet,
                                   org.apache.poi.ss.usermodel.Cell cell,
                                   java.lang.StringBuilder sb)

处理表格样式

convertAlignToHtml

private static java.lang.String convertAlignToHtml(org.apache.poi.ss.usermodel.HorizontalAlignment alignment)

单元格内容的水平对齐方式 331

convertVerticalAlignToHtml

private static java.lang.String convertVerticalAlignToHtml(org.apache.poi.ss.usermodel.VerticalAlignment verticalAlignment)

getBorderStyle

private static java.lang.String getBorderStyle(int b,
                                               short s,
                                               org.apache.poi.xssf.usermodel.XSSFColor xc)