Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

7
Replies
641
Views
 Deepak Dhanawade (DeepakD19) Clover Infotech
Clover Infotech
IN
DeepakD19 Member since 2021 11 posts
Clover Infotech
Posted: May 7, 2018
Last activity: Nov 6, 2018
Posted: 7 May 2018 3:19 EDT
Last activity: 6 Nov 2018 20:02 EST
Closed

PEGA RPA Excel Automation

Report

Hi,

I have created one flow in which on button click we can see all the fields in excel sheet. but my requirement is i have to

get values from excel sheet and set that values in windows form that i have created in openspan studio.

Thanks,

Deepak Dhanawade

Robotic Process Automation
Posted: 5 years ago
Posted: 7 May 2018 14:35 EDT
Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect
Pegasystems Inc.
US
Report

Perhaps, I do not really understand your question. If you can get the values out of the Excel sheet, then what exactly is your issue hooking them up to your Windows Form? You would simply pass the result of GetCellValue to the text box or wherever you are displaying it. If this is not sufficient, please provide a little more detail about what you are looking for.
Posted: 5 years ago
Posted: 8 May 2018 0:33 EDT
Deepak Dhanawade (DeepakD19) Clover Infotech
Clover Infotech
IN
Report

Hi,

My requirement is that i have designed one flow that excepts data from excel now i want to display that data in to windows form using automation on click event.

I have attached the document 

thanks,

Deepak
Posted: 5 years ago
Posted: 8 May 2018 9:30 EDT
Pravallika M (PravallikaM465) Accenture Solutions Pvt Ltd Software Engineering Analyst
Accenture Solutions Pvt Ltd
IN
Report

Deepak, what is your requirement exactly,

You  want to view the Data from excel file in windows form ? or you   want to add new records to excel sheet through Windows forms so that it should insert as new entry/row into excel file.? or you want to map & see the whole data one by one record  & edit from Windows form so that it should update in the excel file when you click on submit.?-If this is the case you can use GetTable & directly map it with Gridview  & you can edit from Windows form or otherwise you can also write OleDb query to fetch & append or change data.

 

Regards,

Pravallika.
Posted: 5 years ago
Posted: 8 May 2018 9:34 EDT
Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect
Pegasystems Inc.
US
Report

You are using the ExportData method which returns a DataTable. If you want to get specific cell values just use the GetCellValue method. It takes in the cell letter and number (A1 for example) and returns the value of that cell. Since your Windows Form has three text boxes on it, I would assume you only need three cells from your spreadsheet.
Posted: 5 years ago
Posted: 16 May 2018 7:17 EDT
Deepak Dhanawade (DeepakD19) Clover Infotech
Clover Infotech
IN
Report

Hi Sasnt,

Can you please share the steps how to get specific values using getcellvalue method.

Thanks,

Deepak
Posted: 5 years ago
Posted: 16 May 2018 14:46 EDT
Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect
Pegasystems Inc.
US
Report

You simply pass the GetCellValue method the cell coordinates that you want (A1 for example is the first cell in column A).
Posted: 5 years ago
Posted: 17 May 2018 0:32 EDT
Deepak Dhanawade (DeepakD19) Clover Infotech
Clover Infotech
IN
Report

Hi Sasnt,

How to integrate PEGA Designer studio with openspan studio to create new cases using automation.

Is there any course or if you have any document regarding this please share with me.

Thanks,

Deepak

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice