Spire.XLS is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Wed Jun 27, 2012 1:55 pm

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


Posts: 3
Joined: Fri May 04, 2012 1:27 pm

Thu Jun 28, 2012 8:01 am

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)
e-iceblue support team
contact: nancy.wang@e-iceblue.com
User avatar

Posts: 51
Joined: Wed May 30, 2012 2:02 am

Return to Spire.XLS