Excel Spreadsheet with Infragistics

Hi NigelRocks,

Check this out (there's Visual Basic section):
http://devcenter.infragistics.com/Articles/ArticleTemplate.Aspx?ArticleID=2159

The code below already looks like what's in the article.  It exports the grid to a file, which is almost what I want.   However, what I'd really like to do is to open an Excel spreadsheet from the app that contains the data in the grid.

Private Sub btnExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExport.Click
        Try

            Me.SaveFileDialogExport.Title = "Save Excel File"
            Me.SaveFileDialogExport.Filter = "Excel Spreadsheets (*.xls)|*.xls"

            ' Set the default files type to Excel Spreadsheets
            Me.SaveFileDialogExport.FilterIndex = 1
            ' Set dialog box so an error occurs if the dialogbox is cancelled
            'Me.SaveFileDialogExport. .CancelError = True
            Me.SaveFileDialogExport.ShowDialog()
            'ben 07/22/09. set a condition to check for the file name is empty or not. 
            If Me.SaveFileDialogExport.FileName <> "" Then
                Me.ugrdAgentsExcelExporter.Export(Me.ugAgents, Me.SaveFileDialogExport.FileName)

            End If

        Catch ex As Exception
            'Throw ex
            MessageBox.Show(ex.ToString)
        End Try
    End Sub

Select allOpen in new window

Hi NigelRocks,

Do you mean that you want to open Excel spreadsheet in the web browser OR you want MS Excel to be launched and open the spreadsheet?

This is in Windows Forms.  And yes, I'd like the data in the graph to be opened in an Excel spreadsheet.

I'm providing a solution.