When I read range, datatable stores all the values as “string”. How do I change them? suppose i want the first column to be date type and the second column as int, how do I do that?
The problem with string is, when I write range, all integers and dates are written to excel as a normal text and so it doesnt work as intended
Could you provide a sample and specify the version of your Studio + Excel activity pack?
I used to have similar issues it the past, but while testing it on 18.3 and this activity pack: , it worked well.