Question
EAI Systems India Pvt. Ltd.
IN
Last activity: 6 Nov 2018 20:02 EST
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
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.
EAI Systems India Pvt. Ltd.
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
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.
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.
EAI Systems India Pvt. Ltd.
IN
Hi Sasnt,
Can you please share the steps how to get specific values using getcellvalue method.
Thanks,
Deepak
Pegasystems Inc.
US
You simply pass the GetCellValue method the cell coordinates that you want (A1 for example is the first cell in column A).
EAI Systems India Pvt. Ltd.
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