UiPath Marketplace - BalaReva Easy Data Table Activities

[Roopa_Nagaraj (Roopa)]

Hi, thanks for the reply.
PFA
excel1.xlsx (15.9 KB)

In the above file the column that needs to be converted to date are “BE/SB Date” and “R SB Date”

[shaun.mcdowall (Lionel)]

Hi,
I am trying to change the data type of a single column in an Excel sheet to Text using the BalaReva Change Column DataType action.

I have set the Column Data Type to String

This appears to work when I view the datatable using the Show DataTable activity (type is then System.String) but when I write the data to an Excel Sheet and right-click on a Cell in the column, its type is still General.

How can I use this Activity to change the data type of a column to Text?

Many thanks in advance!

[balupad14 (Balamurugan)]

Hi @shaun.mcdowall ,

Normally when you write the string datatype from the datatable to excel. it is always general. in this case, you have to use “Change Cell Type” to change the general to string. Here I have attached a demonstration for you.

Before :

After :

Sample :
shaun.mcdowall.zip (50.3 KB)

Thank you
Balamurugan.S

[shaun.mcdowall (Lionel)]

Hi Balamurugan,

Just a note to say “thank you” for this example!

Kind regards,

Shaun

[balupad14 (Balamurugan)]

Dear All,

I have published a new version (4.0.0)of BalaReva.EasyDatatable.Activities in our UiPath Market place. Here is the release notes.

Easy DataTable Activities - RPA Component | UiPath Marketplace

New activities (MergeDatatable,SortDatatable) and move the old activities from DataTableGroup(old package)

MergeDatatable

Merge different column names into a single column.

EasyDatatableMergeTable.zip (75.4 KB)

SortDatatable

• Sort multiple columns

EasyDatatableSort.zip (73.3 KB)

Regards
Balamurugan.S

[sudheern (Sudheer Nimmagadda)]

@balupad14, your work on making it easy for developers to interact with datatables is fantastic and extremely useful. Thank you

[balupad14 (Balamurugan)]

Thank you @sudheern