search

extrame / xls

Pure Golang xls library
Apache License 2.0
331 stars 210 forks source link

Col(i) return empty string even when there has value #56

Open qitianchan opened 5 years ago

qitianchan commented 5 years ago

When I read the data from xls file with function *func (r Row) Col(i int) string** , I got empty string in some rows. I found that because I insert in character in a cell which is expect a number. I open xls file on macbook, and use WPS office.

sergeilem commented 5 years ago

Try this fork: https://github.com/sergeilem/xls

kataloo commented 5 years ago

Having the same issue. Sergilem's fork also returns empty string.

kleeon commented 4 years ago

Same issue here. This happens only for some documents. I also tried sergeilem's fork and it didn't change anything.

lshiffer commented 3 years ago

Any fix or work around for this?

The very first column of the very first row will return a string. But then everything else returns empty. Have no idea what the issue is.

dr2chase commented 3 years ago

I see the same problem -- first row okay, the rest it has the right number of columns but they are all empty. If it matters, I got this xls file by exporting a query from Access, and it reads just fine into Google Sheets.

KiddoV commented 1 year ago

Any update on this? I am having the same issue.

armanokka commented 1 year ago

same issue