You can do something like this :

// Autofit all columns according to their text content
cols, err := f.GetCols(sheetName)
if err != nil {
        return err
}
for idx, col := range cols {
        largestWidth := 0
        for _, rowCell := range col {
                cellWidth := utf8.RuneCountInString(rowCell) + 2 // + 2 for margin
                if cellWidth > largestWidth {
                        largestWidth = cellWidth
                }
        }
        name, err := excelize.ColumnNumberToName(idx + 1)
        if err != nil {
                return err
        }
        f.SetColWidth(sheetName, name, name, float64(largestWidth))
}

Inspired from tealeg/xlsx#618
It just works for string cells.

I'm not sure how it should be implemented into this library though. I did not find an effective way to get all cells for a column.

Uh oh!

is there a way to auto fit columns? #92

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions