Uses of Class
org.openxava.util.jxls.JxlsStyle
-
Packages that use JxlsStyle Package Description org.openxava.util.jxls -
-
Uses of JxlsStyle in org.openxava.util.jxls
Fields in org.openxava.util.jxls with type parameters of type JxlsStyle Modifier and Type Field Description protected java.util.Map<java.lang.String,JxlsStyle>
JxlsWorkbook. styles
Methods in org.openxava.util.jxls that return JxlsStyle Modifier and Type Method Description JxlsStyle
JxlsWorkbook. addClonedStyle(java.lang.String name, JxlsStyle style)
Creates a JxlsStyle based upon another existing JxlsStyle which can be referenced when using sheet.setValue(column, row, value, style)JxlsStyle
JxlsWorkbook. addClonedStyle(JxlsStyle style)
JxlsStyle
JxlsWorkbook. addStyle(int type)
JxlsStyle
JxlsWorkbook. addStyle(java.lang.String format)
JxlsStyle
JxlsWorkbook. addStyle(java.lang.String name, int type)
Creates a JxlsStyle which can be referenced when using sheet.setValue(column, row, value, style)JxlsStyle
JxlsWorkbook. addStyle(java.lang.String name, java.lang.String format)
Creates a JxlsStyle which can be referenced when using sheet.setValue(column, row, value, style)protected JxlsStyle
JxlsStyle. clone(JxlsWorkbook workbook, java.lang.String name)
JxlsStyle
JxlsWorkbook. getDefaultDateStyle()
JxlsStyle
JxlsWorkbook. getDefaultFloatStyle()
JxlsStyle
JxlsWorkbook. getDefaultStyle()
JxlsStyle
JxlsCell. getStyle()
JxlsStyle
JxlsWorkbook. getStyle(java.lang.String name)
JxlsStyle
JxlsStyle. setAlign(short align)
Sets the justification to use to render the content of the cellJxlsStyle
JxlsStyle. setBold()
Make the cell using this style boldJxlsStyle
JxlsStyle. setBold(boolean isBold)
Make the cell using this style bold or notJxlsStyle
JxlsStyle. setBorder(short place, short borderStyle)
Sets the borders for some of the sides of the cellJxlsStyle
JxlsStyle. setBorderColor(short borderColor)
Sets the border color for the 4 sides of the cellJxlsStyle
JxlsStyle. setBorders(short top, short bottom, short left, short right)
Sets the borders for the 4 sides of the cellJxlsStyle
JxlsStyle. setCellColor(short bgColor)
Sets the color to use to render the background of the cellJxlsStyle
JxlsStyle. setFontName(java.lang.String fontName)
Sets the font name to use in this styleJxlsStyle
JxlsStyle. setFontSize(int fontSize)
Sets the font size to use in this styleJxlsStyle
JxlsStyle. setFormat(java.lang.String format)
Sets the format to use to display numbers using this styleJxlsStyle
JxlsStyle. setTextColor(short textColor)
Sets the color to use to render the writing of the cellJxlsStyle
JxlsStyle. setWrap(boolean wraps)
Make the cell wraps its contentMethods in org.openxava.util.jxls with parameters of type JxlsStyle Modifier and Type Method Description JxlsStyle
JxlsWorkbook. addClonedStyle(java.lang.String name, JxlsStyle style)
Creates a JxlsStyle based upon another existing JxlsStyle which can be referenced when using sheet.setValue(column, row, value, style)JxlsStyle
JxlsWorkbook. addClonedStyle(JxlsStyle style)
JxlsSheet
JxlsSheet. setColumnStyles(int column, JxlsStyle... styles)
Sets the width of one or more columnsJxlsCell
JxlsSheet. setFormula(int column, int row, java.lang.String formula, JxlsStyle style)
Sets the formula at column,rowsheet.setFormula(1, 1, "=A1+$A2+$R1C3+R1$C4");
void
JxlsSheet. setHeaders(int startColumn, int row, JxlsStyle style, java.lang.String... headers)
Sets column headers Usage:// set the first column header as "Invoice" with style // do not set any header for the second column // set the third column as "Customer" with style and a width of 20 // set the fourth column as "Customer" with style, right alignment and a width of 10 setHeaders(1, 1, style, "Invoice", null, "Customer|20", "Cost|r", "Margin|r|10");
JxlsCell
JxlsCell. setStyle(JxlsStyle style)
Sets the style of the cellJxlsCell
JxlsSheet. setValue(int column, int row, java.lang.Object value, JxlsStyle style)
Sets the value at column,rowMethod parameters in org.openxava.util.jxls with type arguments of type JxlsStyle Modifier and Type Method Description protected void
JxlsCell. createPOICell(JxlsWorkbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, java.util.Map<java.lang.Integer,JxlsStyle> columnStyles)
Constructors in org.openxava.util.jxls with parameters of type JxlsStyle Constructor Description JxlsCell(JxlsSheet sheet, int column, int row, double f, JxlsStyle style)
JxlsCell(JxlsSheet sheet, int column, int row, java.lang.String text, JxlsStyle style, boolean isFormula)
JxlsCell(JxlsSheet sheet, int column, int row, java.util.Date date, JxlsStyle style)
JxlsCell(JxlsSheet sheet, int column, int row, JxlsStyle style)
-