fmp12 export to xlsx and get the hyperlink on it

[Franco]

i export a field text that contain "www.abc.com" using the xlsx format, the cell contain "www.abc.com" but it doesn't work as hyperlink, jusy copy it in to a new cell and it became a hyperlink.

 

How to get the hyperlink directlly from filemaker export?

 

Thank to all for the attention.

Franco

[Wim Decorte]

You would probably have to do an export to XML and write an XSLT stylesheet to apply the correct format.

Not a trivial thing though

 

Or perhaps do some post-processing.  On windows it might be possible to use a VBscript generated from FM to instruct Excel to treat the column as hyperlink.