Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
KEVIN WILLIAMS
355
using Infragistics2.Excel.v9.2 can I actually open an workbook??
posted

moving this to the appropriate forum

using Infragistics2.Excel.v9.2 and Infragistics2.Win.UltraWinGrid.ExcelExport.v9.2

After exporting a grid to a workbook, how can I actually open the workbook for the user to see.  i'm currently doing this

Public Sub ExportGridToExcel(grid As UltraGrid)
        Dim FilePath As String = gbMyDocumentsFolder & "PSA_" & VB6.Format(Today, "mmddyyyy") & VB6.Format(TimeOfDay, "hhmmss") & ".xls"
        Dim exporter As UltraGridExcelExporter = New UltraGridExcelExporter()
        AddHandler exporter.BeginExport, AddressOf HandleExcel_BeginExport
        exporter.Export(grid, FilePath)
        Process.Start(FilePath)
    End Sub

  • 469350
    Offline posted

    Hi,

    What's the problem? Is this code not working?

    This code should work, assuming that Microsoft Excel is installed on the machine and xls files are associated with it.