xls icon indicating copy to clipboard operation
xls copied to clipboard

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

Open qitianchan opened this issue 5 years ago • 7 comments

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.

qitianchan avatar Apr 04 '19 14:04 qitianchan

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

sergeilem avatar Apr 04 '19 14:04 sergeilem

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

kataloo avatar Oct 28 '19 14:10 kataloo

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

kleeon avatar Sep 24 '20 09:09 kleeon

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.

lshiffer avatar Dec 10 '20 06:12 lshiffer

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.

dr2chase avatar Feb 21 '21 21:02 dr2chase

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

KiddoV avatar Jul 18 '23 16:07 KiddoV

same issue

armanokka avatar Oct 13 '23 18:10 armanokka