Skip to main content
Question

How to expand a hiperlinked text in Excel?

aguan
Contributor
Forum|alt.badge.img+10
  • aguanContributor
  • Contributor
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.

2 replies

david_r
Evangelist
  • david_rEvangelist
  • December 10, 2013
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
aguan
Contributor
Forum|alt.badge.img+10
  • aguanContributor
  • Author
  • Contributor
  • January 3, 2014
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.

Reply


Most helpful members this week

Community Stats

30,846
Posts
116,935
Replies
38,669
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.