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.
Page 1 / 1
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
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.