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

当excel不同的文本值过多时,会读不到单元格文本值 #67

Open
liuxinghen opened this issue May 22, 2020 · 5 comments
Open

Comments

@liuxinghen
Copy link

test_data_2.xls.zip
读取附件中的文件,读取到253行附近开始无法获得后面文本单元格的文本值。
image

问题出现在workbook.go第118行,在读不到数据的循环中,binary.Read(buf_item, binary.LittleEndian, &size)开始返回err==EOF,但是分支并没有处理。

@hanksudo
Copy link

看來我掉這個坑了

@hanksudo
Copy link

看來我掉這個坑了

我用了最後一個 commit 的 0.0.2 版本解決了這問題。因為 Github 是 tag 0.0.1

@banfg56
Copy link

banfg56 commented Nov 13, 2020

读取某些xls 时是会存在 Cell有值但是读取为空的情况。鉴于xls很久没有更新,使用xls2csv-go 将XLS转换为 csv来处理。libxls可以下载说明文档中的版本v0.2.0
缺点就是就是目标服务器需要相应的库文件。

@hongshunanhai
Copy link

1000多行,中间有空格,读到中间后面就全乱了,不但行列不对,还出现乱码,用java的POI就没有这个问题

@shuiYe-704265085
Copy link

Yes, I forked it into my own warehouse and created a tag with the latest commit. After replacing the library in the project, I solved this problem. If you encounter the same problem, you can directly use my library
"github.com/shuiYe-704265085/xls"

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

5 participants