Create new excel

How to create a new excel just give the name only.

Myexcel.xlsx

Note: I don’t create using Write Range

2 Likes

Hi,

Here you have an activity is called create Workbook. It will create the excel file in the specified path.

Regards
Balamurugan.S

2 Likes

Hi @balkishan

You can create write range as well

Thanks
AshwinS

hi
well we can create with EXCEL APPLICATION SCOPE itself
with the excel file name as input
and if the file exists it will get to that file or it will create a new excel file

simply like this, now this will create a excel file named Final.xlsx in the project folder
image

Cheers @balkishan

1 Like

Yes that’s what I want

Hi getting while creating the new workbook.

see in sheetName I pass the DynamicValue variable which is contain the value 311
and give the path in the File Path but go this error

I want to create the excel only.
image

see in it’s asking me about the dataTable

Bala
I am trying to copy the complete worksheet into another worksheet.

But it’s giving error

Hi @balkishan
Instead of this
use excel application scope and use select range and use send hot key activity
as ctrl+c and and paste it into another excel sheet by using ctrl+v

Thanks
Ashwin S

1 Like

@Palaniyappan I used this but it’s creating the default sheet is Sheet1 How to rename or delete it???

so you mean like you want to rename the sheet
for that this would help you
Rename Worksheet.xaml (8.3 KB)

Cheers @balkishan

is there any activity which I can delete the Sheet name???

1 Like

Sorry buddy
We don’t have a specific activity to delete a sheetname

But still we can delete the sheet either with Invoke method or send hotkeys

Cheers @balkishan

Hi @balkishan
I don’t know. How you are using the activity. I will send you a video about this. You can get clear idea. And same package is having the delete sheet and rename sheet activities.

Thank you
Balamurugan.S

1 Like

Hi @balkishan,

Please check these videos.

Regards
Balamurugan.S

1 Like

Thanks Bala,

You have saved my lot of time, I would really appreciate your efforts.

These are very useful activity.

One issue I faced - To use these activity we have to provide the full path of the file like from C: then only these will be working. Otherwise showing it seems to file removed type of exception.

1 Like

Yes @balkishan,
This version you have to give the full path. But in the next version . You won’t. I am some changes in the package and also I am including some new activities inside. In the next it will have more features.

Thank you
Balamurugan.S

1 Like

Thanks Bala, Good job!! :slight_smile:

1 Like

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