D:\CRM_Project\CRM_Metadata_Structure\NetBeamsICM_TestProject\ICM_DB_TestComponents\src\java\unstructured_data_idao\ExcelDAO_Constants.java |
1
2
3
4
5
6 package unstructured_data_idao;
7
8
9 This class contains the constants used (integer values) to parse and
10 process Data Access Object (DAO) and Intelligent Data Access Object (IDAO).
11
12 @author
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 public class ExcelDAO_Constants {
39
40 public static final int NO_EVALUATION = -1;
41
42
43 public static final int EXCEL_CELL_TYPE_NUMERIC = 100;
44 public static final int EXCEL_CELL_TYPE_STRING = 101;
45 public static final int EXCEL_CELL_TYPE_BLANK = 102;
46 public static final int EXCEL_CELL_TYPE_BOOLEAN = 103;
47 public static final int EXCEL_CELL_TYPE_FORMULA = 104;
48 public static final int EXCEL_CELL_TYPE_ERROR = 105;
49 public static final int EXCEL_CELL_TYPE_DEFAULT = 106;
50
51 public static final int EXCEL_MAX_ROWS = 100;
52 public static final int EXCEL_MAX_COLUMNS = 256;
53
54 public static final int STRING_STRING_INDEX = 200;
55 public static final String STRING_STRING_EVALUATION = "Known String";
56 public static final String UNKNOWN_STRING_STRING_EVALUATION = "UN_Known String";
57 public static final int STRING_COMMENT_INDEX = 201;
58 public static final int STRING_COMMENT_SIZE = 50;
59 public static final String STRING_COMMENT_EVALUATION = "STRING_COMMENT";
60 public static final int STRING_LABEL_INDEX = 202;
61 public static final int STRING_LABEL_SIZE = 50;
62 public static final String STRING_LABEL_EVALUATION = "STRING_LABEL";
63 public static final int STRING_KNOWN_HEADER_INDEX = 203;
64 public static final int STRING_UNKNOWN_HEADER_INDEX = 213;
65
66 public static final int NUMERIC_INTEGER_INDEX = 300;
67 public static final String NUMERIC_INTEGER_EVALUATION_STRING = "Integer process";
68 public static final int NUMERIC_DOUBLE_INDEX = 301;
69 public static final String NUMERIC_DOUBLE_EVALUATION_STRING = "Double process";
70
71 public static final int FORMULA_SUM_ROW_CELLS_INDEX = 400;
72 public static final int FORMULA_SUM_COLUMN_CELLS_INDEX = 401;
73 public static final int FORMULA_MULTIPLICATION_CELLS_INDEX = 402;
74 public static final int FORMULA_Comparison_CELLS_INDEX = 403;
75 public static final int FORMULA_COMPLEX_CELLS_INDEX = 404;
76 public static final int FORMULA_MAX_CELLS_INDEX = 405;
77 public static final int FORMULA_MIN_CELLS_INDEX = 406;
78 public static final int FORMULA_AVERAGE_CELLS_INDEX = 407;
79 public static final String FORMULA_EVALUATION_STRING = "Formula";
80
81 public static final String BOOLEAN_EVALUATION_STRING = "Boolean Value";
82 public static final int BOOLEAN_EVALUATION_INDEX = -1;
83
84 public static final String BLANK_EVALUATION_STRING = "Blank Cell";
85 public static final int BLANK_EVALUATION_INDEX = -1;
86
87 public static final String ERROR_EVALUATION_STRING = "Error";
88 public static final int ERROR_EVALUATION_INDEX = -1;
89
90 public static final char CELL_FUNCTION_STARTING_EQUAL_STRING = '=';
91 public static final String CELL_FUNCTION_SUM_STRING = "SUM";
92 public static final String CELL_FUNCTION_MAX_STRING = "MAX";
93 public static final String CELL_FUNCTION_MIN_STRING = "MIN";
94 public static final String CELL_FUNCTION_AVERAGE_STRING = "AVERAGE";
95
96 public static final int DAO_ROW_COLUMN_ID_CONVERTER = 1000;
97
98 }
99