Whereas studying .xls file with golang utilizing ReadAllCells perform from xls package deal.
Hyperlink of perform :-
Subject – For strings it really works positive , however for the cell having int worth get’s modified to this point&time format.
ex:- (1 get modified to 1900-01-01T00:00:00Z)
How we’ll cope with this drawback ?
It appears to be like like that occurs when the cell format is one in every of these quantity codecs:
} else if 14 <= fNo && fNo <= 17 || fNo == 22 || 27 <= fNo && fNo <= 36 || 50 <= fNo && fNo <= 58 { // jp. date format
There’s a remark within the supply code that references this specification doc and I discovered the precise codes on pages 174-175. The code appears to be like proper to me.
Are you able to examine format of the cells within the .xls file to see in the event that they’re one of many date codecs?
