String to double conversion

Help
1

Hi i am not able to convert my excel column from text to double .Please help

Screenshot%20(1)
Screenshot%20(1)1366Ă—768 66.4 KB

2

Hi,

Can you use Convert.ToDouble(row(Columnname or index).tostring)

You cannot directly pass the entire row, you have to pass the column index or column name

3

Hi,

Try like the following,

Double.Parse(“Your_Text_or_Values_Pass_here”)

Check this link for more information,

1 Like
4

There is an error :
Assign: Input string was not in a correct format.

1 Like
5

Hi @preksha_srivastava,

Can you print the value first what row(“Column name”) has

Can you share your expression, and let us know the value in row(“ColumnName”)

6

Screenshot%20(2)
Screenshot%20(2)1366Ă—768 69 KB

7

You are getting the error because you are storing double value in system.data.datacolumn variable,

Please be clear what are you trying to achieve, help us with the values in assign statements

8

Screenshot%20(3)
Screenshot%20(3)1366Ă—768 61.5 KB
I just need to convert this into double to filter values

9

Then just give convert.todouble(Value in excel)

10

Can you please give full solution for this:
The column name is"Actual Hours"
I have read range and then i am using assign activity,but what to use in assign activity.

11

Hi @preksha_srivastava,

After read range, i think you want each value from the excel, to use it somewhere

  1. Read Range,Use For each row
  2. Print the value row(“Actual Hours”).tostring
  3. Convert to double. - Convert.todouble(row(“Actual Hours”).tostring)
12

Screenshot%20(4)
Screenshot%20(4)1366Ă—768 78.1 KB

13

I want to filter the values of the excel sheet that are less than or equal to 40,but unable to do so because the data is in text format.After filtering write it into new sheet.This is the problem.Please help by whole process by the flowchart.

14

Please provide the excel sheet.

15

UI.xlsx (16.8 KB)

16

Refer the below workflow.

Main (20) (1).xaml (8.0 KB)

17

what is write line doing

18

Nothing, i am just printing the value to see, how i am getting the value from excel

Did id work or not?

19

When i am using it,the error is cannot find column name

20

Dear @preksha_srivastava,

The column name in excel and the column name in select statement should match, you are getting the error because its not matching.

Print the column name in excel first and if there are any spaces, paste as it in the select statement.

I have used the same excel file you provided and was able to successfully get the output