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 9, 2018 in RPA by Vardy
• 2,360 points
2,206 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 9, 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 21, 2018 in RPA by Atul
• 5,540 points
344 views
0 votes
1 answer

Creating multiple sheets in excel workbook using UiPath

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

answered Mar 4, 2019 in RPA by Abha
• 27,930 points
2,778 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

17 hours ago in RPA by Tej
• 150 points
25 views
0 votes
4 answers

Pivot table in excel using UIpath

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

answered Feb 25, 2019 in RPA by Anvi
• 14,110 points
2,125 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
634 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,443 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
902 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
• 57,660 points
680 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,512 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
6,469 views