[Ashish Has successfully completed the online course IntroductionHas successfully completed the online course Intermediate (200)Has successfully completed the online course Basics (100)]

4 years 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 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 CertificationHas successfully completed the Advanced Certification]

4 years 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.