How to avoid changing data type in Excel?

Help
, , ,
1

Hello,

I am curious to know how to avoid this scenario? I was thinking to merge excel table and Datatable for our bot and it’s giving me mistype data. we used the build data table and scrap the value of the data row by row. The problem was after scraping all the data to excel. it automatically changed all the data types. For example For the date data. we assigned it to (String) before writing it into excel using the write range. but in excel file it changed the data type to String data type to general. Date with the timestamp on it (which makes it very hard to compare as it’s giving us (timestamp) as well as can’t merge the table anymore. the original idea was to dump everything to excel and compare it again with Datatable.
Thanks You