How to format columns without specifying the row numbers in the cell range? (Exporting template with only a header row)

[martincarlin87]

Currently I have:

public function columnFormats(): array
{
    $lastColumn = Coordinate::stringFromColumnIndex(count($this->headings()));

    return [
        'A1:' . $lastColumn . '1000' => NumberFormat::FORMAT_TEXT,
    ];
}

Which works fine, but I don't want to specify the 1:1000 part, I'd rather just be able to say, format all columns in this range, or even the entire sheet if it's easier, .e.g A:AA rather than A1:AA1000.

The reason for this is, I'm exporting a template, so the exported file only has a header row, so any other formatting I try doesn't work since formatting is only applied to exported rows, which I don't have.

Hope that makes sense.

Cheers,
Martin

[patrickbrouwers]

You can just specify the column letter, it will use the highest row to format all cells in the column

return [
        'A' => NumberFormat::FORMAT_TEXT,
    ];

[martincarlin87]

Sorry, I didn't see this reply! I ended up with another work around, but can this is a lot user.

Thanks again.