Text To number

Hi I am getting a number from one excel in a text format i am pasting no in another excel , its coming in string format how can i get this in a number format
Do anyone know how to convert whole row ?in a number format how to give Whole row in a range Like row 4 , row 5

Hi @Kuldeep_Pandey

Excel Application Scope (Input: ExcelFilePath)
  Read Range (Output: dtData, Range: "SheetName")
  
  For Each Row (Input: dtData)
    Assign (Left: row("ColumnName"), Right: Double.Parse(row("ColumnName").ToString()))
    Assign (Repeat for other columns)
  
  Write Range (Input: dtData, Range: "SameRangeAsRead", SheetName: "SheetName")

Can you share xml? For this

Hi @Kuldeep_Pandey

If you are using read range workbook activity to read the excel file. Check the Preserve format option in that activity then it will get the results in the same format.

Check the below image for better understanding.
image

Hope it helps!!

Hello @Kuldeep_Pandey ,
You can use the For Each Row in DataTable Activity to Iterate Through Each Row of the Excel file and then assign each Column value of the Row to Number or Integer using Cint:
Cint(Row(“ColumnName”)).
Regards;)

Still coming in Number format

You want the Output Values in Number Format RIght?