Read .xlsx Excel File error

Question

Hi I've Error while reading .xlsx Excle file. I'm using Excel.dll and when I'm trying to read data from my worksheet I'm getting error

"End of Central Directory record could not be found."

Here's sample code

foreach (var worksheet in Workbook.Worksheets(@"c:\MyFile.xlsx"))

Answer 1

I noticed that my .xlsx was protected by password so I used different one, now it 's working.