如何使用友好名称格式化csv文件中的HYPERLINK以进行Excel导入(How to format HYPERLINK in csv

如何使用友好名称格式化csv文件中的HYPERLINK以进行Excel导入(How to format HYPERLINK in csv-file for Excel import using friendly name)

我有一个csv文件，看起来像这样：

value1;value2;=HYPERLINK("http://somelink";"linkdisplay");value3

当我将其导入Excel 2013时，csv将以分号分割，同时也会拆分链接和友好文本之间的超链接。 我试图将Windows上的List分隔符更改为逗号，这实际上也改变了超链接的要求，用逗号分隔友好文本，所以没有运气。 尝试添加如何在CSV格式的文件中编码超链接中提到的引号？ 那对我不起作用。

有人为此得到了解决方案吗？

I have a csv-file that looks something like this:

value1;value2;=HYPERLINK("http://somelink";"linkdisplay");value3

When I import this to Excel 2013, the csv is split on semicolon, also splitting the hyperlink between the link and the friendly text. I have attempted to change List separator on Windows to comma, that actually also changed the requirements for the hyperlink to split the friendly text with a comma, so no luck there. Attempted to add quotes as mentioned in How to encode a hyperlink in CSV formatted file?, that did not work for me.

Someone got a solution for this?

最满意答案

对于文件：

String hyperlinks = "\"=HYPERLINK(\"\"file://" + DocumentDataType.strDirectoy + docName + "\"\",\"\""+ DocumentDataType.strDirectoy + docName+ "\"\")\"" + ",";

对于网站：

String hyperlinks_SourcePath = "\"=HYPERLINK(\"\"http://" +ipAddress+":"+portNumber+"/WorkplaceXT"+ "\"\",\"\""+sourcePathFinal+ "\"\")\"" + ",";

For file:

String hyperlinks = "\"=HYPERLINK(\"\"file://" + DocumentDataType.strDirectoy + docName + "\"\",\"\""+ DocumentDataType.strDirectoy + docName+ "\"\")\"" + ",";

For website:

String hyperlinks_SourcePath = "\"=HYPERLINK(\"\"http://" +ipAddress+":"+portNumber+"/WorkplaceXT"+ "\"\",\"\""+sourcePathFinal+ "\"\")\"" + ",";