Hi,
I agree you sample works but it use an existing excel file as model.
The problem arrives when you create an excel file from scratch.
Use the code bellow to check the problem :
Dim excelEngine As ExcelEngine = New ExcelEngine
Dim Application As IApplication = excelEngine.Excel
Application.DefaultVersion = ExcelVersion.Excel97to2003
Dim MyWorkbook As IWorkbook = Application.Workbooks.Create(1)
Dim MySheet As IWorksheet = MyWorkbook.Worksheets(0)
MySheet.Range("A1:E5").Value = "Titles"
MySheet.Range("A6:E100").Value = "Data"
MySheet.PageSetup.PrintTitleColumns = "$A:$IV"
MySheet.PageSetup.PrintTitleRows = "$1:$5"
MyWorkbook.SaveAs("Result.xls")
System.Diagnostics.Process.Start("Result.xls")
Try to preview or print the sheet... what is wrong in this code ?
