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

 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

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

To see attachments, please log in.
Robotic Process Automation

Posted: 7 years ago
Posted: 7 May 2018 14:35 EDT
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
Pegasystems Inc.
US

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.

To see attachments, please log in.
Posted: 7 years ago
Posted: 8 May 2018 0:33 EDT
Deepak Dhanawade (DeepakD19)
Clover Infotech

Clover Infotech
IN

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

To see attachments, please log in.
Posted: 7 years ago
Posted: 8 May 2018 9:30 EDT
Pravallika M (PravallikaM465)
Accenture Solutions Pvt Ltd
Software Engineering Analyst
Accenture Solutions Pvt Ltd
IN

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.

To see attachments, please log in.
Posted: 7 years ago
Posted: 8 May 2018 9:34 EDT
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
Pegasystems Inc.
US

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.

To see attachments, please log in.
Posted: 7 years ago
Posted: 17 May 2018 0:32 EDT
Deepak Dhanawade (DeepakD19)
Clover Infotech

Clover Infotech
IN

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

To see attachments, please log in.

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