Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.CellStyle

157
158
159
160
161
162
163
164
165
166
167
168
                value = null;
              }
            }
            else if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC)
            {
              final CellStyle hssfCellStyle = cell.getCellStyle();
              if (isDateFormat(hssfCellStyle.getDataFormat(), hssfCellStyle.getDataFormatString()))
              {
                value = cell.getDateCellValue();
              }
              else
              {
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
   *@param propertyValue The value of the property that is to be changed.
   *@param cell The cell that needs it's style changes
   */
  public static void setCellStyleProperty(Cell cell, Workbook workbook, String propertyName,
      Object propertyValue) {
    CellStyle originalStyle = cell.getCellStyle();
    CellStyle newStyle = null;
    Map<String, Object> values = getFormatProperties(originalStyle);
    values.put(propertyName, propertyValue);

    // index seems like what index the cellstyle is in the list of styles for a workbook.
    // not good to compare on!
    short numberCellStyles = workbook.getNumCellStyles();

    for (short i = 0; i < numberCellStyles; i++) {
      CellStyle wbStyle = workbook.getCellStyleAt(i);
      Map<String, Object> wbStyleMap = getFormatProperties(wbStyle);

      if (wbStyleMap.equals(values)) {
        newStyle = wbStyle;
        break;
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
165
            _rowContainedNullCells = true;
            return;
        }
        String ref = new CellReference(_rownum, columnIndex).formatAsString();
        _out.write("<c r=\"" + ref + "\"");
        CellStyle cellStyle = cell.getCellStyle();
        if (cellStyle.getIndex() != 0) _out.write(" s=\"" + cellStyle.getIndex() + "\"");
        int cellType = cell.getCellType();
        switch (cellType) {
            case Cell.CELL_TYPE_BLANK: {
                _out.write(">");
                break;
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
173
            _rowContainedNullCells = true;
            return;
        }
        String ref = new CellReference(_rownum, columnIndex).formatAsString();
        _out.write("<c r=\"" + ref + "\"");
        CellStyle cellStyle = cell.getCellStyle();
        if (cellStyle.getIndex() != 0) _out.write(" s=\"" + cellStyle.getIndex() + "\"");
        int cellType = cell.getCellType();
        switch (cellType) {
            case Cell.CELL_TYPE_BLANK: {
                _out.write(">");
                break;
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
        if (type == Cell.CELL_TYPE_FORMULA) {
            type = cell.getCachedFormulaResultType();
        }

        if (type == Cell.CELL_TYPE_NUMERIC) {
            CellStyle cs = cell.getCellStyle();

            if (cs.getDataFormatString() != null) {
                text.append(formatter.formatRawCellContents(
                        cell.getNumericCellValue(), cs.getDataFormat(), cs.getDataFormatString()
                        ));
                return;
            }
        }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
138
139
      sheet.createRow(i);
    }
  }

  private int buildDataMatrix(Sheet sheet, JSONArray data, int rowOffset, int columnOffset, CreationHelper createHelper) throws JSONException {
    CellStyle cellStyle = buildDataCellStyle(sheet);
    CellStyle sumCellStyle = buildDataCellStyle(sheet);
    sumCellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
   
    int endRowNum = 0;
    for (int i = 0; i < data.length(); i++) {
      JSONArray array = (JSONArray) data.get(i);
      for (int j = 0; j < array.length(); j++) {
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
   * @throws JSONException
   */
  private void buildRowsHeaders(Sheet sheet, JSONArray siblings, int rowNum, int columnNum, CreationHelper createHelper) throws JSONException {
    int rowsCounter = rowNum;
   
    CellStyle cellStyle = buildHeaderCellStyle(sheet);
       
    for (int i = 0; i < siblings.length(); i++) {
      JSONObject aNode = (JSONObject) siblings.get(i);
      Row row = sheet.getRow(rowsCounter);
      Cell cell = row.createCell(columnNum);
View Full Code Here
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
   
  }


  public CellStyle buildHeaderCellStyle(Sheet sheet){
    CellStyle cellStyle = sheet.getWorkbook().createCellStyle();
        cellStyle.setAlignment(CellStyle.ALIGN_LEFT);
        cellStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER); 
        cellStyle.setFillForegroundColor(IndexedColors.AQUA.getIndex());
        cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
        cellStyle.setBorderBottom(CellStyle.BORDER_THIN);
        cellStyle.setBorderLeft(CellStyle.BORDER_THIN);
        cellStyle.setBorderRight(CellStyle.BORDER_THIN);
        cellStyle.setBorderTop(CellStyle.BORDER_THIN);
        cellStyle.setLeftBorderColor(IndexedColors.DARK_BLUE.getIndex());
        cellStyle.setRightBorderColor(IndexedColors.DARK_BLUE.getIndex());
        cellStyle.setBottomBorderColor(IndexedColors.DARK_BLUE.getIndex());
        cellStyle.setTopBorderColor(IndexedColors.DARK_BLUE.getIndex());
        Font font = sheet.getWorkbook().createFont();
        font.setFontHeightInPoints((short)14);
        font.setFontName("Arial");
        font.setColor(IndexedColors.DARK_BLUE.getIndex());
        font.setBoldweight(Font.BOLDWEIGHT_BOLD);
        cellStyle.setFont(font);
        return cellStyle;
  }
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
        cellStyle.setFont(font);
        return cellStyle;
  }
 
  public CellStyle buildDataCellStyle(Sheet sheet){
    CellStyle cellStyle = sheet.getWorkbook().createCellStyle();
        cellStyle.setAlignment(CellStyle.ALIGN_RIGHT);
        cellStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
        cellStyle.setFillForegroundColor(IndexedColors.WHITE.getIndex());
        cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);   
        cellStyle.setBorderBottom(CellStyle.BORDER_THIN);
        cellStyle.setBorderLeft(CellStyle.BORDER_THIN);
        cellStyle.setBorderRight(CellStyle.BORDER_THIN);
        cellStyle.setBorderTop(CellStyle.BORDER_THIN);
        cellStyle.setLeftBorderColor(IndexedColors.BLUE.getIndex());
        cellStyle.setRightBorderColor(IndexedColors.BLUE.getIndex());
        cellStyle.setBottomBorderColor(IndexedColors.BLUE.getIndex());
        cellStyle.setTopBorderColor(IndexedColors.BLUE.getIndex());
        Font font = sheet.getWorkbook().createFont();
        font.setFontHeightInPoints((short)12);
        font.setFontName("Arial");
        font.setColor(IndexedColors.BLACK.getIndex());
        cellStyle.setFont(font);
        return cellStyle;
  }
View Full Code Here
296
297
298
299
300
301
302
303
304
305
306
   * @param createHelper The file creation helper
   * @throws JSONException
   */
  private void buildColumnsHeader(Sheet sheet, JSONArray siblings, int rowNum, int columnNum, CreationHelper createHelper) throws JSONException {
    int columnCounter = columnNum;
    CellStyle cellStyle = buildHeaderCellStyle(sheet);
    for (int i = 0; i < siblings.length(); i++) {
      JSONObject aNode = (JSONObject) siblings.get(i);
      Row row = sheet.getRow(rowNum);
      Cell cell = row.createCell(columnCounter);
      String text = (String) aNode.get(CrossTab.CROSSTAB_NODE_JSON_KEY);
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.usermodel.CellStyle

  • accounts.web.ReportPoiController
  • accounts.web.ReportPoiControllerTest
  • bad.robot.excel.cell.DataFormat
  • bad.robot.excel.matchers.StubCell
  • bad.robot.excel.style.ClonedStyleFactory
  • bad.robot.excel.style.ReplaceExistingStyle
  • br.com.objectos.way.io.POICell
  • br.com.objectos.way.io.POIWorkbook
  • br.com.objectos.way.io.TableStyle
  • br.com.objectos.way.io.WayIO
    • Copyright © 2018 www.massapicom. 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.