Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
qitianchan opened this issue Apr 4, 2019 · 7 comments
Open

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

qitianchan opened this issue Apr 4, 2019 · 7 comments

Comments

@qitianchan
Copy link

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
Copy link
Contributor

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

@kataloo
Copy link

kataloo commented Oct 28, 2019

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

@kleeon
Copy link

kleeon commented Sep 24, 2020

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

@lshiffer
Copy link

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
Copy link

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
Copy link

KiddoV commented Jul 18, 2023

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

@armanokka
Copy link

same issue

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

8 participants