Exporting Issue To Excel Sheet

[dineshm030]

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.

[Chanty4u]

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.

[vardhancse]

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.