views:

41

answers:

0

Is there a way to write a hyperlink formula to an excel file using XMLWriter? In other words, I am trying to create an Excel file using XMLWriter and it works well except that my URL is merely a string and I want it to be a hyperlink. I tried writing =HYPERLINK(A1), for example, where A1 is the url string (thinking I could just hide the first one), but it does not work. Thanks so much!