We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Workbook not visible

Thread ID:





117095 Aug 11,2014 12:58 AM UTC Aug 13,2014 05:50 AM UTC WinForms 3
Tags: XlsIO
Bill Penrose
Asked On August 11, 2014 12:58 AM UTC

Using this example I have run the code below but nothing appears in the form. I am missing something obvious.

The datatable definitely has rows and items and no errors appear. Pewrhaps I need to create some sort of object on the form

Sorry, I accidently posted this as a reply to an old issue


Private Sub frmMaster_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Shown
 If DSMaster.Tables.Count = 0 Then
            GetSpreadsheet(MasterFile, DSMaster)
        End If

        ' A new instance of the Excel Application is created
        Dim excelEngine As New ExcelEngine()
        Dim application As IApplication = excelEngine.Excel
        application.DefaultVersion = ExcelVersion.Excel97to2003
        ' A new workbook object [bookOne] is created
        Dim bookOne As IWorkbook = excelEngine.Excel.Workbooks.Create(1)
        Dim sheet As IWorksheet = bookOne.Worksheets(0)

        sheet.ImportDataTable(DSMaster.Tables("Master"), True, 1, 1, -1, -1) ', True)
End Sub

Dilli Babu Nandha Gopal [Syncfusion]
Replied On August 12, 2014 10:10 AM UTC

Hi Bill,

Thank you for using syncfusion product.

Please go through these link :

Check whether datatable contains values before passing it to ImportDatatable().

Please let us know if you have any concern.

Dilli babu 

Bill Penrose
Replied On August 12, 2014 10:32 AM UTC

Thank you for you help, however I do not think the problem is the datatable or the import statement. I have used the import statement many times to import to a worksheet then output the worksheet as an excel file.

The problem is that the code does not produce a visible worksheet. My guess is that there is no object for the form to display, so I see nothing on the form.

Dilli Babu Nandha Gopal [Syncfusion]
Replied On August 13, 2014 05:50 AM UTC

Hi Bill,

Thanks for updating us.

The reported issue is not reproducing at our end. We request you to provide us a simplified issue reproducing sample or complete code snippets to assist with a prompt solution. 

We recommend you to provide the requested details about this issue in our Direct-Trac support.

Dilli babu.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon