weshatheleopard / rubyXL

Ruby lib for reading/writing/modifying .xlsx and .xlsm files
MIT License
1.28k stars 255 forks source link

Excel requires repair #230

Open pirodt opened 8 years ago

pirodt commented 8 years ago

I only have this problem with this file and only when my woorkbook has many worksheets on it

captura de pantalla 2016-05-31 a las 3 20 05 p m
schorsch commented 7 years ago

same problem here and the ms office 10 error message does not offer any further infos :-(

drthvdr commented 7 years ago

I ran into a similar issues when adding an Input Message to a Data Validation field that exceeded 255 chars.

descovi commented 7 years ago

same problem

HDLP9 commented 4 years ago

I ran into this issue and "fixed it" by:

  1. opening the excel and allowing Excel to repair it
  2. use the new repaired excel as the template for RubyXL to open

And the error just got fixed for new exports. I really don't know why but it worked.

Give it a try.