Styling rows and header

[rap2hpoutre]

First step, just two methods:

• apply a style to all rows
• apply a style to header row

Something like styleRows and styleHeader (or maybe rowsStyle and headerStyle...)

See: http://opensource.box.com/spout/docs/#styling-rows

[elminson]

I will love to work on this :)

[gsailland]

Please! I really need this!
Any temporary method for column or row or cell styling?
Font color, background or any styling option available?
I need To style header particularly.
And the first row is by default a list of [0-n] cells?
Is it possible to get rid of it?
Is it possible to use Spout functions as it is a dependency of fast-excel?

[rap2hpoutre]

Hi @GregoireSailland. Currently, there is an open PR for this: #61, but I asked for changes in the review.

That being said, if you want more customization, you can fallback to Laravel Excel.

EDIT: @elminson has pushed some changes after the review

[rap2hpoutre]

Oops. Sorry @elminson I did not saw that some fixes were pushed.

[elminson]

no problem! just take a few minutes to review it :)

[rap2hpoutre]

@GregoireSailland Thanks to @elminson work, we added a headerStyle method in FastExcel. You can use it like this:

use Box\Spout\Writer\Style\StyleBuilder;

$style = (new StyleBuilder())
    ->setFontBold()
    ->setBackgroundColor(Color::YELLOW)
    ->build();

(new FastExcel(User::all()))
    ->headerStyle($style)
    ->export('my-file.xlsx');

Reference: http://opensource.box.com/spout/docs/#styling-rows

[gsailland]

Nice! Thank you!

[rap2hpoutre]

Available in v0.11.0