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.
Unfortunately, activation email could not send to your email. Please try again.

Workbook not visible

Thread ID:

Created:

Updated:

Platform:

Replies:

117095 Aug 10,2014 08:58 PM Aug 13,2014 01:50 AM Windows Forms 3
loading
Tags: XlsIO
Bill Penrose
Asked On August 10, 2014 08:58 PM

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

http://www.syncfusion.com/kb/1937/how-do-i-create-a-simple-spreadsheet-using-xlsio

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 06:10 AM

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.

Regards,
Dilli babu 

Bill Penrose
Replied On August 12, 2014 06:32 AM

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 01:50 AM

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.

Regards,
Dilli babu.

CONFIRMATION

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.

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.

;