csv to xls

[edantas]

I have purchased a copy of spire xls. Can you please let me know how to convert csv to xls and rename the worksheet? I'm using VB.net

Thanks,

[nancy]

Hi edantas,

About your problem, we have send a email to you. Please find it. For the convenience of other people, I pasted the codes in here.

Code: Select all

workbook.LoadFromFile("..\..\test.csv", ",", 1, 1)
        Dim sheet As Worksheet = workbook.Worksheets(0)
        sheet.Name = "aaaa"
        workbook.SaveToFile("..\..\result.xlsx", ExcelVersion.Version2010)