Question
Flextronics International USA Inc
IN
Last activity: 14 Nov 2018 7:00 EST
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
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
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.
US
Just connect the data fields from the excel cells to the text fields on the page and it should work fine.
Flextronics International USA Inc
IN
do i need to add interaction manager to map it to different fields in my web page
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.
prodapt solutions
India
Hi
How to write the multiple cells in excel ?
Example:
i want to write the cell A2,B2,C2
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,
-
Ravi Kumar Pisupati KrishnaChaitanya Gaddipati Vaibhav Jagatkar Krzysztof Lenarcik Dennis Van Mierlo and 1 More
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!