Question about reading .xls file with golang

Aadi · February 15, 2023, 3:28am

While reading .xls file with golang using ReadAllCells function from xls package.
Link of function :-

extrame/xls/blob/v0.0.1/workbook.go#L268


      
          }
          
          
//Get the number of all sheets, look into example
          func (w *WorkBook) NumSheets() int {
          	return len(w.sheets)
          }
          
          
//helper function to read all cells from file
          //Notice: the max value is the limit of the max capacity of lines.
          //Warning: the helper function will need big memeory if file is large.
          func (w *WorkBook) ReadAllCells(max int) (res [][]string) {
          	res = make([][]string, 0)
          	for _, sheet := range w.sheets {
          		if len(res) < max {
          			max = max - len(res)
          			w.prepareSheet(sheet)
          			if sheet.MaxRow != 0 {
          				leng := int(sheet.MaxRow) + 1
          				if max < leng {
          					leng = max
          				}

Issue - For strings it works fine , but for the cell having int value get’s changed to date&time format.

ex:- (1 get changed to 1900-01-01T00:00:00Z)

How we will deal with this problem ?

skillian · February 15, 2023, 12:33pm

EDIT: I literally took my first sip of coffee for the day and it occurred to me to check that project’s issues. Looks like there’s an issue here that custom numeric formats are incorrectly assumed to be dates.

It looks like that happens when the cell format is one of these number formats:

} else if 14 <= fNo && fNo <= 17 || fNo == 22 || 27 <= fNo && fNo <= 36 || 50 <= fNo && fNo <= 58 { // jp. date format

There is a comment in the source code that references this specification document and I found the specific codes on pages 174-175. The code looks right to me.

Can you check format of the cells in the .xls file to see if they’re one of the date formats?

system · May 16, 2023, 12:34pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.