UiPath Marketplace - BalaReva Easy Data Table Activities

Help Marketplace
4

Hi @balupad14,

Nice Job :100: :ok_hand:

1 Like
5

Thank you @Reddy_Paluri :sunflower::sunflower::sunflower:

1 Like
6

Hi @balupad14
I’m reading Excel and output is data table one of the column is date like: 2020-09-21, but when I write the data table become to 09/21/2020 00:00:00 how can I keep the format?
Is it possible by this activity ?

7

Hi,

Can you send me a sample excel file ?

Thank you
Balamurugan.S

8

@balupad14, I’ve attached a sample.

Thank you Book1.xlsx (9.1 KB)

1 Like
9

Dear all,

I have developed a new activity called “DateTime ParseTo Datatable”.

  • Convert the object/string data type to dateTime datatype in Data. And also has the solution
  • Solution to manage the excel DateTime in DataTable.

image
image1891×841 58 KB

Sample :DateConversion.zip (35.5 KB)

Thank you
Balamurugan.S

3 Likes
10

Hello
This is exactly what I need, unfortunately I can’t get it to run. I have a scraped table from the web in my data table. In column with index 6 is a string with a date. When I add {6} in the column index it keeps telling me "cannot implicitly convert type ‘int’ to ‘int’
Can you tell me what I’m doing wrong. Also tried (6), same problem

Thanks

11

any help?

12

@relsig - Have you just tried 6…because the error shows can’t convert Int to Int Array…so it is expecting you to enter an Integet value…

Update: I just installed that package and tried entering {6} and it didn’t show any error…

image
image522×561 13.9 KB

That field is actually Int Arr…so what you have entered is correct , i.e {6}

13

hi
Thanks for your answer.

sequence
sequence715×604 21.2 KB

properties
properties1065×662 59.5 KB

error message
error message1015×655 98.2 KB

It is probably a stupid error, but I can’t find out what the problem is.

1 Like
14

@relsig - could you please share your xaml? Let me take a look

1 Like
15

Sure, thank youMain.zip (5.1 KB)

16

Hi,
Can you please attach with “Project.json” ?

Thank you
Balamurugan.S

17

here you go project.zip (821 Bytes)

18

Any news?

19

Hi @balupad14
Thanks for the new activities and its really useful.
i am using “DateTime ParseTo Datatable” and trying to convert few column values to date and passing column names {“date1”,“date2”}.
date1 is of type object and date2 is of type string, it is successfully converting date1 to dateTime and not date2. The error i’m getting during execution is “String cannot to converted to dateTime”

Could you please help

image

Regards
Roopa

20

hi @Roopa_Nagaraj ,

Can you share a sample excel file please ?

Thank you
Balamurugan.S

21

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”

22

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 StringChange Column Data Type Activity

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!

23

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 :

image
image1142×552 33.6 KB

After :

image
image1137×373 30.1 KB

Sample :
shaun.mcdowall.zip (50.3 KB)

Thank you
Balamurugan.S