span8
span4
span8
span4
I have problems with foreign characters (åäö ÅÄÖ) in hyperlinks using the excel writer.
This works(no foreign characters in hyperlink path):
file_path =1312-P11-47-00054.pdf
file_path.hyperlink = C:\work\table_extraction\fme\template_files\FME_2019_04_24-14_38_13.3\xml\09_Administrativa foreskrifter\1312-P11-47-00054.pdf
This does not work(foreign characters in hyperlink path):
file_path =1312-P11-47-00054.pdf
file_path.hyperlink = C:\work\table_extraction\fme\template_files\FME_2019_04_24-14_38_13.3\xml\09_Administrativa föreskrifter\1312-P11-47-00054.pdf
In the Excel output I always get something like this when hovering the hyperlink when the foreign characters are in the path:
file:///C:\work\table_extraction\fme\template_files\FME_2019_04_24-14_38_13.3\zz.xlsx
The excel file seems to link to itself which is wrong.Its quite strange that the start of the chop off is the \xml\.
I have tried many different things with encodings etc but failed so far.Anyone have any ideas?
Hi@krisvewsp.Thanks for raising this issue.Unfortunately,this is a known issue.We will inform you when it's fixed,by updating this thread.
In the meantime,I'm not sure what a good workaround would be.I imagine you probably don't want to change your file directories to only have English characters.Maybe as a temporary measure,write these links as a string attribute,to ensure the information is present on your spreadsheet,and when we have the hyperlink issue fixed,you can rename that string attribute to be
Thanks for confirming this as a bug!
Yes,you are correct that I don't want to rename the local directories to only english characters since the original data is coming from a sharepoint like system.I dont really want to missguide the users by changing the path locally to something else that they are already familiar with in the their sharepoint solution.
Maybe you could use a (series of) StringReplacers to find the foreign characters and replace them with 'normal' characters if they do work.
Thanks for the suggestion!Even if I fixed the string to not contain the foreign characters I would also need to rename all the local folders to not have the foreign characters and that is not an option.See my comment on xiaomengat亚搏在线safe post above.She has confirmed it as a known bug.
Hyperlinks using a dynamic excel writer3 Answers
Dynamic Excel Writer datatype3 Answers
Styling Excel cells in the Writer9 Answers
Create Hyperlinks in Excel?3 Answers
© 2019 亚搏在线Safe Software Inc |Legal