Suggestion: able to set cell text and background colors

[marcrobledo]

First of all, thanks for this library, it's what I really was looking for: a lightweight single file library for basic xlsx building in PHP.

There is a little feature that is missing and is a must IMHO: being able to set cell text and background colors.

There could be a bunch of predefined basic colors defined in the internal styles.xml. Then user could just type:
['My label', '<red>My value</red>']
while adding cells to the array.

[NeuwenWolf]

I'd like to also express that this would be useful.

[marcrobledo]

I've made my own little mod for red color, as it was the only I needed. But it should be fairly easy to add more predefined colors.

[NeuwenWolf]

Is there any chance you'd be willing to share what you've got so far on that front?

[marcrobledo]

I can, but it's just a little hack for a single color.
Adding other predefined colors shouldn't be hard. However, as simplexlsxgen is coded, it would be hard to add custom colors. It would need an overhaul in the styles xml building in order to make it possible.

@shuchkin are you interested on this?

[shuchkin]

class MyXLSXGen extends SimpleXLSXGen {}

[ProjectLinde37]

class MyXLSXGen extends SimpleXLSXGen {}
Where can we find de class MyXLSXGen ?

[shuchkin]

:)
you have to write this class

[shuchkin]

current supported formatting
https://github.com/shuchkin/simplexlsxgen#formatting

[mrjemson]

Have added text color capability in my fork and submitted a pull request for the same.
https://github.com/mrjemson/simplexlsxgen

Have done some basic testing with adding fill options also and will add this at a future date.

NB: Great library @shuchkin very elegant.

[mrjemson]

Have also now added background color fill options into above fork.