How to expand excel column so values can be visible

Help Studio
, ,
1

Hi All,

I am converting excel to pdf , so after coverting i am getting data as below,

image

Please help

1 Like
2

You can use vba or use direct actions using hotkeys –
Ctrl+A
then Alt+h+o+i

3 Likes
3

@amruta_pawar You have to open the particular excel file (use start process activity) and use send hotkeys.

  1. Ctrl+A — Use this hotkeys to select all in the excel file.
  2. ALT + H + O + I — Use this hotkeys for autofit column width.
  3. ALT + H + O + W — Use this Hotkeys for manually entering column width for each column. you will have manually enter the column width for each column and resolve it.
2 Likes
4

how to use vba, as i dont want to open file

5 
Sub mac1()

Dim sht As Worksheet
ThisWorkbook.Worksheets("Sheet2").Cells.EntireColumn.AutoFit

End Sub

save it in text file
then use Invoke VBA activity
enter parameter as
image

change Sheet name as per your requirement

6

getting error as
Invoke VBA: Programmatic access to Visual Basic Project is not trusted

7

@amruta_pawar

Please check below thread to resolve this issue.

8

Do this steps
1.

image
image858×146 13.4 KB

2.
image
image222×531 2.65 KB

3.
image
image830×353 15.1 KB

4.
image
image754×383 13.7 KB

9

thanks but still getting error as

image

10

Check whether the file contains macro or not if available then remove and save file as macro free
Check is your entry method name is ryt or not

if possible pls share workflow