sir, you suggested me to use setColExcelTypes and setRowExcelTypes in changing the type of rows and cells on the fly. However, I am only using a trial version. Are there any alternatives for it?
The next will work simlar to setRowExcelTypes, and can be applied in standard version
where ID - ID of row
TYPE - excell type
setting _cellType property change type of editor, two other lines reset value of cell, so it will be correctly formatted.