Facing issue while trying to perform "Save As" action on an excel sheet using Uipath.

0 votes

Hello, I am trying to Save an Excel File to a different format using UI Path. The workflow works fine, it opens the Save As window, inputs the filename, it selects the file format in the dropdown list and then it clicks the save button. However the file format does not change. This is the bit of the flow in question:

image

At the end of that bit of the workflow, it save the file with the new name, but it’s not in CSV.

Please help

Nov 5, 2019 in RPA by anonymous
• 1,110 points
536 views

1 answer to this question.

0 votes

Hello there, a work around that I found in Excel is building a workflow like this:

  • Excel Application Scope;

  • Click “File” ;

  • Click “Export” ;

  • Click “Change File Type” ;

  • Double Click on the desired file format ;

  • A “Save As” Window will appear, with you chosen format already selected. In this widow you can write the desired File Name / Path and it will save it correctly.

Hope this works.

answered Nov 5, 2019 by Abha
• 27,920 points

Related Questions In RPA

0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
5,205 views
+3 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8, 2019 in RPA by Anvi
• 14,050 points
10,473 views
0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12, 2019 in RPA by anonymous
• 120 points
423 views
0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16, 2019 in RPA by Venkat
• 320 points
3,305 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
649 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
547 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,319 views
0 votes
3 answers

Any open source tools for RPA ?

Yes, here is the Free RPA tool ...READ MORE

answered Oct 24, 2018 in RPA by Karthiksiddhu
• 240 points
427 views
0 votes
1 answer

How to install UiPath Orchestrator on an Azure App Service platform?

Hey @Jason, to install UiPath Orchestrator on ...READ MORE

answered Apr 2, 2019 in RPA by Abha
• 27,920 points
1,013 views
+2 votes
1 answer

How to extract data from website and save it to excel using Blue Prism?

Hey, you can use following steps to ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 27,920 points
1,655 views