How to set text from excel to web application

Help Studio
1

Hi,

I want to set dates from excel file to web application. How can we do this?

Regards,

2

Hi,
Can you please share the img of web app, where u want to put date from excel.
Basically you have to make custom selector with the help of ui explore.

3

image
image1073×164 4.55 KB

How to update these dates.

Regards,

4

Hi @raju_alakuntla

Read the excel file and store it in a datatable. Use for each row in datatable activity to iterate the readdatatable data, store the required date column in a variable. Open the web application use type into activity to write the variable data in to the web browser.

Hope it helps!!

5

Hi @raju_alakuntla ,

Please follow the below steps will give you some idea to automate the process which you are trying to .

  1. Use excel application scope activity inside use the “Read Range” activity from the Excel package to read the data from the Excel file into a DataTable variable. Specify the range or sheet name from which you want to read the data.
  2. Use For each data row to loop the dates extracted from excel file.
  3. Navigate to the date input field: Use the “Click” activity to click on the date input field in the web application. If the date input field is part of a date picker, you may need to use additional activities to navigate to the correct date picker and select the appropriate input field.
    4.Enter the date value: Use the “Type Into” activity to enter the date value that was retrieved from the Excel file. Make sure to format the date value according to the expected format in the web application.

Regards,
Kirankumar.