func autofit()

in internal/renderers/excel/excel.go [42:70]


func autofit(f *excelize.File, sheetName string) error {
	cols, err := f.GetCols(sheetName)
	if err != nil {
		return err
	}
	for idx, col := range cols {
		largestWidth := 0
		for _, rowCell := range col {
			cellWidth := len(rowCell) + 3
			if cellWidth > largestWidth {
				largestWidth = cellWidth
			}
		}
		if largestWidth > 255 {
			largestWidth = 120
		}

		name, err := excelize.ColumnNumberToName(idx + 1)
		if err != nil {
			return err
		}
		err = f.SetColWidth(sheetName, name, name, float64(largestWidth))
		if err != nil {
			return err
		}
	}

	return nil
}