Question
How to expand a hiperlinked text in Excel?
+11- Supporter
I have a hiperlinked text in an Excel spreadsheet, and I want to load this spreadsheet into an Oracle table but the hiperlinks saved in the table, not the text in the Excel cell. Can I do this in FME? I am using FME 2013.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi,
not quite sure if I'm understanding, but have you looked at this previous answer? The solution is valid for both reading and writing formulas.
David
+11- Supporter
David,
After some research I found FME does not "expand" underlying hyperlinks on the fly. I just used an excel macro to expand the hyperlinks before loading it into Oracle.