Excel cell data type

Help Robot
,
1

Hi Team
I have used a build data table of column type int and used one temple excel of column type number
i am storing my all the data in build data table column and pasting in another excel column
But I am getting error in some number in adding data becuase they contain 1,233 or 1.333
Please let me know how to resolve this

2

image
image1360×768 61.5 KB

3

Hi @Kuldeep_Pandey

Please change the column type to string.

4

I want output as in number format , if i am doing this i m getting output in string format

5

Hi @Kuldeep_Pandey

when u r using the output please use the CInt so that it converts string to integer.

6

If I am CINT
Then 1.5 will convert to 1

7

Hi @Kuldeep_Pandey

Please use “Convert.todouble”

9

Hi @Kuldeep_Pandey

use Output variable = “Convert.todouble(CurrentRow(6))”
output variable data type must be in double.
regards.

10

Now I am getting Output as in string format

11

Hi @Kuldeep_Pandey

MicrosoftTeams-image (1)
MicrosoftTeams-image (1)996×588 73.7 KB

12

Hi @Kuldeep_Pandey

  1. Store the numbers as strings in the DataTable:
  • When adding the numbers to the DataTable, convert them to strings using the ToString() method.
  • For example: row("ColumnName") = number.ToString()
  1. Paste the DataTable into the Excel column:
  • Use the Write Range activity to write the DataTable to the destination Excel column.

Thanks!!