Excel - Format column to text before writing

Help
24

Try giving the Invoke code activity before the excel application scope and writing the data. Otherwise, it will open twice and it will open in read only mode :slight_smile:

25

Will putting it before excel scope work as the file is only created at the excel scope.

26

This is still asking to select yes or no to replace the file.

This is saving as new file but data is not coming.

Don’t know where I am going wrong :frowning:

27

Just give the empty excel scope only with the path and make sure, the Create new file option is checked and then INvoke code and then another excel application scope and write data

28

You mean not to give any file name?

29

Only the entire path, including the extension till .xlsx

30

is this correct
image

31

Invoke code between the two excel scopes

32

Wow… Thanks bro… I could achieve it. :v::+1:

1 Like
33

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.