1 16 17 package org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements; 18 19 import org.apache.poi.hssf.usermodel.HSSFCell; 20 21 27 public class CellType { 28 29 30 public static final int CELL_TYPE_FORMULA = -1; 31 public static final int CELL_TYPE_EMPTY = 10; 32 public static final int CELL_TYPE_BOOLEAN = 20; 33 public static final int CELL_TYPE_INTEGER = 30; 34 public static final int CELL_TYPE_FLOAT = 40; 35 public static final int CELL_TYPE_ERROR = 50; 36 public static final int CELL_TYPE_STRING = 60; 37 public static final int CELL_TYPE_CELLRANGE = 70; 38 public static final int CELL_TYPE_ARRAY = 80; 39 40 private CellType() { 41 } 42 43 49 public static boolean isValid(final int val) { 50 switch (val) { 51 case CELL_TYPE_EMPTY : 52 case CELL_TYPE_BOOLEAN : 53 case CELL_TYPE_INTEGER : 54 case CELL_TYPE_FLOAT : 55 case CELL_TYPE_ERROR : 56 case CELL_TYPE_STRING : 57 case CELL_TYPE_FORMULA : 58 case CELL_TYPE_CELLRANGE : 59 case CELL_TYPE_ARRAY : 60 return true; 61 default : 62 return false; 63 } 64 } 65 66 72 static int convertCellType(final int val) { 73 switch (val) { 74 case CELL_TYPE_INTEGER : 75 case CELL_TYPE_FLOAT : 76 return HSSFCell.CELL_TYPE_NUMERIC; 77 case CELL_TYPE_STRING : 78 return HSSFCell.CELL_TYPE_STRING; 79 case CELL_TYPE_FORMULA : 80 return HSSFCell.CELL_TYPE_FORMULA; 81 default : 82 return HSSFCell.CELL_TYPE_BLANK; 83 } 84 } 85 } | Popular Tags |