Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET 2.0, 3.5, 4.0 or 4.5 framework application, both ASP.NET web sites and Windows Forms 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

Thanks,

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

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

Return to Spire.XLS

cron