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,250 points
1,683 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,530 points
213 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 in RPA by Abha
• 22,740 points
700 views
0 votes
4 answers

Pivot table in excel using UIpath

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

answered Feb 25 in RPA by Anvi
• 12,840 points
864 views
0 votes
1 answer

Add filter to excel table in UiPath

If you use *my value as the ...READ MORE

answered May 16, 2018 in RPA by wrecker
• 3,110 points
1,412 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
312 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,006 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
444 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
• 56,520 points
482 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 in RPA by Venkat
• 320 points
2,587 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 in RPA by Shivi Singhal
2,951 views