search

natergj / excel4node

Node module to allow for easy Excel file creation
MIT License
1.38k stars 215 forks source link

How to show text in color filled cell? #289

Open fahadsubzwari924 opened 5 years ago

fahadsubzwari924 commented 5 years ago

I am applying background color to group of columns and rows like this

var greenBgColumnsRows = wb.createStyle({ font: { color: 'black', size: 12, }, fill: { type: 'pattern', patternType: 'solid', bgColor: '#33FF35', // HTML style hex value. defaults to black fgColor: '#33FF35' }, })

var textStyle = wb.createStyle({ font: { color: 'black', size: 16, } })

ws.cell(11, 4, 13, 13) .string('') .style(greenBgColumnsRows)

And writing text to the specific cell in between above styled cell which is cell number 11,7 like this

ws.cell(11, 7) .string('10 Min-Mittelwerte') .style(normalBoldStyle)

But in excel file there is not text showing in the cell number 11,7. Only background color is showing.? How can i solve it?

natergj commented 5 years ago

@fahadsubzwari924, I am unable to replicate this issue. I am using this code sample. https://gist.github.com/natergj/0ddb5c287cbba42c7cff614728c47337 If you are still having this issue, please provide a complete gist that demonstrates the issue.