I have an excel template where I set the data type using the Format->Cells feature of excel. Based on that I want to decide the setValue for the cell while populating it with data. Ideally, the template should be able to drive the type of the data that has to appear in the final excel sheet (populated with data).
But when I do a getValue on the cells, which are empty but with the data types set (as mentioned above), I always get 0!
Due to this I cannot decide the datatype in setValue(datatype) while I am populating the template with data (from an xml)!
What am I doing wrong here?