Skip to content

Instantly share code, notes, and snippets.

@quevon24
Forked from niallsmart/linebreak.rb
Created June 18, 2018 16:14
Show Gist options
  • Save quevon24/b4270d5a869c872df97eb980e50d3c9c to your computer and use it in GitHub Desktop.
Save quevon24/b4270d5a869c872df97eb980e50d3c9c to your computer and use it in GitHub Desktop.
Axlsx line break
require 'axlsx'
Axlsx::Package.new do |package|
workbook = package.workbook
workbook.add_worksheet do |sheet|
wrap = workbook.styles.add_style alignment: {wrap_text: true}
sheet.add_row ["Foo\r\nBar", "Foo\rBar", "Foo\nBar", "Foo\n\r\nBar"], style: wrap
end
package.serialize "linebreak.xlsx"
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment