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
Kindly Covert that whole column to int32 like
Yourdatatable.columns(“yourcolumnname”) = GetType(System.int32)
And now insert that datatable to the excel
Many ways to do it:
- you can change the format in excel
- usually there is ’ in front of the number, therefore you can replace it with space " "
- after read range, use assign activity with cint to convert each cell inside the datatable
cannot assign from type ‘system. type’ to type ‘system.data.datacolumn’. thats the error im hevin when converting.
DT.columns(“test”) = GetType(System.int32)
Asha sorry typo mistake it should be like
Yourdatatable.columns(“yourcolumnname”).Datatype = GetType(System.int32)
were we able to enter as integer now @Tapiwa
Kindly share your xaml if possible