I am opening a Csv file using Aspose Cells version 18.104.22.168 for .Net 4.0 and Converting and saving it as a .Xls file.
I have a number of columns containing numeric data and I want this data to convert to numeric in Excel. This is all working fine using TxtLoadOptions.ConvertNumericData = True;
I have another text column, which is a serial number, and contains only numerics with a few leading zeros. I want to retain this column as a string. In Excel I can prefix the data with a Single quote to achieve this. I have tried prefixing the data with a sinle quote in the Csv file and whn I view the converted Xls file the data is showing in the Cell as '000123456, i.e. I can see the single quote. It is not automatically detecting the single quote and not displaying it, as Excel would normally do. I have also tried another suggestion to encompass the data as follows in the Csv file, =""000123456"". This works when using Microsoft Excel Automation, but with Aspose cells the data appears as =""000123456"" after conversion.
Anyone any ideas how to get around this issue without setting TxtLoadOptions.ConvertNumericData to false, as I need this for all other numeric columns in the Csv file.