Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

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