Skip to content

Need to get cell type or cell value type #417

@Mindzy

Description

@Mindzy

Description
GetCellStyle() only gets the style index, which is integer, of a cell. And the style index can't be related to a certain cell format. I need to get the cell format, like general, date, time, percentage, number, text. Or cell value type like int, string, float64, bool. Since Excel stores date and time as int and float, date or time format can be return as float.

Describe the results you expected:

-- A B
1 Mike 23
2 Sarah 20

GetCellType(sheet, "A1")
string
GetCellType(sheet, "B1")
int

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions