Load Excel in VB.Net

[Phoon Chee Keong]

Hi, anyone know how to load excel in vb.net? I trying to load a template
with formula so that i can save to access.

Regards,
PCK

[Sergey Poberezovskiy]

I use the following code to open excel file:

Private _excel As Excel.Application
Private _book As Excel.Workbook
Private _readOnly As Boolean = False

Private Sub openExcelFile(ByVal fileName As String)
' There is no error handling here: it has to be present in the
calling procedure
If _excel Is Nothing Then
_excel = New Excel.Application
_excel.Visible = False
End If
_book = _excel.Workbooks.Open(fileName:=fileName,
ReadOnly:=_readOnly, Notify:=False)
End Sub

HTH

"Phoon Chee Keong" wrote:

Hi, anyone know how to load excel in vb.net? I trying to load a template
with formula so that i can save to access.

Regards,
PCK

[Sergey Poberezovskiy]

Phoon,

Forgot to mention: the code in the previous code is part of a class that
deals with that specific workbook. It also contains the following code:

Implements IDisposable

Public Sub Dispose() Implements IDisposable.Dispose
If Not _book Is Nothing Then
_book = Nothing
End If
If Not _excel Is Nothing Then
With _excel
' This particular instance of Excel was open for our work
only:
For Each wrk As Excel.Workbook In .Workbooks
wrk.Close(SaveChanges:=False)
Next
.Quit()
End With
_excel = Nothing
End If

When you create instances of your class, wrap them in Try..Catch..Finally
block and put code similar to the following into Finally:

If Not MyExcelClass Is Nothing Then
MyExcelClass.Dispose()
MyExcelClass = Nothing
End If

This is important, so that you do not have 'ghost' excel instances hanging
around after your application is closed.

"Phoon Chee Keong" wrote:

Hi, anyone know how to load excel in vb.net? I trying to load a template
with formula so that i can save to access.

Regards,
PCK

[Phoon Chee Keong]

TQ HTH

Do u have any sample code on this? Maybe can load into flexgrid.

Regards
PCK

"Sergey Poberezovskiy" <Se*****************@discussions.microsoft.com> wrote
in message news:24**********************************@microsof t.com...

Phoon,

Forgot to mention: the code in the previous code is part of a class that
deals with that specific workbook. It also contains the following code:

Implements IDisposable

Public Sub Dispose() Implements IDisposable.Dispose
If Not _book Is Nothing Then
_book = Nothing
End If
If Not _excel Is Nothing Then
With _excel
' This particular instance of Excel was open for our work
only:
For Each wrk As Excel.Workbook In .Workbooks
wrk.Close(SaveChanges:=False)
Next
.Quit()
End With
_excel = Nothing
End If

When you create instances of your class, wrap them in Try..Catch..Finally
block and put code similar to the following into Finally:

If Not MyExcelClass Is Nothing Then
MyExcelClass.Dispose()
MyExcelClass = Nothing
End If

This is important, so that you do not have 'ghost' excel instances hanging
around after your application is closed.

"Phoon Chee Keong" wrote:

Hi, anyone know how to load excel in vb.net? I trying to load a template
with formula so that i can save to access.

Regards,
PCK