Read all columns from Excel as string

Help Forms
1

Hi,

I need the column types of the data table to be string for all the columns present in an excel file.

Can we do this using read range activity?

2

@HiteshJeswani101 Not sure what you want but you can convert the data.row to string by using .toString method or this post might help you https://forum.uipath.com/t/how-to-convert-datarow-to-string/

3

@Akshay07 I want the column type to be string by default. Right now read range is picking up column type according to the excel file which can be anything.

4

@HiteshJeswani101 Thanks for your quick response. you can use output data table activity which is datatable activity of uipath. This activity outputs the datatable to string. Hopefully it solves your problem. :grinning:

5

Hi hitesh

You can actually try this component .

6

@vishnuvarthanp Thanks for the answer. It works!

1 Like
7

Thanks :slight_smile: