Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text format on excel export

I have and ID field that is formatted to look like a hyperlink (blue, underlined). I there an easy was to make this turn back to regular black text when exporting to excel? Right now it looks like a hyperlink in excel.

Thanks!

3 Replies
Not applicable
Author

Guess i'm going to have to go the macro approach?

Not applicable
Author

anyone.... going once...

erichshiino
Partner - Master
Partner - Master

You could create another object without the formatting but I think you would still need a macro.

I created one for this case. I export the object data to excel (it goes with the formatting).

After this, I send commands to excel to format it as I want.

Please, check sample app attached.

Best Regards,

Erich