Actual Excel Themes

[myoder020]

Any plans on implementing the theming we get in Excel, like the actual table styles?
I tried applying a theme using the cellStyle but the theme index number isn't the same as what we get in Excel so I'm having to guess.

Also any way to enable filtering on a column?

[ChronicStone]

Hi @myoder020 regarding excel themes, I'm not sure, the library uses xlsx-js-style, a fork of SheetJs supporting cell styling internally, so you should look into their docs / issues to see if that's possible.

Regarding column filtering, I'm not sure what you mean by that. Can you give me a bit more details, and explain what you're trying to achieve / show what kind of API you would expect?

[myoder020]

Filter:

Just trying to do something that you can do in a normal excel worksheet

[ChronicStone]

I think that might be possible, just checked SheetJs docs and looks like it supports autoFilter. I have a bit of spare time in about 30 minutes, I'll try to give it a shot.

I have a few concerns, seems possible only for mono-tables sheets and I don't know how it will behave with merge cells.

If you have an example excel file I can use for reference that'd help a lot @myoder020

[myoder020]

My use case is just for basic reports.
They don't involve merged cells or sheets with multiple tables.

[ChronicStone]

@myoder020 Yeah but I need to make sure this does not break the library on more complex cases. The basic use case seem to work, I just need to fine tune a few things

[ChronicStone]

That feature got a few caveats, I'll need to polish this, will try to ship it before the end of the week if I can find workaround for the edge cases

[myoder020]

Thanks for looking into it