xlrd 升级到2.x 之后，不支持.xlsx - Githubissues

PFCCLab / PPOCRLabel

PPOCRLabelv2 is a semi-automatic graphic annotation tool suitable for OCR field, with built-in PP-OCR model to automatically detect and re-recognize data.

105 stars 32 forks source link

xlrd 升级到2.x 之后，不支持.xlsx #45

Closed lwinhong closed 3 months ago

lwinhong commented 3 months ago

问题

如题所述，升级到2.x之后，表格数据标注无法导出

官方有给出说明 https://github.com/python-excel/xlrd

解决方案

方案1. 降级到1.2.0
方案2. 修改源码将生成excel和到处excel的路径后缀，由 .xlsx 改为 .xls，跑自己改之后的代码
- 生成路径代码大致在：
https://github.com/PFCCLab/PPOCRLabel/blob/fba5f8c56dc6a4a3e54645ade08dfe168193982b/PPOCRLabel.py#L2836
```
excel_path = TableRec_excel_dir + "{}.xlsx".format(filename)
```
- 保存时代码路径大致在:
  
  https://github.com/PFCCLab/PPOCRLabel/blob/fba5f8c56dc6a4a3e54645ade08dfe168193982b/PPOCRLabel.py#L3051
```
# load csv annotations
filename, _ = os.path.splitext(os.path.basename(image_path))
csv_path = os.path.join(TableRec_excel_dir, filename + ".xlsx")
```
- 如果是之前就已经有.xlsx 格式的excel文件了，就打开直接另存为 .xls 格式

GreatV commented 3 months ago

欢迎提交一个PR，修改一下。

GreatV commented 3 months ago

@lwinhong 修复了，麻烦review一下

47

lwinhong commented 3 months ago

@lwinhong 修复了，麻烦review一下

change xlrd to openpyxl #47

27CC8A9A

lwinhong commented 3 months ago

貌似还没合并到主线

GreatV commented 3 months ago

是的，需要code review，和更多测试。