How to Create .xlsx File

Can any one help me to create .xlsx file. I tried following.
Activity name= Create File.
In property i set
Path = “C:\ABC"
Name= “abcl”+”.xlsx"
But when i tried to open abcl.xlsx file the getting following error.
image

2 Likes

@vivekupadhyay, you can try using Write Range Activity to create even a empty .Xlsx file. Might not be a good solution though !

Regards,
Dominic :slight_smile:

1 Like

Hi,
Right on .not working. :no_mouth:
However try with .xls or .csv its working.
@Andrei_Pop

Hi,
I got this to work by using an Excel Application Scope, which creates the file if it doesn’t exist.

3 Likes

Could u Explain method how to create .xls file

@599712 Its not a correct way beacuse Write Ranege will work if .xls files alreadey exist

Nope. @vivekupadhyay
@599712 his right.
Write range will create new excel file if not available.

1 Like

Hi vivekupadhyay,

Were you able to solve this issue?