topic Exporting Issue To Excel Sheet in QlikView

Exporting Issue To Excel Sheet

dineshm030 — Tue, 27 Mar 2018 04:31:59 GMT

Hi Legends,

I have created one table box. I aligned the all values in CENTER alignment in that object. While I am exporting to excel sheet it will be aligning default. I need while exporting it should be in CENTER alignment in EXCEL SHEET. Kindly please help me.

Thanks in advance.

Re: Exporting Issue To Excel Sheet

Chanty4u — Tue, 27 Mar 2018 04:46:11 GMT

i think you need macro for this.

because as per data text will align to left side number will treat as right side thats the reason you are unable to get it.

Re: Exporting Issue To Excel Sheet

vardhancse — Tue, 27 Mar 2018 06:03:24 GMT

Hi,

Once can try with straight table by doing all formatting changes.

Else, All formatting changes will be applicable only to QV but not when we export to excel.

Post exporting we need to so some formatting changes as per the requirement.