Text orientation/rotation

[javierfdr]

Is there a way to change vertical/horizontal of text within the cells?. Otherwise, it would be nice to be able to assign a given rotation for text. My problem is that I have 'column header names' that are really long, but each of the column values are 2 digit numbers, so the column width expands too much. I would like to display the header with vertical orientation, and the rest of the column values as usual.

Thanks for your help

[JonathanTron]

You should be able to do that by assigning a style to the cell:

p = Axlsx::Package.new
wb = p.workbook
ws = wb.add_worksheet
cell_rotated_text_style = wb.styles.add_style(:alignment => {:textRotation => 90})
ws.add_row(
  ["Short cell", "My long title which should be rotated"], 
  :style => [nil, cell_rotated_text_style]
)

[javierfdr]

Thank you very much. That worked perfectly for the whole row.
Is it possible to apply the style just to a given cell in the row, instead of the whole row?

[javierfdr]

Ok, I've just found out how can you do it. For instance, if you want to apply the new style for cells [0,..,2] of rows[0,..,.2] you could do:

ws.rows[0..2].each {|row| row.cells[(0..2)].each {|cell| cell.style = cell_rotated_text_style} }

Taken from issue: #16

Thanks

[randym]

thanks @JonathanTron!
@javierfdr you can also pass a sparse style array on add row or use sheet['D1:F3'] style notation if it feels cleaner to you.