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,280 points
better make sql connection and write query as "select A & C from Datatable:

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.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,090 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,510 points
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
• 10,960 points
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
• 8,840 points
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,090 points
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,090 points
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,090 points
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,090 points
+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,140 points
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
0 votes
3 answers

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

1.  Excel Application Scope (Activity) : In ...READ MORE

answered Jun 9 in RPA by anonymous
• 140 points

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.