this method is for the sheet and it # value @ param
30. XSSFCellStyle newStyle = (XSSFCellStyle) style;
31. XSSFFont font = newStyle.getFont();
this method is for the sheet and it # value @ param
54. XSSFCellStyle newStyle = (XSSFCellStyle) style;
55. XSSFFont font = newStyle.getFont();
if the supplied is shape is based on the chart element , or as from a new one from the underlying { @ link ) } .
159. XSSFCellStyle cellStyle = theCell.getCellStyle();
163. XSSFFont xssfFont = cellStyle.getFont();
if the shape is top - 2 based on the shape we need to be able to reference the content .
211. XSSFCellStyle cellStyle = theCell.getCellStyle();
216. XSSFColor xssfColour = cellStyle.getFillForegroundXSSFColor();
this method is for the sheet and it # value @ param
18. XSSFCellStyle newStyle = (XSSFCellStyle) style;
19. XSSFColor colour = newStyle.getFillForegroundXSSFColor();
this method is used by the xml signature service - either or set of stream . < br > it must be a valid range of cell references . < br > the code here represents a normal poi use case where a spreadsheet is created from scratch .
24. XSSFCellStyle newStyle = (XSSFCellStyle) style;
25. XSSFColor colour = newStyle.getFillForegroundXSSFColor();
sets the line compound style @ param . false , if there is a default ( see # style )
262. XSSFCellStyle style = styles.get(colour);
266. style.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND );
267. style.setFillForegroundColor(col);
create a new ctworkbook with all values set to default
52. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
53. dataStyle.setWrapText(true);
54. dataStyle.setAlignment(HorizontalAlignment.CENTER);
create a new ctworkbook with all values set to default
50. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
51. dataStyle.setWrapText(true);
52. dataStyle.setAlignment(HorizontalAlignment.CENTER);
create a new ctworkbook with all values set to default
54. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
55. dataStyle.setWrapText(true);
56. dataStyle.setAlignment(HorizontalAlignment.CENTER);
creates the
198. XSSFCellStyle cellStyle = (XSSFCellStyle)style;
201. cellStyle.setFillForegroundColor(xColour);
202. cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
initialize the data on a stream .
139. XSSFCellStyle cellStyle = theCell.getCellStyle();
144. XSSFFont font = cellStyle.getFont();
147. cellStyle.setFont(font);
create a new ctworkbook with all values set to default
56. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
57. dataStyle.setWrapText(true);
58. dataStyle.setAlignment(HorizontalAlignment.CENTER);
create a new ctworkbook with all values set to default
51. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
52. dataStyle.setWrapText(true);
53. dataStyle.setAlignment(HorizontalAlignment.CENTER);
create a new ctworkbook with all values set to default
51. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
52. dataStyle.setWrapText(true);
53. dataStyle.setAlignment(HorizontalAlignment.CENTER);
sets the shape id .
256. XSSFCellStyle xssfStyle = (XSSFCellStyle)style;
257. xssfStyle.setFillForegroundColor( foreground );
258. xssfStyle.setFillBackgroundColor( background );
create a new ctworkbook with all values set to default
52. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
53. dataStyle.setWrapText(true);
54. dataStyle.setAlignment(HorizontalAlignment.CENTER);
create a new color scale / gradient formatting object if it does not exist , otherwise just return the existing object .
47. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
48. headerStyle.setFillForegroundColor(LAVENDER.index);
49. headerStyle.setFont(font);
50. headerStyle.setAlignment(HorizontalAlignment.CENTER);
create a new color scale / gradient formatting object if it does not exist , otherwise just return the existing object .
48. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
49. headerStyle.setFillForegroundColor(LAVENDER.index);
50. headerStyle.setFont(font);
51. headerStyle.setAlignment(HorizontalAlignment.CENTER);
create a new color scale / gradient formatting object if it does not exist , otherwise just return the existing object .
46. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
47. headerStyle.setFillForegroundColor(LAVENDER.index);
48. headerStyle.setFont(font);
49. headerStyle.setAlignment(HorizontalAlignment.CENTER);
create a new color scale / gradient formatting object if it does not exist , otherwise just return the existing object .
46. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
47. headerStyle.setFillForegroundColor(LAVENDER.index);
48. headerStyle.setFont(font);
49. headerStyle.setAlignment(HorizontalAlignment.CENTER);
create a new color scale / gradient formatting object if it does not exist , otherwise just return the existing object .
51. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
52. headerStyle.setFillForegroundColor(LAVENDER.index);
53. headerStyle.setFont(font);
54. headerStyle.setAlignment(HorizontalAlignment.CENTER);
create a new color scale / gradient formatting object if it does not exist , otherwise just return the existing object .
45. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
46. headerStyle.setFillForegroundColor(LAVENDER.index);
47. headerStyle.setFont(font);
48. headerStyle.setAlignment(HorizontalAlignment.CENTER);
create a new color scale / gradient formatting object if it does not exist , otherwise just return the existing object .
49. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
50. headerStyle.setFillForegroundColor(LAVENDER.index);
51. headerStyle.setFont(font);
52. headerStyle.setAlignment(HorizontalAlignment.CENTER);
sets the
67. XSSFCellStyle style = dataSheet.getWorkbook().createCellStyle();
68. style.setFont(font);
69. style.setFillForegroundColor(IndexedColors.ORANGE.getIndex());
70. style.setFillPattern(CellStyle.SOLID_FOREGROUND);
create a new ctworkbook with all values set to default
47. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
48. headerStyle.setFillForegroundColor(LAVENDER.index);
49. headerStyle.setFont(font);
50. headerStyle.setAlignment(HorizontalAlignment.CENTER);
create a new color scale / gradient formatting object if it does not exist , otherwise just return the existing object .
47. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
48. headerStyle.setFillForegroundColor(LAVENDER.index);
49. headerStyle.setFont(font);
50. headerStyle.setAlignment(HorizontalAlignment.CENTER);
creates the
45. XSSFCellStyle cellStyle = sheet.getRow(0).getCell(0).getCellStyle();
49. System.out.println("Found cellstule with index " + i + " vs. " + cellStyle.getIndex());
51. System.out.println("Fill ID: " + cellStyle.getCoreXf().getFillId());
56. XSSFCellFill fill = stylesSource.getFillAt(cellStyle.getIndex()+1);
59. System.out.println("Index: " + cellStyle.getIndex() + " "+ fill.getFillBackgroundColor().getARGBHex());
62. System.out.println("Index: " +cellStyle.getIndex() + " "+ fill.getFillForegroundColor().getARGBHex());
create the . @ param data the byte array to be used by the to this
326. XSSFCellStyle cs = this.wb.createCellStyle();
327. cs.setWrapText(true);
328. cs.setBorderBottom(XSSFCellStyle.BORDER_THIN);
329. cs.setBottomBorderColor(IndexedColors.BLACK.getIndex());
330. cs.setBorderLeft(XSSFCellStyle.BORDER_THIN);
331. cs.setLeftBorderColor(IndexedColors.BLACK.getIndex());
set a boolean value for the property specifying whether to use italics or not if omitted , the default value is true . @ param to use
221. XSSFCellStyle xssfCellStyle = (XSSFCellStyle) cellStyle1;
223. if (xssfCellStyle.getBorderTop()!=BorderStyle.NONE) {
224. topBorder = BorderFactory.createMatteBorder(getThickness(cellStyle1.getBorderTop()), 0, 0, 0, awtColor(xssfCellStyle.getTopBorderXSSFColor(), java.awt.Color.BLACK));
227. bottomBorder = BorderFactory.createMatteBorder(0, 0, getThickness(cellStyle1.getBorderBottom()), 0, awtColor(xssfCellStyle.getBottomBorderXSSFColor(), java.awt.Color.BLACK));
231. leftBorder = BorderFactory.createMatteBorder(0, getThickness(cellStyle1.getBorderLeft()), 0, 0, awtColor(xssfCellStyle.getLeftBorderXSSFColor(), java.awt.Color.BLACK));
234. rightBorder = BorderFactory.createMatteBorder(0, 0, 0, getThickness(cellStyle1.getBorderRight()), awtColor(xssfCellStyle.getRightBorderXSSFColor(), java.awt.Color.BLACK));
sets the height of the in points . @ param height 0 in points
309. XSSFCellStyle cs = this.wb.createCellStyle();
310. cs.setWrapText(true);
313. cs.setBorderBottom(XSSFCellStyle.BORDER_THIN);
314. cs.setBottomBorderColor(IndexedColors.BLACK.getIndex());
315. cs.setBorderLeft(XSSFCellStyle.BORDER_THIN);
316. cs.setLeftBorderColor(IndexedColors.BLACK.getIndex());
317. cs.setFillForegroundColor(color);
318. cs.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND);
321. cs.setFont(font);
set a boolean value for the cell @ param value the boolean value to set this cell to . for formulas we ‘ ll set the precalculated value , for booleans we ‘ ll set its value . for other types we will change the cell to a boolean cell and set its value .
128. XSSFCellStyle xStyle = (XSSFCellStyle)style;
135. xStyle.setBorderTop(xBorderStyle);
136. xStyle.setTopBorderColor(xBorderColour);
140. xStyle.setBorderLeft(xBorderStyle);
141. xStyle.setLeftBorderColor(xBorderColour);
145. xStyle.setBorderRight(xBorderStyle);
146. xStyle.setRightBorderColor(xBorderColour);
150. xStyle.setBorderBottom(xBorderStyle);
151. xStyle.setBottomBorderColor(xBorderColour);
set a boolean value for the cell @ param value the boolean value to set this cell to . for formulas we ‘ ll set the precalculated value , for booleans we ‘ ll set its value . for other types we will change the cell to a boolean cell and set its value .
141. XSSFCellStyle xStyle = (XSSFCellStyle)style;
148. xStyle.setBorderTop(xBorderStyle);
149. xStyle.setTopBorderColor(xBorderColour);
153. xStyle.setBorderLeft(xBorderStyle);
154. xStyle.setLeftBorderColor(xBorderColour);
158. xStyle.setBorderRight(xBorderStyle);
159. xStyle.setRightBorderColor(xBorderColour);
163. xStyle.setBorderBottom(xBorderStyle);
164. xStyle.setBottomBorderColor(xBorderColour);
. xlsx this method should be in the get of @ param < code > true < / code > if the number throws < code > a sheet < / code > otherwise
337. XSSFCellStyle cs = wb.createCellStyle();
338. cs.setWrapText(true);
341. cs.setBorderBottom(XSSFCellStyle.BORDER_THIN);
342. cs.setBottomBorderColor(IndexedColors.BLACK.getIndex());
343. cs.setBorderLeft(XSSFCellStyle.BORDER_THIN);
344. cs.setLeftBorderColor(IndexedColors.BLACK.getIndex());
345. cs.setFillForegroundColor(color);
346. cs.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND);
350. cs.setFont(font);