I am trying to render a xlsx file. But I keep getting a 406/UnknowFormat. I have done the right setup, maybe im missing something? Rails 4.2 app gem 'axlsx' gem "axlsx_rails" gem 'zip-zip' conf...

I'm using the axlsx ruby gem to create Excel-compatible .xlsx files. I can't figure out how to override the cell type that is generated by it's automatic type detection. For Active Record model att...

Am using axlsx_rails gem with activeadmin to export formatted excel report This format is working fine in Ubuntu LibreOffice but the styles breaks in windows OS. This is the proper aligned forma...

I am using ruby Axlsx gem for writing my clients accounts data in xlsx. Now I am appending " Dr" string to all debit amounts which is making amount as a string e.g. "1000 Dr". I want to append " Dr...

I'm using the axlsx gem to create a XLSX file and have the following line in my code: ws.add_row( "xyz" ) Is there a way to get the row index of the row I had just added? I might have to add a r...

I see methods for col_style and row_style and add_conditional_formatting, but can't figure out how to set just one cell. In my example, col 1 is a date and column 2 is a percent. when i highlight t...

It is possible to apply a font color to individual cells, without creating a style: Axlsx::Package.new do |p| p.workbook.add_worksheet(:name => "test") do |ws| ws.add_row ["a", "b", "c"] ws...

Actually my requirement is to zip some files in some folders. I have already many files saved on my server and associated with some objects. So I have to zip all the files related to one object som...

I have been using the Spreadsheet gem to write xls files. With the Spreadsheet gem, merging the cells can be done dynamically based on the row and column number like this merge_cells(start_row, ...

I use axlsx gem to work with xlsx file. Please help me to set font in cells of sheet. item_style = s.add_style :b => false, :sz => 9, :font_name => 'courier', :alignment => { :horizon...

I can't seem to find any information on whether it's possible to fill a single cell with multiple formatting options. For example, I want cell A1 to be filled with the text: "Hello world, this is...

Any idea how to write view specs (presence of headers, rows, etc.) for a generated xlsx file from the xlsx gem? Not sure if I'm doing it correctly in the first place but here's what I have so far ...

With the spreadsheet gem, you can run Spreadsheet::Link.new('http://hyperlinkhere.com', 'Some words') to make a spreadsheet with a cell containing the string "Some words" with a hyperlink leading t...

Using Axlsx some of my cells are set to wrap text which works great. The problem I'm running into is how the auto-width of the cells seems to be calculated. It seems like what's happening is initia...

I'm trying to format my report and making sure the columns have a correct width and I can't seem to make it happen with auto_width. With this code, this is the kind of report I get . Notice the s...

I am trying to use asxlx gem to write an excel sheet but I have failed miserably trying to access individual cell values.. For example for do I get the value of the cell 2 in column 2 How do I ch...

I am using the axlsx gem to create excel files. I get them serialized in my project home directory as an xlsx file. But I want the file to be created in the public folder of my rails app, or direct...

I'm trying to set the foreground color of text in a hyperlink cell but it doesn't seem to work. Using something like: sheet["A1"].color = "0000FF" works fine for a normal cell, but not for a hype...