AxlsxEnhanced

Provides a better way to serialize xlsx documents using caxlsx gem. Enhances caxlsx styling while building a spreadsheet by ruby code.

Installation

Add this line to your application's Gemfile:

gem 'axlsx_enhanced', '~> 0.1.4'

And then execute:

$ bundle

Or install it yourself as:

$ gem install axlsx_enhanced

Usage

Default usage

AxlsxEnhanced uses the same Axlsx syntax, and just injected some useful methods for building a worksheet:

document = Axlsx::Package.new do |p|
  # Creates a new worksheet
  # args:
  #  *(built-in Axlsx args)
  #  name:         String, default: ""
  #  smart_styles: Array,  default: AxlsxEnhanced::Helpers::Styles.defaults
  p.workbook.smart_add_worksheet(name: 'Sheet 1') do |sheet|
    # METHOD 1
    ## Sets bold style for all cells
    sheet.smart_add_row ["Cell 1", "Cell 2", "Cell 3"], style: :bold

    # METHOD 2
    ## Sets italic style for cell #1 and underline style for cell #2
    sheet.smart_add_row ["Cell 1", "Cell 2"], style: [:italic, :underline]

    # METHOD 3
    ## Sets cell styles for specific cells in a row
    row = sheet.smart_add_row ["Cell 1", "Cell 2", "Cell 3"]
    ## Sets bold style for cell #1
    row.cells[0].smart_style = :bold
    ## Sets italic + underline style for cell #3
    row.cells[2].smart_style = [:italic, :underline]
  end

  p.serialize('hello.xlsx')
end

Styles

Styling worksheets are easier now after we created the following structure for it:

# Creates a style
style = {
  name: :custom_style,
  properties: {
    b:        true,
    sz:       12,
    fg_color: "FFFFFF",
    bg_color: "004586",
    alignment: {
      horizontal: :center,
      vertical:   :center,
      wrap_text:  true
    },
    border: {
      style: :thick,
      color: "FFFF0000",
      edges: [:top, :bottom]
    }
  }
}

For more style properties examples see Axlsx properties examples in here.

Using the default style templates

You can use our default style templates while building a worksheet, to see all the available style names check out this file.

Create your own style templates

Creating and reusing your own templates now is possible using smart_styles option when creating a worksheet as the example given below:

# Creates a custom template
my_template = [
  {
    name: :bold_italic,
    properties: {
      b: true, 
      i: true
    }
  },
  {
    name: :center_middle_text,
    properties: {
      alignment: {
        horizontal: :center,
        vertical:   :center
      }
    }
  }
]

After that, now we are able to use our custom template:

# Use the template in a worksheet
document = Axlsx::Package.new do |p|
  p.workbook.smart_add_worksheet(name: 'Sheet 1', smart_styles: my_template) do |sheet|
    sheet.smart_add_row ["Cell 1", "Cell 2", "Cell 3"], style: :bold_italic
  end
  p.serialize('hello.xlsx')
end

NOTE THAT using your custom style templates will override our default style template. For combining our style template with yours you can merge the styles in a new variable and the use it for creating a spreadsheet:

combined_template  = []

combined_template += my_template
combined_template += AxlsxEnhanced::Helpers::Styles.defaults

Development

After checking out the repo, run bin/setup to install dependencies. Then, run rake spec to run the tests. You can also run bin/console for an interactive prompt that will allow you to experiment.

To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/mldoscar/axlsx_enhanced. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the Contributor Covenant code of conduct.

Code of Conduct

Everyone interacting in the AxlsxEnhanced project’s codebases, issue trackers, chat rooms and mailing lists is expected to follow the code of conduct.