xlsx_zip_error_rescue.rb

# A code snippet that helps me to rescue Zip::Error when handling .xlsx files on Rails

@file = params.fetch(:file)
begin

  # try to open xlsx with roo gem
  @spreadsheet = Roo::Excelx.new(@file.path, file_warning: :ignore)

rescue Zip::Error # corrupted xlsx file
  # if got zip error, try to save the content in csv before open it
  filepath = "#{Rails.root}/tmp/tmp_spreadsheet.csv"
  
  # don't forget to `.force_encoding("utf-8")` to fix content error (was essential in my context)
  File.open(filepath, "w") { |file| file.puts @file.read.force_encoding("utf-8") }
  @spreadsheet = Roo::CSV.new(filepath)
end