Filament•2mo ago

Excel export autofit column width

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.

13 Replies

Rome•2mo ago

Nothing?

Dan Harrin•2mo ago

we dont control excel output, its a separate package

Rome•2mo ago

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

Dan Harrin•2mo ago

So have you done the getXlsxCellStyle() or getXlsxHeaderCellStyle() in the exporter class with openspout? is that where you added setShouldWrapText() and setShouldShrinkToFit() ?

Rome•2mo ago

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

Rome•2mo ago

But I would like this

Rome•2mo ago

Something like setAutoFitText()

Dan Harrin•2mo ago

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

Rome•2mo ago

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

GitHub

openspout/docs/documentation.md at 4.x · openspout/openspout

Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way - openspout/openspout

Gush•2mo ago

@Rome did you solve it?

Rome•2mo ago

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

Gush•2mo ago

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

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

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

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

Rome•2mo ago

Not working 😦

Gaming

Programming

Excel export autofit column width