Create new excel

Help
1

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

Myexcel.xlsx

Note: I don’t create using Write Range

2 Likes
2

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
3

Hi @balkishan

You can create write range as well

Thanks
AshwinS

4

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

3 Likes
5

Yes that’s what I want

6

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
image

7

I want to create the excel only.
image

see in it’s asking me about the dataTable

8

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

But it’s giving error

image

9

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
10

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

11

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

Cheers @balkishan

12

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

1 Like
13

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

14

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
15

Hi @balkishan,

Please check these videos.

Regards
Balamurugan.S

1 Like
16

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.

2 Likes
17

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
18

Thanks Bala, Good job!! :slight_smile:

1 Like
19

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