Hello,
As we've seen generally Read Excel actions provide all data columns as Text data type.
But I've some columns which are in Date format, DateTime format, Number format, etc, and in the collection, I want that column datatype as Date, DateTime, Number, Text, etc as per data present in that excel column.
Whatever I tried so far gives all columns as text format so Is there any action that assign data type accordingly?
------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------