Style cell in sheetJS

[Ashish]

Hi, I am using Sheet JS to export JSON data as excel. I have successfully created an excel file, but I am unable to apply styles on the cell.

I have used:
// code-
ws[‘B2’].s= { alignment: {textRotation: 90 },font: {sz: 14, bold: true, color: ‘#FF00FF’ }, patternType: ‘solid’,fgColor: { theme: 8, tint: 0.3999755851924192, rgb: ‘9ED2E0’ },bgColor: {indexed: 64 }};
//
but it is not working.

Please help me, I am stuck on this.

• This topic was modified 3 weeks, 6 days ago by chris.

[Jennifer]

Up

0

Down

Hi Ashish,

When working with custom CSS for OpenUI5 widgets, it’s often necessary to add the term ‘!important’ after your CSS to make sure the standard CSS is overwritten. For example:

.yourCustomClass{
background-color: black!important;
margin-top: 2rem!important
}

Maybe this can solve your problem.

[Author]

Posts