动态记录一下今天遇到的问题,
描述:
读取Excel时出现以下错误Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.
解决方案:
To resolve this. it seemed to be caused by the formatting of some of the data within cells in my table.Namely emails
had been converted into hyperlinks.Once I formatted thema s plain text.It stopped this issue.
Just need to be careful when modifying\adding cells manually that may convert data to hyperlinks.
这个问题似乎是表中单元格内的一些数据的格式造成的。即电子邮件已被转换为超链接。把链接格式化成纯文本。可以这个问题。
只是在手动修改或添加可能将数据转换为超链接的单元格时需要小心。