程序包 com.publiccms.common.tools

类 XSSFWorkbookUtils

java.lang.Object

com.publiccms.common.tools.XSSFWorkbookUtils

public class XSSFWorkbookUtils
extends Object

字段概要

字段

修饰符和类型	字段	说明
(专用程序包) static String[]	borderStyles
(专用程序包) static String[]	bordesr

构造器概要

构造器

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

方法概要

修饰符和类型	方法	说明
private static String	convertAlignToHtml(org.apache.poi.ss.usermodel.HorizontalAlignment alignment)	单元格内容的水平对齐方式 331
private static 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, StringBuilder sb)	处理表格样式
private static String	getBorderStyle(int b, short s, org.apache.poi.xssf.usermodel.XSSFColor xc)
static String	getCellValue(org.apache.poi.ss.usermodel.Cell cell)	获取表格单元格Cell内容
static 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 String[] bordesr

borderStyles

static String[] borderStyles

构造器详细资料

XSSFWorkbookUtils

private XSSFWorkbookUtils()

方法详细资料

workbookToHtml

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

getCellValue

public static String getCellValue(org.apache.poi.ss.usermodel.Cell cell)

获取表格单元格Cell内容

参数:

cell -

返回:

dealExcelStyle

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

处理表格样式

convertAlignToHtml

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

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

convertVerticalAlignToHtml

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

getBorderStyle

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