Excel sheet turns out messy

Help Studio
1

What is the best way to prevent this from happening?
I am sending one Excel sheet to queue and uses transaction items to build new datatable and writing it to new Excel file. Everything works fine, but when I open the result, the Excel sheet is messy.
How can I avoid this?

image

2

If there are extra spaces in the values, you can use .Trim, when writing to your DT.
Once you create your new excel, format the columns using Balareva excel tools, you can autofit, justify, format cell type, etc.

3

hi @bjorn2390,

it is very easy just use a vbscript their by using invoke vba activity in the script justify the formatting and it will work as expected.

Thanks
Shikhar