axlsx | xlsx generation with charts , images , automated column width | Application Framework library

First, create a file named freedesktop.org.xml.

Then copy the file content found in this link and paste it into the file just created.

Finally, set the FREEDESKTOP_MIME_TYPES_PATH environment variable

Unix terminal:

In the template file you don't need to require the gem, create the package manually or serialize it in the end - caxlsx_rails does it for you automatically, and you should use the helper methods provided by the gem.

See

• the Readme about the template file
• the current code to see all available helpers in the template

Just install shared-mime-info on your computer. From the docs of the mimemagic gem

You will require a copy of the Freedesktop.org shared-mime-info database to be available. If you're on Linux, it's probably available via your package manager, and will probably be in the location it's being looked for when the gem is installed.

macOS users can install the database via Homebrew with
brew install shared-mime-info.

Should you be unable to use a package manager you can obtain a copy of the needed file by extracting it from the Debian package. This process will also work on a Windows machine. [...]

you might want to consider installing Rails 6.1.3.1 (instead of 6.1.1 in your command). That version was released to fix exactly the mimemagic issue that you are facing – just a couple of hours ago.

Looks like you're running into compatibility issues trying to use the latest version of the activerecord-import gem at the time of writing (released in October 2020) with activerecord 3.2.22.5 (released in September 2016). You do mention it's a rails 3.2.15 app but you're not using activerecord 3.2.15 which is confusing.

Try using activerecord-import 0.4.1 (released in July 2013) and activerecord 3.2.15 which should be compatible with rails 3.2.15.

Based on my understanding of axlsx, it is not currently possible to password protect the opening of the spreadsheet.

As a workaround, I placed the generated spreadsheet in a password protected zip file and downloaded that.

This requires the rubyZip gem

Here's code that takes an Axlsx package and puts into to zip file stream, which you can then download or save to a file.

You can write an instance method for task object which will return desired status string depending of status value.

I've had success using roo with the roo-xls extension.

https://docs.aws.amazon.com/AmazonS3/latest/dev/UploadObjSingleOpRuby.html

Amazon gives you the answer:

I haven't tested it but this should do the job.