Change Columns Types

[Ahmed_Gamal1 (Ahmed Gamal)]

Hello,

I have to read CSV files from Email and convert them to xlsx, Now I need to change all columns type from anything to String,
Keep in mind that I don’t know how many Columns I do Have and all columns need to be changed at once.

The reason for this is in CSV I have a date type columns and it get reversed during write data table range. activity.

Regards,

Ahmed

[Anil_G (Anil Gorthi)]

@Ahmed_Gamal1

Please check this…looks like exact same requirement

Convert the data type of column of datatable

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 datatable is very large, it might be better to write the above in InvokeCode. Regards,

Cheers

[Ahmed_Gamal1 (Ahmed Gamal)]

This can be a solution for static excel sheets but in my case, everything is changing. to hard to predict where will be the datatype.

[Anil_G (Anil Gorthi)]

@Ahmed_Gamal1

No where in the solution we are using any column names or column count and all

I dont think you saw that properly…can you please re check

It can be any type and we need end type to be string so nothing to predict…

Cheers