java - 如何将 SMB 文件链接添加到单元格中？

Question

我有一个文件存储在服务器中，路径如下:\\myserver\folder\myfile.txt

如何将此 SMB 地址放入带有超链接的单元格中？

Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_FILE); 
link.setAddress("What to write here?");

当我使用以下代码时:

link.setAddress("\\\\myserver\\folder\\myfile.txt");

它返回错误:

Caused by: java.net.URISyntaxException: Illegal character in path at index 0: \\myserver\folder\myfile.txt
at java.net.URI$Parser.fail(Unknown Source)
at java.net.URI$Parser.checkChars(Unknown Source)
at java.net.URI$Parser.parseHierarchical(Unknown Source)
at java.net.URI$Parser.parse(Unknown Source)
at java.net.URI.<init>(Unknown Source)
at org.apache.poi.xssf.usermodel.XSSFHyperlink.validate(XSSFHyperlink.java:240)
... 2 more

Answer 1

您引用的是 UNC 路径。我不知道 UNC 与 SMB 有何关系，但我成功地使用了以下代码

CreationHelper createHelper = workbook.getCreationHelper();
Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_FILE);
link.setAddress((new File("\\\\myserver\\folder\\myfile.txt")).toURI().toString());
cell.setHyperlink(link);