axlsx Auto-height

trafficstars

Axlsx has support for autowidth, but what do you think about auto height?, for columns containing multiple rows of text.

Mar 28 '12 13:03 jurriaan

+1

Jul 25 '12 19:07 cj

+1

Nov 07 '12 14:11 horaciob

+1

Nov 11 '12 16:11 scanferla

+1

Feb 03 '13 18:02 morkevicius

+1

Feb 13 '13 16:02 dszczyt

+1

Apr 26 '13 11:04 indrekj

+1

Jul 10 '13 18:07 murphysw

Can't you accomplish this through word wrap?

Oct 02 '13 10:10 rafadc

+1

Oct 07 '13 06:10 osegrums

+1

Nov 07 '13 19:11 rvsingh

+1

Nov 20 '13 06:11 rujaun

+1

Nov 29 '13 03:11 panasyuk

+1

Mar 19 '14 06:03 songjiayang

+1 Is there any workaround for this in the meantime that people have come up with?

Mar 31 '14 06:03 hofdesu

You can just use word wrap or you can count the number of lines and multiply that by the +/- the font size

Mar 31 '14 12:03 jurriaan

could you do a gist for handling this? or is there a way to query the worksheet for the number of rows given a fontSize and a certrain string of text?

Apr 01 '14 03:04 trestles

Yeah, so I was using wordwrap but still had rows and words cut off.

Ended up writing a helper to do similar to what you suggest @jurriaan . Checked the cells autowidth value, then taking in to account that, any new lines, and a bit of a buffer for whitespace at the end of each line, assign a new row hight. .... A bit (quite) flakey, but quick, and it will do the trick in the short term.

Apr 08 '14 07:04 hofdesu

+1