Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
310
Applying styles to more than one cell.
posted

Hello I am trying to apply style to some cells in a row. I tried the below row and I get error 0x800a139e - JavaScript runtime error: Invalid Enum Argument: patternStyle value: 0

worksheet.rows(2).cells(0).cellFormat().fill($.ig.excel.CellFill.createPatternFill("lime", "gray", $.ig.excel.FillPatternStyle.default));

worksheet.rows(1).cells(1).cellFormat().fill($.ig.excel.CellFill.createPatternFill("lime", "gray", $.ig.excel.FillPatternStyle.default));

But I am able to apply style for one cell in a worksheet . If I try to apply for more than one cell in a row or in different rows then I get the mentioned error.


Please help.