Converting scraped text to numbers

[Tapiwa (TapiwaMakamure)]

Hie guys. My scraped data is showing numbers as text in excel. How can i change format for my scraped data to be written as numbers

[Palaniyappan (Palaniyappan P)]

Hi
Kindly Covert that whole column to int32 like
Yourdatatable.columns(“yourcolumnname”) = GetType(System.int32)

And now insert that datatable to the excel
Cheers @Tapiwa

[raymondhui (Raymond)]

Many ways to do it:

1. you can change the format in excel
2. usually there is ’ in front of the number, therefore you can replace it with space " "
3. after read range, use assign activity with cint to convert each cell inside the datatable

[Tapiwa (TapiwaMakamure)]

cannot assign from type ‘system. type’ to type ‘system.data.datacolumn’. thats the error im hevin when converting.
DT.columns(“test”) = GetType(System.int32)

[Palaniyappan (Palaniyappan P)]

Asha sorry typo mistake it should be like
Yourdatatable.columns(“yourcolumnname”).Datatype = GetType(System.int32)
Cheers @Tapiwa

[Palaniyappan (Palaniyappan P)]

were we able to enter as integer now @Tapiwa

[Tapiwa (TapiwaMakamure)]

@Palaniyappan

GetType(System.int32)

[Palaniyappan (Palaniyappan P)]

Kindly share your xaml if possible
Cheers @Tapiwa