I have an excel sheet with multiple columns. I am using Read Range Activity and the data table automatically picks a column type as double which is having both number and string values . I want to convert that Column from Double to String. I don’t want to use any custom activity . Please help.

Hi, I suppose type of Datacolumn is object if use ReadRange ativity… Anyway, we cannot change type of DataColumn if data already exists. The following sample is for create new datatable which has same name columns and expected data type. [img20211027-1] Sample20211027-1.zip (8.9 KB) If your d…

Convert the data type of column of datatable

Help Studio

Lakshay_Verma (Lakshay Verma) October 27, 2021, 6:37am 10

1 Like

Topic		Replies	Views
Excel Read Range Activity reading data type as object Studio datatable , excel , studio , question , activities_panel , read-range	6	2765	February 20, 2024
Read all columns from Excel as string Forms form	6	3599	March 12, 2020
Convert column datatype to String Studio studio , question , workflow_diff	4	1267	October 14, 2022
Column Type Change Activities activities , question , system	3	2150	February 2, 2021
Change a column datatype Studio	4	2916	September 28, 2023

Convert the data type of column of datatable

Related topics