exported excel cell coloring based on cell value

geethunimesh

[https://datatables.net/extensions/buttons/examples/html5/excelCellShading.html]
I followed this link. But it didn't get worked. Please help me to track my issue.

allan

I think I've introduced a bug into Buttons by mistake - sorry. I'll post back when I've checked that out.

Allan

HPB

@allan
Not a bug, it's a feature.

In earlier versions of buttons all cells would be rendered as:

<c t="inlineStr"><is><t>Value</t></is></c>

Now you identify numbers and render them as followed:

<c s="57"><v>Value</v></c>

The example has $('is t', this) as selector, and will not select the cells with the recent versions of buttons.
All you need to do is change the selector in the example to $('v, is > t', this) and you're done.

geethunimesh

Yeah, That's right.
It worked. And I got this
live.datatables.net/qokabeve/17/edit

allan

Actually - it was a bug in the example, not the library. This is the commit that fixes it. I'll publish the updated example shortly.

Thanks,
Allan