Footer Problem

[Paul Cavacas]

I'm trying to open an existing Excel spreadsheet that I have, that will serve as a template for a new spreadsheet that I'm creating. If I have a footer in the spreadsheet I get the below error when I try and open it. If I take the footer out then it opens fine.

This is the code that I'm using to open the existing file:
ExcelEngine excelEngine = new ExcelEngine();
IWorkbook workbook = excelEngine.Excel.Workbooks.Open(Properties.Resources.templatePath);

Here is the error message I get on the Open call above.
Additional information: Unable to cast object of type 'Syncfusion.XlsIO.Parser.Biff_Records.ContinueRecord' to type 'Syncfusion.XlsIO.Parser.Biff_Records.PrintSetupRecord'

[Yavanaarasi G]

Hi Paul,

Sorry for the delay in responding.

Error Occur when open the existing file with Footer:

I am not able to reproduce the issue that you mentioned here. Also, I have created a simple sample to test this issue and it is available in the following link:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F70858/main.htm

Please have a look at the above sample and if still the issue exists, could you please try reproducing it in the above sample and send us the modified sample with your template file so that we could sort out the cause of the issue and provide you a solution?

Regards,
Yavana.G