Style cell in sheetJS

Ashish
Participant
Has successfully completed the online course Introduction
Has successfully completed the online course Intermediate (200)
Has successfully completed the online course Basics (100)
4 years, 6 months ago #24170

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.
Jennifer Häfner
Moderator
Has successfully completed the online course Intermediate (200)
Has successfully completed the online course Advanced (300)
Has successfully completed the online course Basics (100)
Has successfully completed the online course Advanced (310)
Has successfully completed the online course Advanced (320)
Has successfully completed the Intermediate Certification
Has successfully completed the Advanced Certification
4 years, 6 months ago #24296

Up
-1
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.