Error : Zip end of central directory signature not found

[Sean Machin]

Hi Guys,

I have some code that uses Roo that has been working fine for a while.  A co-worker of mine made a small modification to one of the xlsx spreadsheets we use, and now when we try to import it we are getting the above error.  Any ideas as to what the cause is and what the fix is?

TY,
Sean

Zip::ZipError (Zip end of central directory signature not found):
  app/models/device_importer.rb:31:in `new'
  app/models/device_importer.rb:31:in `initialize'
  app/controllers/seeds_gateways_controller.rb:212:in `new'
  app/controllers/seeds_gateways_controller.rb:212:in `upload_devices'

[Akshat Paul]

Check the excel whether its opening fine. Sometimes excel files get corrupt, just few mins back I was facing exactly the same issue. 

When investigated found that excel miraculously was corrupted in the system.