SSRS Exported Excel files are not readable in EPPlus

Jul 18, 2014 at 3:15 PM
Hi,

I am experiencing an issue with EPPlus reading worksheets from an SSRS generated excel file(*.xlsx), basically export to Excel.
Exception Message -
"Unexpected XML declaration. The XML declaration must be the first node in the document, and no white space characters are allowed to appear before it. Line 1, position 2175"

If I save the same file opening in Excel Application and with no change to it, the same file works well.

Development Environment -
VS2010, SQL Server 2012, SSRS

Could anyone have suggestions to this issue. Appreciate your help.