xlsx.js icon indicating copy to clipboard operation
xlsx.js copied to clipboard

Cell Width, Text Wrap, Font/Background Color, Table Options

Open tbenbrahim opened this issue 11 years ago • 1 comments

I noticed that the library only outputs column widths if autowidth is set for the column, and ignores any auto calculated widths. This fixes that issue by always writing the column, and also gives the user greater control by allowing an optional cell width property. Also added a wrapText (boolean) cell property to support cell text wrapping. Added table options, worksheet.table can still be specified as boolean, or object with optionional topLeftRow, topLeftColumn, style, stripeColumns and stripRows properties (for example for a table starting at A3 rather than A1, {topLeftRow: 3, topLeftColumn:0, style:'tableStyleNone'} Added support for background fill via backgroundColor property Added support for font color via the fontColor property Fixed bug with string detection, " " was not detected as a string (isFinite returned true)

tbenbrahim avatar Jan 13 '14 19:01 tbenbrahim

+1

jfroffice avatar Mar 23 '14 16:03 jfroffice