Question

2
Replies
2066
Views
 Aswathy Mohan (AswathyM)
Cognizant

Cognizant
IN
AswathyM Member since 2017 16 posts
Cognizant
Posted: September 18, 2017
Last activity: October 6, 2017
Posted: 18 Sep 2017 6:54 EDT
Last activity: 6 Oct 2017 4:37 EDT
Closed
Solved

Excel Connector

Hi,

I would like to know whether there is a way to get the records of a particular column( depending on the column name like customer ID, place etc rather than A1, D3 etc).This is because additional columns would be inserted into the sheet.

Also if I use ExportData, the cellStart and cellEnd has to be specified. Is there a way to read the entire set of records without specifying the cell name?

Thanks in advance.

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 18 Sep 2017 7:35 EDT
Manas Rout (ManasR02)
ANZ

ANZ
IN

Hi,


We can create a .net component using excel.introp to read the excel and keep all the values in a table.


Then we can use query with a column name to retrieve the values.


it give us more flexibility and usability then a excel connector.


And with a .net component it will make your code more reusable.


 

Accepted Solution

Posted: 3 years ago
Posted: 18 Sep 2017 12:18 EDT
Thomas Sasnett (ThomasSasnett)
PEGA
Lead Robotics Architect u2013 Pega Consulting
Pegasystems Inc.
US

Please see the post below. I discuss how you can get the UsedRange of an Excel sheet. It isn't 100% accurate however as Excel will report cells that are empty, although I believe it will always report 100% of the cells (it just may have extras if those cells were ever used). You could then filter the DataTable object in a script to exclude the empty rows.


https://pdn.pega.com/community/product-support/question/export-data-method-ms-excel-component