Re: Losing format when export to excel - Qlik Community

alec1982 · ‎2014-06-20

Hi,

Is there anyway to keep the format of a straight table when exporting to excel?

Thxs,

Clever_Anjos · ‎2014-06-20

Formating every column using NUM() will help

alexandros17 · ‎2014-06-20

If your environmental variables (the ones you find in main script) are equal to those of your excel installation then export data will work exactly

its_anandrjs · ‎2014-06-20

If columns are Text then use Text(FieldName) or if it is Number Then Num(FieldName).

PrashantSangle · ‎2014-06-21

Hi,

For which field you are getting issue?

Kindly share screenshot or sample excel file where Format is changing.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂