Excel Automation
Hi,
I have an excel sheet and a web application, need to create an automation such that the data from excel is pushed to the corresponding fields in the web page.
I have created loops for reading data from excel but not sure how to map it to the particular fields in the webpage.
Thanks
Accepted Solution
Pegasystems Inc.
US
No, just connect the data links to the controls you want to use the same as you would make an automation link.
Pegasystems Inc.
US
The excel connector pulls the information from cells back as strings, so make sure that the text boxes on the page accept strings and you should be fine.
Flextronics International USA Inc
IN
I have 7 fields and the result is contained in an automation block as item, i need to map it to the corresponding text fields
Pegasystems Inc.
IN
Hello!
We see that you created a new post for this question: Write multiple cells in Excel
Good practice! Please continue the discussion on the new post.
Thanks,
Sykes Enterprises Eastern Europe LTD
RO
@AnimaK06 Would you be so kind as to share a sample of the loops you created in order to search the data in excel?
I am also trying to develop a windows form with a drop down menu that contains some text items and I'm trying to match those with the Items I have in the excel file, and then copy the text associated with a specific item back to the windows form.
A file with some sample code would be very much appreciated!