Writing multiple column in excel UiPath

0 votes
I am learning UIPath and my source is excel file. I have excel file with column A,B, C. What I want is to write column A and C only into new excel file.

I get confused which function I should use to read/write. what I want is only column A and C

can anyone help ?
May 10, 2018 in RPA by Vardy
• 2,360 points
3,463 views
better make sql connection and write query as "select A & C from Datatable:

Thanks
I think making an SQL connection and writing query won't be necessary for a simple Excel operation. As Wrecker suggested, desired functionality can be achieved simply by Excel package activities like ReadRange and Remove Data Column.

1 answer to this question.

0 votes

You can read the entire Excel sheet with ReadRange. It output a Datatable. For DataTables there is an activity called Remove Data Column (Programming->DataTable). Use this to remove Col B.

answered May 10, 2018 by wrecker
• 3,110 points

Related Questions In RPA

0 votes
1 answer

Changing a specific column of an excel sheet in UiPath

You can use a For each row ...READ MORE

answered Jun 22, 2018 in RPA by ffdfd
• 5,550 points
1,115 views
0 votes
1 answer

Creating multiple sheets in excel workbook using UiPath

Hi @Ashmita, you can create multiple excel ...READ MORE

answered Mar 5, 2019 in RPA by Abha
• 28,140 points
7,783 views
0 votes
0 answers

How to merge multiple excel column value in one excel? The column name are same but are in different order.

How to merge multiple excel column value ...READ MORE

Sep 28, 2020 in RPA by Tej
• 150 points
1,779 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 26, 2019 in RPA by Anvi
• 14,150 points
5,363 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
1,588 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
2,684 views
0 votes
1 answer

Surface automation in rpa?

Surface automation is a visual automation that is done using ...READ MORE

answered Apr 20, 2018 in RPA by wrecker
• 3,110 points
1,787 views
+1 vote
2 answers

Azure Cognitive services with RPA

Automation anywhere has support for making SOAP ...READ MORE

answered Aug 7, 2018 in RPA by Priyaj
• 58,100 points
1,403 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
5,852 views
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
14,734 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP