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.
BoldDeskBoldDesk is now live on Product Hunt with a special offer: 50% off all plans. Let's grow together! Support us.
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
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.
