This is the issue that I am facing. But I don’t want this error and want the output as a simple double.
Note: I had used Cdbl to resolve this but this error message is still appearing.
This is my xaml
This is the issue that I am facing. But I don’t want this error and want the output as a simple double.
Note: I had used Cdbl to resolve this but this error message is still appearing.
SAP OUTGOING.XLSX (15.6 KB)
For some privacy concerns about the data, I have removed some of the unnecessary columns.
I am working with the first two sheet now.
@NIVED_NAMBIAR
The output is coming like this. I want to avoid this and want the output as simple double like this
expected output
Hi @Tanzill_Ahsan
the error occurs as you had written the double value in format of text, to avoid this, use the below simple way
Read the sheet using excel application scope and write range
output i got
Regards,
Nived N
Happy Automation
But I cant use Write Range I want to write the value in a specific cell, so I am using write cell activity.
I want to make it more clear to you. By iteration I am taking the last value of the amount in local currency column and writing it in the next sheet on a specific cell.
Here I am bound to use write cell because of my next steps.
From which Sheet u are taking value?
Sheet1
Yes it is working
Thank you so much for your help.
@NIVED_NAMBIAR
Can you tell me how can I take a column position instead of the column name?
My code is Cdbl(row(“Balance”).ToString.Replace(“Dr”,string.Empty).Replace(“Cr”,string.Empty).Replace(“,”,string.empty))
Here I want to change the Balance and want to use column position
You can use column index instead of column name
For first column , index will be 0
For second column index will be 1 etc like that
So instead of row(“Balance”) u can use row(0) if the Balance is first column
Regards
Nived N
Happy Automation
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.