To Format a cell you will need to use the 'Format Cell' action of the MS Excel VBO. There is an Input parameter called 'Cell Format'
Not sure if there is a direct way to AutoFit cells. You may try the below options-
- Write a macro that will AutoFit those columns and then use the 'Run Macro' action of the MS Excel VBO
- Or write your own VBO by researching on how to use the Excel Object Model to use the AutoFit while creating a VBO.