Magicodes.IE icon indicating copy to clipboard operation
Magicodes.IE copied to clipboard

wps 编辑后execl导入报错 The given key 'rId1' was not present in the dictionary

Open HeHoney opened this issue 1 year ago • 4 comments

execl 导入是数据存在想邮箱之类的数据,用wps 编辑过后,导入就会报这个错误, The given key 'rId1' was not present in the dictionary
如果用微软的重新另存为一个文件又不会出现这个错误

HeHoney avatar Dec 09 '23 03:12 HeHoney

派送计划模板(1).xlsx 这是报错的文件

HeHoney avatar Dec 09 '23 03:12 HeHoney

你把超链接那一列设置取消超链接就可以导入了

txbauo avatar Jan 22 '24 02:01 txbauo

我调试了源代码,超链接单元格只要有值是一样就会出现这个异常. 在ExcelWorksheet这个代码文件1183行能获取到两个一样的rid

txbauo avatar Jan 22 '24 02:01 txbauo

还真是,只能取消超链接吗

huguodong avatar Jun 27 '24 08:06 huguodong