I cannot determine the cause of an exception which is occuring during report generation. I am looking for any suggestions toward narrowing down the issue. I've tried executing the report on a nearly empty template where only Names are defined, but includes empty worksheets and the #Config sheet without any expressions. I am providing all data tables and report variables. The exception message is:
Invalid column index: "0"
The exception type is: FlexCelCoreException
Here is the stack trace:
at FlexCel.Core.FlxMessages.ThrowException(FlxErr ResName, Object[] args)
at FlexCel.XlsAdapter.XlsFile.#Xrb(Int32 , Int32 )
at FlexCel.XlsAdapter.XlsFile.KeepColsTogether(Int32 col1, Int32 col2, Int32 level, Boolean replaceLowerLevels)
at FlexCel.Core.ExcelFile.ClearKeepRowsAndColsTogether()
at FlexCel.Report.FlexCelReport.#EFb(List
at FlexCel.Report.FlexCelReport.#CFb(Int32 , #Ce , #ye& , List
at FlexCel.Report.FlexCelReport.Run(ExcelFile aWorkbook)
at FlexCel.Report.FlexCelReport.Run(Stream templateStream, Stream outStream)
at BAML.CompassUIControls.Utils.ExportReportUtil.RunReport(FlexCelReport report, Stream templateStream, String saveFilePath) in C:\TFSRoot\Architecture and Strategy\BAML.CompassDesktop\BAML.CompassUIControls\Utils\ExportReportUtil.cs:line 75
at FlexCel.XlsAdapter.XlsFile.#Xrb(Int32 , Int32 )
at FlexCel.XlsAdapter.XlsFile.KeepColsTogether(Int32 col1, Int32 col2, Int32 level, Boolean replaceLowerLevels)
at FlexCel.Core.ExcelFile.ClearKeepRowsAndColsTogether()
at FlexCel.Report.FlexCelReport.#EFb(List
1 , List
1 )at FlexCel.Report.FlexCelReport.#CFb(Int32 , #Ce , #ye& , List
1 , List
1 )at FlexCel.Report.FlexCelReport.Run(ExcelFile aWorkbook)
at FlexCel.Report.FlexCelReport.Run(Stream templateStream, Stream outStream)
at BAML.CompassUIControls.Utils.ExportReportUtil.RunReport(FlexCelReport report, Stream templateStream, String saveFilePath) in C:\TFSRoot\Architecture and Strategy\BAML.CompassDesktop\BAML.CompassUIControls\Utils\ExportReportUtil.cs:line 75
Any troubleshooting suggestions would be appreciated.
Thanks