Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.Workbook.createCellStyle()

103
104
105
106
107
108
109
110
111
112
113
    Font font = wb.createFont();
    font.setBoldweight(Font.BOLDWEIGHT_BOLD);  
//-------------------------------sheet1-----------------------------------------------------   
    Row firstrow = sheet1.createRow((short) 0); 
    CellStyle firstrow_style = wb.createCellStyle();
    firstrow_style.setFillForegroundColor(IndexedColors.LIGHT_CORNFLOWER_BLUE.getIndex());
    firstrow_style.setFillPattern(CellStyle.SOLID_FOREGROUND);
    firstrow_style.setFont(font);
   
    //Border for first row
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
    Cell firstRowCell1 = firstrow.createCell((short) 1);
    firstRowCell1.setCellValue("Count");
    firstRowCell1.setCellStyle(firstrow_style);
   
    //Border for row
    CellStyle row_style = wb.createCellStyle();
    row_style.setBorderBottom( CellStyle.BORDER_THIN );
    row_style.setBorderLeft( CellStyle.BORDER_THIN );
    row_style.setBorderRight( CellStyle.BORDER_THIN );
    row_style.setBorderTop( CellStyle.BORDER_THIN );
    row_style.setBorderLeft( CellStyle.BORDER_THIN );
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
    Font font = wb.createFont();
    font.setBoldweight(Font.BOLDWEIGHT_BOLD);  
//-------------------------------sheet1-----------------------------------------------------   
    Row firstrow = sheet1.createRow((short) 0); 
    CellStyle firstrow_style = wb.createCellStyle();
    firstrow_style.setFillForegroundColor(IndexedColors.LIGHT_CORNFLOWER_BLUE.getIndex());
    firstrow_style.setFillPattern(CellStyle.SOLID_FOREGROUND);
    firstrow_style.setFont(font);
   
    //Border for first row
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
    Cell firstRowCell1 = firstrow.createCell((short) 1);
    firstRowCell1.setCellValue("Count");
    firstRowCell1.setCellStyle(firstrow_style);
   
    //Border for row
    CellStyle row_style = wb.createCellStyle();
    row_style.setBorderBottom( CellStyle.BORDER_THIN );
    row_style.setBorderLeft( CellStyle.BORDER_THIN );
    row_style.setBorderRight( CellStyle.BORDER_THIN );
    row_style.setBorderTop( CellStyle.BORDER_THIN );
    row_style.setBorderLeft( CellStyle.BORDER_THIN );
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
      // Create a cell and put a value in it.
      Cell cell = row.createCell(1);
      cell.setCellValue(4);

      // Style the cell with borders all around.
      CellStyle style = wb.createCellStyle();
      style.setBorderBottom(CellStyle.BORDER_THIN);
      style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
     
      style.setBorderLeft(CellStyle.BORDER_THIN);
      style.setLeftBorderColor(IndexedColors.GREEN.getIndex());
View Full Code Here
19
20
21
22
23
24
25
26
27
28
29
      // Create a row and put some cells in it. Rows are 0 based.
      Row row = sheet.createRow((short) 1);

      // Aqua background
      CellStyle style = wb.createCellStyle();
      style.setFillBackgroundColor(IndexedColors.AQUA.getIndex());
      style.setFillPattern(CellStyle.BIG_SPOTS);
      Cell cell = row.createCell((short) 1);
      cell.setCellValue("X");
      cell.setCellStyle(style);
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
      Cell cell = row.createCell((short) 1);
      cell.setCellValue("X");
      cell.setCellStyle(style);

      // Orange "foreground", foreground being the fill foreground not the font color.
      style = wb.createCellStyle();
      style.setFillForegroundColor(IndexedColors.ORANGE.getIndex());
      style.setFillPattern(CellStyle.SOLID_FOREGROUND);
      cell = row.createCell((short) 2);
      cell.setCellValue("X");
      cell.setCellStyle(style);
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
      font.setFontName("Courier New");
      font.setItalic(true);
      font.setStrikeout(true);

      // Fonts are set into a style so create a new one to use.
      CellStyle style = wb.createCellStyle();
      style.setFont(font);

      // Create a cell and put a value in it.
      Cell cell = row.createCell(1);
      cell.setCellValue("This is a test of fonts");
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
      font.setFontHeightInPoints((short)24);
      font.setFontName(FONT_TYPE);
      font.setColor(FONT_COLOR_TITLE);

      /***  Header *****/
      CellStyle style = wb.createCellStyle();
      style.setFont(font);
      style.setAlignment(CellStyle.ALIGN_CENTER);
      style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
      style.setFillForegroundColor(BACKGROUND_COLOR);      

View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
      font = wb.createFont();
      font.setFontHeightInPoints((short)12);
      font.setFontName(FONT_TYPE);
      font.setColor(FONT_COLOR);
     
      style = wb.createCellStyle();
      style.setFont(font);
     
      rowNum =  rowNum + 3;
     List<Account> accounts = accountManager.getAllAccounts();
     for (Account account : accounts) {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.