This is my INPUT Excel file
I am Trying to get an OUTPUT like this
while debugging i am getting an error like “Input string not in correct format”, can any one help me how to get out of this error
here i am uploading the files
PROJECT_1.xaml (10.5 KB)
SSBI.xlsx (18.9 KB)
There are 2 reasons as the following.
First, some cells are whitespace. It fails in Convert.ToInt32
Second, there are non-integer value like 331.01.
So, can you try the following condition in If activity?
not String.IsNullOrWhiteSpace(row(4).ToString()) AndAlso Convert.ToDouble(Row(4).ToString())>=1000.00
check this updated workflow
PROJECT_1.xaml (11.9 KB)
Thank you sir its really working but one problem is that instead of getting an amount like 2650.26 i am getting 2650. How can i fix this
Thank you sir for taking time and giving the solution its working but i need a value like 2650.26 instead of 2650 how to do that
Try to enable PreserveFormat option from properties
Hope this may help you
Thanks but when i tick the preserve format the column one is changing but column two not even changing it remains the same , here it is
Can you try to change ArrayRow property as the following?
PROJECT_1.xaml (10.6 KB)
sorry sir but i don’t need round off values i need decimal values like 2650.26
Sorry, I had misunderstanding.
It’s because DEBIT AMOUNT column is set as Int32 type in Build DataTable activity.
So, can you try to modify Int32 to Double in it?
Good catch , Thanks a lot sir its working
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.