Search code examples
node.jscellxlsxsheetjs

Does SheetJS/xlsx (nodejs module) have functionality to access Excels cell style (b/i/u/s)?

This is more of a general question then anything else.

Am I correct in assuming that xlsx/sheetjs does not allow reading the cells style?

I can access cell.h, which returns the cells string, with style ie.<b>hello</b> world, but I can not access cell.style which would return bold (cell.s returns the style of background and foreground, but not the cells style as such (bold,italic,underline etc)).

As far as I understand this option is only available in pro?

sources: so, gh1, gh2

Solution

  • sheetjs/xlsx does not allow access to cell styles. It is only allowed in pro version (xlsx-pro).

    I got confirmation in this discussion / comment thread.