Unable to save new excel file

Help StudioX
,
1

Hi i am trying to save an excel file which was created by moving a sheet from another workbook . When i move the sheet to a new work book it comes as book1 or book 2 , how can i save this excel workbook as unable to select this newly created work book

2

Hi,

Welcome to uipath forum.

When you are using move file activity give the Absolute path of the excel file path(path with the filename and extension) in the destination so that it would not create any temporary excel like book1 or book 2.

3

Hi Actually i am moving one sheet of the workbook to a new file , so just wanted to know how to give the path. As these i have done using click activity like how we do in normal excel file

4

Hi,

Did you tried the below activity.

5

Hi I dont see copy sheet in studio X but there is something called copy paste range where i am copying to clipboard , after that what should i do to save it as excel file

6

Please perform the below steps to enable to copy sheet activity in studiox.

->Enable developer mode.

image
image487Ă—533 18.4 KB

once you enable you will get copy sheet in the activities list

image

destination parameters like destination excel path and destination sheet name

input → you should give current sheet you want to copy . please try and let me know

7

Hi

Hope the below steps would help you resolve this

  1. Use a activity named COPY FILE activity where pass the filepath of excel file you want to copy in FROM field and and mention the new folder where you want to paste that file in TO field

  2. Now use a USE EXCEL FILE activity and pass the new excel file path as input

  3. Inside that activity use a activity named

FOR EACH EXCEL SHEET and mention as excel in workbook field

  1. Then inside that for each loop use a IF activity with a expression like this

CurrentSheet.Name.ToString.Contains(“sheetname you want to delete”)

Inside the THEN block of that if activity use a DELETE SHEET activity and mention the current sheet as input

Cheers @Mukherjee_Manish

8

Hi Thanks for the steps but what this is doing is it is deleting the sheet which i wanted save as another excel workbook

Attaching a screen shot , I want to save the sheet Taiwan meeting template to save as a new work book with the file name Taiwan meeting template

Sheets
Sheets1007Ă—135 6.26 KB

9

Hi i was able to solve this by

Using USE EXCEL AND then copy paste range I was able to solve it

1 Like
10

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