How to define encoding in Rails when generating xls file?

Question

Ruby on Rails

I link like this:

<%= link_to 'Скачать excel', exportsub_path(format: "xls") %>

I generate an excel file like this:

@subscribers = Subscriber.where(user_id: session[:user_id])
    respond_to do |format|
      format.html
      format.xls
 end

And in view the usual table with a cycle.
And so, the excel-file loads, but there kryakozabry. How to solve the problem or how to set the correct encoding?

Answer 1

In general, we made csv for Excel and also had krakozyabry. Decided by converting to UCS2-LE or UTF-16
and adding BOM csv_string.insert(0,"\xFF\xFE")