Sheetjs: Wrap text by column

[john-yick]

Is there anyway to wrap text per column similar to excel?

[sgrogov]

Yes, specify cell style like that

cell.s = {
  alignment: {
    wrapText: '1', // any truthy value here
  },
};

[lujuliang]

Hey @sgrogov ， could you kindly tell me how to add the style to merged cells or add the style to a range cells. thank you very much

[sgrogov]

Hi @lujuliang.

As far as I remember for merged cells you have to set your styles to the top left cell. But for borders styling you have to set styles to each cell just as if they were not merged.
And about range of cells just set styles to each cell.

Hope it's clear :)

[atljoseph]

cell.s = {
  alignment: {
    wrapText: '1', // any truthy value here
  },
};

Plain does not work.

Please provide a complete example, or documentation ...

Documentation on how to use your product EFFECTIVELY would be welcomed :)

[ugonnanwosu]

@lujuliang cell styling isn't supported in the core library. A fork exists with documentation for cell styles here