Writing and Reading From Excel file by using vb.net

[alvinblim]

Hi,
i have some problem with writing data and reading data from Excel file. Do someone know how can i write the data into excel file and reading the data from excel file. i hope someone can provide more detail on excel file programming, because i dont hv experience on excel programming. i will appreciate for your reply.
Thank you very much

Best Regards,
Alvin

 

[vis781]

To open and read an excel file, you can use the following. I'm assuming you have added a reference to MS Excel 10.0 Library

Dim xlsApp As Excel.Application
Dim xlsWB As Excel.Workbook
Dim xlsSheet As Excel.Worksheet
Dim xlsCell As Excel.Range
Dim xlsDatei As String

xlsApp = New Excel.Application
xlsApp.Visible = True
xlsWB = xlsApp.Workbooks.Open(Path)
xlsSheet = xlsWB.Worksheets(1)
xlsCell = xlsSheet.Range("A1")

Be sure to properly dispose of the objects after you have finished using them.

 

[alvinblim]

Saving data into excel file

hi,
thx for your reply. but how can i save the data into excel file?

Best Regards,
Alvin

 

[agroom]

Are you looking to create a new file or edit an existing?