Text Error on Excel after write operation

image
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

@NIVED_NAMBIAR can you please look into it?

If you have a bit time in your hand.

Hi @Tanzill_Ahsan
can u share the excel file please?

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

Hi @Tanzill_Ahsan
can u tell what you need actually ?

image
The output is coming like this. I want to avoid this and want the output as simple double like this

image
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

Hi @Tanzill_Ahsan
check this way
Main.xaml (10.5 KB)

Regards,

Nived N
Happy Automation

1 Like

Yes it is working

Thank you so much for your help.

1 Like

@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 :robot:

Happy Automation :relaxed::relaxed::relaxed:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.