How can I write from an excel sheet to another application using assign activity…
For Eg.I am copying some text…so I will write
Here text is a variable
Text=row.item(“Text”). ToString
I have another column of percentage named Appointment having so many percentages eg. 25.0000%…How can I write the assign activity for following Appointment column
1.Use read range activity and read the excel and store it in a variable
2.Use the for each row in data table activity and in that use the assign acitivities.
CurrentRow("Your Column Name").tostring
Regards
Use the “Read Range” activity
“For Each Row” activity to iterate over each row in the DataTable.
Inside the loop
Assign-> appointmentValue=CurrentRow(“Your Column Name”).tostring
Use the variable appointmentValue in the application
Hope it helps!!
But the assign activity is reading 25.000% like …0.25%…I want to read exact percentage to write in a form.
But the assign activity is reading 25.000% like …0.25%…I want to read exact percentage to write in a form
@Dovari_Keerti
The .tostring() Method will convert the Percentage to string var and it will read as you are expected.
In Read Range Activity Check Preserve Format and try
Will it make problem if we are reading 25.000% as 0.25
Became I am reading data from excel where there are 2 columns as Code and Appointment
Code is reading fine…but when I am reading Appointment it is feeding the data as 0.25%…
I already used the code u all stated above …but I want to read exact 25 and write 25…
Okay let me try… Thank you so much…I think it will work now
let me know after you try
It Worked Thank you!!
If you got your solution please mark as solution to close the loop.
You can use preserve format in read range workbook
Or if youa re using excel read range then use display values option
If you use preserve format or display value it might read the percentage symbol as well
Apart from that normally whenever we read percentage from excel it reads in decimals only…in the backend percentage is stored as decimal so to get proper value you can multiply it will 100 which gives the percentage value…
Cint(row("PercentageColumn").ToString) * 100 will give you the required value
These are the different options choose anything that you like
Cheers
