Setting cell's type (format)

[konart]

According to docs the SetCellValue should insert values of the specified data formats (it basically call appropriate SetCell[T] in a switch`.

However I always get "general" as cell's type\format. How to you set it to text or any other type explicitly?

example from my project:

func writeRow(elements []any, rowNum int, file *excelize.File, sheetName string) error {
	for i := range elements {
		cname, err := excelize.ColumnNumberToName(i + 1)
		if err != nil {
			return err
		}

		cell, err := excelize.JoinCellName(cname, rowNum)
		if err != nil {
			return err
		}

		if err := file.SetCellValue(sheetName, cell, elements[i]); err != nil {
			return err
		}
	}

	return nil
}

[konart]

To answer my own question: this is done via SetCellStyle() method like so:

		cell, err := excelize.JoinCellName(cname, rowNum)
		if err != nil {
			return err
		}

		s, err := file.NewStyle(&excelize.Style{NumFmt: textNumberFormat})
		if err != nil {
			return err
		}

		if err := file.SetCellStyle(sheetName, cell, cell, s); err != nil {
			return err
		}

		if err := file.SetCellValue(sheetName, cell, elements[i]); err != nil {
			return err
		}

https://xuri.me/excelize/en/style.html#number_format