Hi Folks,
I am generating an Excel report like below -
Notice how column 1 and column 2 are set to indent on the left and column 3 has indent to the right. The Excel format is haywire due to this issue. I want all number values to be printed on the right side.
Is there a quick fix to this particular formatting issue ?
Column1 and 2 are in separate datatable as text and Column 3 is in a separate datatable as double.
Hi @shikharno.7
You can use the format cells activity it has to be use inside Use excel file activity.
→ Click on Set format option and go to alignment you can select your alignment from the dropdown.
Check the below image for better understanding,
Hope it helps!!
It worked, thanks a mil @mkankatala
It’s my pleasure… @shikharno.7
Happy Automation!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
