Type conversion exception problem

Help Activities
,
1

Phase1 Industry Project Weekly Stock Price.zip (111.3 KB)
Hi, When I first run this project it worked perfectly fine. But now it is giving me type conversion problem for average close price and volume. Please help me with this asap.

2

Hello @Priyanka_Jharia

Could you please share the full error which you are getting and in which activity you are facing this issue.

3

image
In this following activity I think because of the expression.

image
image1321×674 21.4 KB

image
image1182×555 21.2 KB

and I use this expression
ReadTstWkb3.AsEnumerable().Average(Function(row) cDbl(row(“Close”).ToString.Trim))

4

@Priyanka_Jharia ,

Try changing the Expression to the Below and Check :

ReadTstWkb3.AsEnumerable().Average(Function(row) if(String.IsNullOrWhiteSpace(row("Close").ToString.Trim),0,cDbl(row("Close").ToString.Trim)))
5

Didn’t Work. Giving the same exception.

6

@Priyanka_Jharia ,

Are you using the above Expression directly in the Write Cell Activity and Checking it ?

If so, Could you just use the Expression in a Message Box before using in the Write Cell Activity to Check if it gives out an Error in it as well ?

Also Share the Screenshot of the Expression used in the Message Box.

7

image
Hey, It didn’t gave error in Message Box as you can see and I used the same expression that you gave me in the message box but I have to write it in excel sheet in which it is creating error still. Please let me know how can I do this.

8

@Priyanka_Jharia ,

Does it give out the Same Error or a Different Error ?

9

same error

10

@Priyanka_Jharia ,

In that case, Could you try Assigning that Expression to a Double Type variable and then use that variable in the Write Cell Activity ?

11

same error I faced…

12

Hey I resolved it by myself thankyou for your input.

13

Did you have the same problem like me that it first worked great then it created error?

14

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