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.
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