specify data types for columns when reading excel

[AmjadHussainSyed]

Description
Is it possible to specify data types for the given columns such as i want few columns to be read as date and few of them as tring

Data is very confidential so not posting any of the content here

Steps to reproduce the issue:

1. read the excel file
2. getrows
3. column values are returned as float values.

Describe the results you received:
column values are returned as float values.

5.90606077E+08 | 966.0

Describe the results you expected:

590606077 | 966

Output of go version:

go version go1.15.6 darwin/amd64

Excelize version or commit ID:

v2.3.2

Environment details (OS, Microsoft Excel™ version, physical, etc.):
macOS Big Sur version 11.2.1
google sheets

[alkanna]

This problem has been ignored for a long time.
I am dealing with this issue with excel sheets exported from google sheets, with cells set as "plain text" in google sheets.
Numbers are read as float for some reason.

[xuri]

Sorry for may late reply. This library support GetCellType to get cell data type since v2.5.0, so you can convert the cell value from string to any data type you need. Please reference issue #414, and #520 for information.