We are using a template file and a CSV (created at runtime through another application) to create a workbook then a full Excel file using Aspose Cells library. Our CSV has different columns that may or may not be present at runtime, which means that the columns in the output file are not known in advance when developing. A groovy/java code works for the most part, except for columns displaying contract numbers. The code ise based on the documentation and use TxtLoadOptions class.
TxtLoadOptions options = new TxtLoadOptions(LoadFormat.CSV);
sheet.getCells().importCSV(is, options, currentRowNum, 0);
These numbers who have a length between 10 and 15 are in this format : 1234567891234 and they are displayed in scientific notation, which is an unwanted behavior.
Creating a custom parser like explained here Excel is automatically converting a numeric value to scientific notation does not seem like a good idea, since we don’t know which columns will be numbers and which one won’t.
Adding a ‘ character in front of numbers won’t work either, as the character is then displayed in the Excel with the data, instead of just the number.
How can we get these numbers to display in regular numbers in the output Excel ?