axlsx
axlsx copied to clipboard
randym
xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents wi...
I recently used axlsx to convert a rather complex data object to Excel, and here are some issues I came across. some of these may be due to me not...
I create formula on Excel UI and work. But use `formula1: '=INDIRECT(INDIRECT("C"&MID(CELL("address"),4,1))&"!A$2:A$30")'` and dont work. The excel file generated is corrupted. Any idea? ``` =INDIRECT(INDIRECT("C"&MID(CELL("address"),4,1))&"!A$2:A$30") ```
There is the possibility of bringing a list, but when selecting it, deliver the ID-VLAUE and not the TEXT-NAME
I have to generate template XLSX with preformatted but empty cells (columns), so when a number is entered in such a cell my formatting applies. As the example states it's...
Hi I was using axlsx to create a workbook , stream and write to a downloadable xlsx file with rails 4.2. It used to take less than 60 seconds to...
Auto-height
Axlsx has support for autowidth, but what do you think about auto height?, for columns containing multiple rows of text.
In the notes on headers and footers there is a code &G to use a background image. Is it possible to load an image in a similar way to calling...
I'm trying to set the background to the entire page using ``` sheet.col_style 1, bg, row_offset:1 sheet.col_style 2, bg, row_offset:1 .... sheet.col_style 14, bg, row_offset:1 ``` But it only works...
Could you please unlock `rubyzip` version to use newest version 2 ? https://github.com/rubyzip/rubyzip/releases/tag/v2.0.0
it seems the pivot table does not work with two data fields specified. i tried it with the pivot_test.rb example by adding an extra numeric column in the dataset. it...
