|131576||Jul 17,2017 11:11 AM||Oct 13,2017 07:52 AM||Windows Forms||5|
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"
Try to preview or print the sheet... what is wrong in this code ?
I am also requiring a fix for this issue. Whilst using the PrintTitleColumns seems to work ok, the PrintTitleRows does not.
Can you please provide a status on when this will be fixed - or if there is a workaround I can use in the meantime.
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.