Converting text into numeric in xls using Java
- by Work World
When I create excel sheet through java ,the column which has number datatype in the oracle table, get converted to text format in excel.I want it to remain in the number format.Below is my code snippet for excel creation.
FileWriter fw = new FileWriter(tempFile.getAbsoluteFile(),true);
// BufferedWriter bw = new BufferedWriter(fw);
…