Opening .csv file in excell

[deepuibs]

hi guys

I want to open a .csv file in excell from vb.net. I tried using the code

Dim xlsApp As Excel.ApplicationClass
Dim xlsWB As Excel.WorkbookClass
Dim xlsSheet As Excel.WorksheetClass
'Dim xlsCell As Excel.Range
Dim xlsDatei As String

xlsApp = New Excel.ApplicationClass
xlsApp.Visible = True
xlsWB = xlsApp.Workbooks.Open("C:\Reporttestrak.csv")
'xlsapp.
'xlsApp.FileFind.Load("C:\Consolidated.csv")
xlsSheet = xlsWB.Worksheets(1)
'xlsCell = xlsSheet.Range("A1")

but it's not working....

Can some one help me in solving this issue..

[dotexe]

hi guys

I want to open a .csv file in excell from vb.net. I tried using the code

Dim xlsApp As Excel.ApplicationClass
Dim xlsWB As Excel.WorkbookClass
Dim xlsSheet As Excel.WorksheetClass
'Dim xlsCell As Excel.Range
Dim xlsDatei As String

xlsApp = New Excel.ApplicationClass
xlsApp.Visible = True
xlsWB = xlsApp.Workbooks.Open("C:\Reporttestrak.csv")
'xlsapp.
'xlsApp.FileFind.Load("C:\Consolidated.csv")
xlsSheet = xlsWB.Worksheets(1)
'xlsCell = xlsSheet.Range("A1")

but it's not working....

Can some one help me in solving this issue..

CSV file is nothing but a text file where all the data are supperated by comma','
On that there is no multple sheets.

use streamreader sr1 = new streamreader(@"filepath" )
sr1.read,sr1.readline,sr1.readtoend

if you dont understand reply.