How to define datatypes for columns during read range?

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

1 Like

Hi @farhan94

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: image, it worked well.

1 Like