BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
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.