In a similiar situation I created a new object "Read lines with encoding"Have to supply the correct encoding to read the file. Like EncodingName = "iso-8859-1"The objected was based on standard action "Read lines from file" in Utility - File Manageme...
Can use the MS Excel VBO action Run Macroand use the following macro "ExcelFormatting" as a start. Change the cell references A:G and A1:G1 as needed or make them dynamic.
Sub ExcelFormatting()
'Autofit columns
Columns("A:G").AutoFit...
Here is an alternative solution if you are able to run Excel macros.* Run Excel macro from Blue Prism.* Use VBA in the macro to edit the layout.Split the VBA code into 2 subsUpdateExcel - Macro/sub called from Blue Prism Action with Run Macro ...
