How to Convert Excel Columns to Text Format using UiPath

#1

Can you help me to convert a Excel Column into Text format using UiPath?

Please note that the number of rows in that particular column is dynamic.

Thanks.

1 Like
#2

@apoorrv09

Welcome to the UIpath Community.

  1. use Read Range Activity to read data from Excel and will give you output as dataTable and say ‘DT’.
  2. Then use For Each Row Activity to iterate that DataTable.
    ForEach row in DT
    row(“ColumnName”).Tostring

The above one print all rows values in that coloumn.

1 Like
#3

Hi,

This will convert the column to String format i.e. it will be ‘General’
in Excel

I want the column to be ‘text’ format in excel.

#4

Hi @apoorrv09

Welcome to UiPath community buddy

Buddy you can write a Macro for that and run with INVOKE VBA activity in uipath
Record a macro and save it in a text file
mention the macro name in properties
and keep the activity invoke vba inside a excel application scope activity (pass the file path as input to excel application scope)

Try this and let know buddy
Cheers @apoorrv09

#5

The macro can be something like the following:

Range cells = xlWorkBook.Worksheets[1].Cells;
        // set each cell's format to Text
        cells.NumberFormat = "@";

Then paste in your data. I can put together a UiPath example for you.

#6

Here is an example which cycles through all sheets and updates a given range to Text Format

You can then simply paste in your data via an excel activity in UiPath or pass the data to the code and input it that way, which would be somewhat cleaner.

FormatCells.xaml (6.5 KB)