There's a 3.0.0 branch of axlsx prepping for release here: https://github.com/randym/axlsx/tree/release-3.0.0

axlsx-styler is currently locked to 2.x, so won't work with the new version.

This might be as simple as making the dependency open-ended in the gemspec, but I haven't had a close look at all the changes.

Tried installing this earlier, are there actually problems with newer versions of Rails, or is this just a dependency syntax issue?

Bundler could not find compatible versions for gem "activesupport":
  In Gemfile:
    axlsx_styler (>= 0) ruby depends on
      activesupport (~> 3.1) ruby

    rails (= 4.1.4) ruby depends on
      activesupport (4.1.4)

wb = xlsx_package.workbook
money_eft = wb.styles.add_style format_code: '#,##0, \\eFt;-#,##0, \\eFt;- \\eFt;@'
wb.add_worksheet(name: "foo") do |sheet|
  sheet.add_row ['123456789'], style: [money_eft]
end

this results in the formatting code taking effect on the field.

wb = xlsx_package.workbook
money_eft = wb.styles.add_style format_code: '#,##0, \\eFt;-#,##0, \\eFt;- \\eFt;@'
wb.add_worksheet(name: "foo") do |sheet|
  sheet.add_row ['123456789'], style: [money_eft]
  sheet.add_style 'A1:A1', bg_color: 'FF0000'
  sheet.add_style 'A1:A1', b: true
end

this loses the format code, but applies both the background color and the bold font correctly.

In my gem SpreadsheetArchitect I have the ability to create axlsx sheets individually. I was wondering if we can get the workbook.apply_styles to also be available as sheet.apply_styles so that I can apply the styling before returning the sheet.

Hello,

I want:

My code is:

require 'axlsx_styler'
axlsx = Axlsx::Package.new
workbook = axlsx.workbook
workbook.add_worksheet do |sheet|
	sheet.add_row
	row = sheet.add_row
	row.add_cell
	cell = row.add_cell
	sheet.add_border('B2:B2', { edges: [:left, :right], style: :thick, color: 'FF0000' })
	sheet.add_border('B2:B2', { edges: [:top, :bottom], style: :double, color: '0000FF' })
end
axlsx.serialize('a.xlsx')

But i get:

Any idea to perform that?
Thanks!

I am trying to draw a table with a thin grid and a medium outline:

this correctly draws the grid:

wb.add_worksheet(name: "foo") do |sheet|
  sheet.add_row ['1', '2', '3']
  sheet.add_row ['4', '5', '6']
  sheet.add_row ['7', '8', '9']
  sheet.add_style 'A1:C3', border: {style: :thin, color: '000000'}
end
wb.apply_styles

this correctly draws the outline:

wb.add_worksheet(name: "foo") do |sheet|
  sheet.add_row ['1', '2', '3']
  sheet.add_row ['4', '5', '6']
  sheet.add_row ['7', '8', '9']
  sheet.add_border 'A1:C3', style: :medium
end
wb.apply_styles

but I get an error if I try to combine the two:

wb.add_worksheet(name: "foo") do |sheet|
  sheet.add_row ['1', '2', '3']
  sheet.add_row ['4', '5', '6']
  sheet.add_row ['7', '8', '9']
  sheet.add_style 'A1:C3', border: {style: :thin, color: '000000'}
  sheet.add_border 'B2:C3', style: :medium
end
wb.apply_styles

ActionView::Template::Error (undefined method `+' for nil:NilClass)

and I get a different error if I try the other way around:

wb.add_worksheet(name: "foo") do |sheet|
  sheet.add_row ['1', '2', '3']
  sheet.add_row ['4', '5', '6']
  sheet.add_row ['7', '8', '9']
  sheet.add_border 'A1:C3', style: :medium
  sheet.add_style 'A1:C3', border: {style: :thin, color: '000000'}
end
wb.apply_styles

ActionView::Template::Error (no implicit conversion of nil into Array)

We are looking into merging this upstream into caxlsx directly

You can following along at caxlsx/caxlsx#167 and caxlsx/caxlsx#168

I was just trying the example for adding the border:

sheet.add_border 'B2:D5', { edges: [:bottom, :right], style: :thick, color: 'FF0000' }

But, I got error:

NoMethodError: undefined method row' for nil:NilClass from /dependencies/bundle/ruby/2.3.0/gems/axlsx-2.1.0.pre/lib/axlsx/workbook/worksheet/worksheet.rb:721:in range'

Whats wrong?

I was having no success getting a format_code or num_fmt so that I can get number and currency formats. Is this supported or do you know how we can add it?

This is my code:

sheet.add_style "B2:E5", format_code: "$#,##0.00"

Only occurring since 0.1.4. It appears that @workbook is not defined at the point of calling apply_styles. However, Axlsx::Package provides a workbook method, which returns the workbook.

Replacing @workbook with workbook corrects the issue. PR forthcoming.

As someone who uses this project heavily in SpreadsheetArchitect, I have a few concerns about the forking of this project:

• Forking make all the github stars go back to zero
• Forking makes the project un-searchable
• Forking kills all SEO

In essence, Forking is not the right answer for hand-off of development of a project/plugin.

Could we instead utilize this original repo by creating an organization? Ex. axlsx-styler-gem/axlsx_styler. This would enable future maintainers to completely the repo without any interaction from the original author and it would solve all of these issues.

Original Thread: #14 (comment)

Problem

If a user defines this in the spreadsheet it will set the default font name

sheet.styles.fonts[0].name = 'Pontiac'

Currently alxsx_styler is not aware of this type of customization and assumes the following based on prior manual testing.

Seems that we can likely just change Arial to sheet.styles.fonts[0].name

Can we also make any similar dynamic improvements to sz: 11 and/or family: 1 ?

I had already defined row styles through plain axlsx but I was applying a column style using add_style and noticed it was overwriting all previous styles.

Is there any way we can get it to only add on to the other styles?

As mentioned in #14 (comment)

For no implicit conversion of Integer into Hash this is another error I was wondering how didnt get triggered. Seemed you failed to mention this. I can make a separate PR to resolve this likely.

# Not working
border = s.add_style border: { style: :thin, color: "000000" }
sheet.add_row ['1', '2', '3', '4'], style: border

no implicit conversion of Integer into Hash

Seems we need to modify the worksheet#add_styles method to handle passing of style index (style number / style object)

or the only way is to hack the cell with '' ?

I build my spreadsheet with empty row and nil row ( is that good practices?)

  sheet.add_row ['Consignee', nil, ": #{@job.company.name}", nil, nil, nil, "Vessel", ": #{@job.vessel_name}"], offset: 1
  sheet.add_row
  sheet.add_row ["DESCRIPTION", nil, nil, nil, "QTY", "UNIT", "CHARGE", "NET VALUE"], offset: 1
  14.times do
    sheet.add_row
  end
  sheet.add_row ["Payment Term : COD", nil, nil, nil, nil, nil, "SUB TOTAL", "JPY"], offset: 1

whenever I try to add style or border I got this
undefined method `row' for nil:NilClass

relevant issues:
#26
#27
randym/axlsx#586

I mean when I use

add_border "b2:F20"

its only give border to the sides/outer but inner like this

what I want is a config/how to get this

I try to add style border for row but I away get the error: undefined method `row' for nil:NilClass

This is my xlsx file when not add style.

please tech me where I wrong, or can I must config somewhere ?
Thanks :)

Getting all sorts of errors when trying to integrate with axlsx_rails on this test:

https://github.com/axlsx-styler-gem/axlsx_styler/blob/master/test/integration/application_test.rb#L7

If anyone has used axlsx_rails and can fix this test that would be sweet.

It would be a huge improvement to the test suite if the tests validated the xml contents of the spreadsheets automatically instead of requiring a manual look at the test spreadsheets.

I would love any PR's or contributions that could help improve our tests. Some test examples to get started could be found within the axlsx repo.

I get an error with the following reproduction:

require 'bundler/inline'

gemfile do
  source 'https://rubygems.org'

  gem 'caxlsx', "= 3.0.1"
  gem 'axlsx_styler', "= 1.0.0"
end

# Monkey-patch a "fix" by uncommenting the line below and commenting the line
# that follows it
module AxlsxStyler
  module Styles
    def add_style(*args)
      style = args.first

      self.style_index ||= {}

      raw_style = {type: :xf, name: 'Arial', sz: 11, family: 1}.merge(style)
      if raw_style[:format_code]
        raw_style.delete(:num_fmt)
      end

      index = style_index.key(raw_style)
      if !index
        index = super
        # self.style_index[index] = raw_style unless raw_style[:type] == :dxf
        self.style_index[index] = raw_style
      end
      return index
    end
  end
end

Axlsx::Package.new do |p|
  %w[first second].each do |sheet_name|
    p.workbook.add_worksheet(name: sheet_name) do |sheet|
      sheet.add_row (1..2).to_a

      sheet.add_style "A1:A1", { bg_color: "AA0000" }
      sheet.add_style "B1:B1", { bg_color: "CC0000" }

      sheet.add_row (1..2).to_a

      highlight = p.workbook.styles.add_style(bg_color: "0000FF", type: :dxf)

      sheet.add_conditional_formatting(
        "A2:B2",
        {
          type: :cellIs,
          operator: :greaterThan,
          formula: "1",
          dxfId: highlight,
          priority: 1
        }
      )

      sheet.add_row (1..2).to_a

      sheet.add_style "A3:B3", { bg_color: "00FF00" }
    end
  end

  p.serialize('simple.xlsx')
end

Running this file gives:

Traceback (most recent call last):
	9: from bug.rb:33:in `<main>'
	8: from bug.rb:33:in `new'
	7: from /Users/owen/.rbenv/versions/2.6.6/lib/ruby/gems/2.6.0/gems/caxlsx-3.0.1/lib/axlsx/package.rb:29:in `initialize'
	6: from bug.rb:62:in `block in <main>'
	5: from /Users/owen/.rbenv/versions/2.6.6/lib/ruby/gems/2.6.0/gems/axlsx_styler-1.0.0/lib/axlsx_styler/axlsx_package.rb:5:in `serialize'
	4: from /Users/owen/.rbenv/versions/2.6.6/lib/ruby/gems/2.6.0/gems/axlsx_styler-1.0.0/lib/axlsx_styler/axlsx_workbook.rb:21:in `apply_styles'
	3: from /Users/owen/.rbenv/versions/2.6.6/lib/ruby/2.6.0/set.rb:338:in `each'
	2: from /Users/owen/.rbenv/versions/2.6.6/lib/ruby/2.6.0/set.rb:338:in `each_key'
	1: from /Users/owen/.rbenv/versions/2.6.6/lib/ruby/gems/2.6.0/gems/axlsx_styler-1.0.0/lib/axlsx_styler/axlsx_workbook.rb:29:in `block in apply_styles'
/Users/owen/.rbenv/versions/2.6.6/lib/ruby/gems/2.6.0/gems/caxlsx-3.0.1/lib/axlsx/workbook/worksheet/cell.rb:296:in `style=': Invalid cellXfs id (ArgumentError)

I tracked a "fix" down by adding the commented line in the code, I'm not quite sure I follow what's going on, but hopefully this is helpful

With the latest v0.1.6 version, ActiveSupport is now locked to the 3.x family versions, which is a problem for people using a any library depending from greater versions of ActiveSupport.

For instance any version of rails >= 4.x:

Bundler could not find compatible versions for gem "activesupport":
  In snapshot (Gemfile.lock):
    activesupport (= 5.0.0.1)

  In Gemfile:
    activemodel-serializers-xml (~> 1.0.0) was resolved to 1.0.0, which depends on
      activesupport (> 5.x)

    rails (~> 5.0.0) was resolved to 5.0.0.1, which depends on
      activejob (= 5.0.0.1) was resolved to 5.0.0.1, which depends on
        globalid (>= 0.3.6) was resolved to 0.3.7, which depends on
          activesupport (>= 4.1.0)

    axlsx_styler (~> 0.1.6) was resolved to 0.1.6, which depends on
      activesupport (~> 3.1)

How can I use colspan and rowspan

I think it would be fantastic to have a section in the readme which we can use as reference for all available style options.

For example I just had to look up all of the available border styles in the axlsx documentation which by the way are :none :thin :medium :dashed :dotted :thick :double :hair :mediumDashed :dashDot :mediumDashDot :dashDotDot :mediumDashDotDot :slantDashDot

Another example is format instructions for number_format_code.

I would be interested in helping compile this list. As an added bonus this would probably drive a lot of axlsx traffic to this useful gem. What do you think about adding this.