Hi,
Please find the attached sample class and Excel file.
Scenario :
a. All the excel worksheets are generated from a same template excel worksheet.
b. The value set to cell is always a String type of value.
Issues :
For non calculated cell (B5)
[Note : Value of B5 is same in all worksheets and is 200511]
The CellValueType is not same in all the worksheets, though the worksheets are created from same template worksheetFor calculated cell (E6)
Cell Value Type for [Sheet : RDN7][Cell : B5] is DOUBLE
Cell Value Type for [Sheet : RDN9][Cell : B5] is DOUBLE
Cell Value Type for [Sheet : RDN11][Cell : B5] is INT
Cell Value Type for [Sheet : RDN12][Cell : B5] is INT
Cell Value Type for [Sheet : RDN13][Cell : B5] is DOUBLE
E6 is been evaluated from formula.
cell.getValueType() is returning NULL.
Cell Value Type for [Sheet : RDN7][Cell : E6] is NULL
Cell Value Type for [Sheet : RDN9][Cell : E6] is NULL
Cell Value Type for [Sheet : RDN11][Cell : E6] is NULL
Cell Value Type for [Sheet : RDN12][Cell : E6] is NULL
Cell Value Type for [Sheet : RDN13][Cell : E6] is NULL
I am summing up the same cells from all the worksheets to generate AggregationWorksheet.
I am processing these cells based on the CellValueType and I am getting ClassCastException due to first issue and Null value due to second issue.
Note : I dont want to apply the formula for aggregating the cell due to performance issues.
Quick reply is appreciated.
Thank You.
Kailas