csv to xls

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

csv to xls

Postby edantas » 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

Re: csv to xls

Postby nancy » 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

Who is online

Users browsing this forum: No registered users and 0 guests