CSV to xlsx - Number

[skyfox1964]

After converting a .csv file to .xlsx, all of the numbers are stored as text. Calculations still work correctly in othee sheets that references this data. But I want the numbers to be stored as numbers. What is the syntax to do this with Vbnet and Spire.XLS after the file conversion?

Thanks

csv to xlsx.png (5.49 KiB) Viewed 835 times

[Brian.Li]

Hello,

Thanks for your inquiry.
Please refer to the following code to keep the numbers in the worksheet to be stored as numbers

Code: Select all

        Dim workbook As Workbook = New Workbook
        workbook.LoadFromFile("test.csv", ",", 1, 1)
        Dim sheet As Worksheet = workbook.Worksheets(0)

        sheet.Range("A1:E5").ConvertToNumber()
        workbook.SaveToFile("result.xlsx", ExcelVersion.Version2016)

If this doesn't meet your requirement well, please provide your input file along with your desired output file. Then we will investigate it further.

Sincerely,
Brian
E-iceblue support team

[skyfox1964]

Thanks Brian.

That fixed the issue.

Cheers!

[Nina.Tang]

Hi,

Thanks for your feedback.
If you have other questions, please feel free to write back.
Wish you all the best!

Sincerely,
Nina
E-iceblue support team