Excel export autofit column width

[civic raft]

Is there any way to autofit column width to contain all column data on excel export? I tried with setShouldWrapText() and setShouldShrinkToFit() with no luck.

[shell steeple]

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

[civic raft]

Nothing?

[manic forge]

we dont control excel output, its a separate package

[civic raft]

Thanks. So maybe I should use laravel-export by spartner

[manic forge]

So have you done the getXlsxCellStyle() or getXlsxHeaderCellStyle() in the exporter class with openspout?

is that where you added setShouldWrapText() and setShouldShrinkToFit() ?

[civic raft]

Yes. If setShouldWrapText() is set tu true, this happens:

But I would like this

Something like setAutoFitText()

[manic forge]

i dont think there is an option in openspout, but there is an option to increase the width based on a fixed number

[civic raft]

Maybe setting page setup? There is an option fitToWidth but i dont know if that is what im searching for
https://github.com/openspout/openspout/blob/4.x/docs/documentation.md#page-setup

[lethal locust]

@civic raft did you solve it?

[civic raft]

I did not. Right now I'm doing it manually on the excel.

[lethal locust]

    public function getXlsxCellStyle(): Style
    {
        return (new Style())
            ->setShouldWrapText(false);
    }

    public function getXlsxHeaderCellStyle(): Style
    {
        return (new Style())
            ->setShouldWrapText(false);
    }

[civic raft]

Not working 😦

[haughty fractal]

In a standard OpenSpout setup, thre is a way to configure the 'writer' options and have fixed widths there:
use OpenSpout\Writer\XLSX\Options;
$writerOptions = new Options();
$writerOptions->setColumnWidth(20, 1); //sets to 20, column 1
$writerOptions->setColumnWidth(30, 2); //sets to 30, column 2
.... and so forth...
so you can initialize as
$writer = new \OpenSpout\Writer\XLSX\Writer($writerOptions);

If only we could inject these type of writer options into the Filament Exporter ...I am looking for a way to do that right now.. I will come back here if find something useful .

[haughty fractal]

Community friends, I am glad to let you know that I developed a solution and solved the issue above to inject those 'XLSX\Options' as needed. I am about to create a new PR for this enhancement; be back with the a link and solution in a bit 😀

[haughty fractal]

Here it is my friends, hope this helps whoever else needs it https://github.com/filamentphp/filament/pull/14411
There you can see the two file modifications needed in case you want to test it out.

Since this is my first PR to an open source project ever , any feedback is truly appreciated, I tried my best and followed the procedures described in the Filament docs for contributing to the development, and that was harder for me than the actual solution to the problem 😂 Living and always learning something new!

[haughty fractal]

If somebody else thinks this is a good idea, show some love in the pr above, please comment on it, maybe it could be implemented differently. I was even thinking in setting directly on the ExportColumn object itself, something like a ' ->XlsxWidth() ' in method in the object... anyway, in the meanwhile my users in one of my apps are happy that they can export pretty neat looking excel documents now without messing with column widths

[trim schooner]

I could certainly be wrong and I totally appreciate your efforts, but my question is what is the value to core filament about the appearance of a data export. In my mind the data is more important than the appearance of the data.