UiPath Go ! BalaReva EasyExcel Activities

Help Marketplace
, ,
65

Hi @mail4me_chinna,

The excel application scope should be from BalaReva LIke below.

image
image1876×696 50.6 KB

Regards
Balamurugan.S

66

Thank you @balupad14
It’s working fine

2 Likes
67

Hi All,
Here I have presented 2 activities

  1. Get Column Index - Get Column index by column name
  2. Get Column Name - Get Column name by column index

Get Column Number (Index)

image
image1880×619 64.2 KB

Get Column Name

image
image1882×616 59.1 KB

Sample :
ColumnIndexName.zip (22.5 KB)

Thank you
Balamurugan.S

68

Thank you for a great package. I found that Find & replace replaces the whole cell value. Do you have plans on implementing just the text replacement within the cell?

2 Likes
69

Hi @rchernysh,

Pass the cell range value as like “A1:A1” . So will do the find and replace with in cell.

Thank you
Balamurugan. S

70

Hi all,

Here is the video demonstration for Multiple columns Sorting…

Sample :
16.ExcelSortingMultiple.zip (48.4 KB)

Thank you
Balamurugan.S

71

Thank you for the quick reply. Unfortunately, I got the same result - the whole cell value replace, not the the part of string replace. Im using the "standalone" find and replace that doesnt require an additional Excel Scope.

72

I “figured it out”. Its bizzare, but if the value youre replacing has asterisks in the end (rplVal), then the whole cell is replaced. It`s an Excel “issue” (Office 2016)

2 Likes
73

Hi all,
Here i have demonstrated a video in excel about

  • how to change the font name, the font size in UiPath
  • how to change the font style ( italic, bold, bold italic),
  • how to change the font script ( superscript, subscript, remove script )
  • how to set strike through
  • how to change the font color
  • how to set the underline ( double, double accounting, none, single, single accounting )

Sample : CellFormat.zip (32.7 KB)

Thank you
Balamurugan.S

74

Hi @balupad14,

Do you have a simple copy from an excel file and paste to another excel file in your activity?

75

Yes. It is possible. Just download the latest version 22.0.0 from here(beginning of the thread). Because I have uploaded the package in the UiPath Market place. Waiting for publish.

image
image782×787 34.1 KB

Regards
Balamurugan.s

76

Hi @balupad14
Im Using delete row activity , but some how it is throwing an error. im attaching the snippets kindly look into this problem and suggest me.

image
image1385×497 19.2 KB

image
image881×466 24.9 KB

77

@balupad14 My criteria:
i want delete entire row when this excel order number is equal to another data table order

image
image1642×324 13.3 KB

78

Hi @mail4me_chinna,

Please check this link that to use the row range…

Row range should be {“2:10” } this will delete the 2 to 10 rows. for individual {“2”,“3”} like this format…

79

Good afternoon, have you ever encountered this error?
Clipboard To Datatable: Input array is longer than the number of columns in this table.

I`m trying to paste into the ‘null’ datatable.

2 Likes
80

can you please share workflow with sample file. It will be helpful to me find out the problem exactly .

Thank you
Balamurugan.s

81

It appears to be the data issue. cells had parenthesis, dashes and front slashes(see below). After I left the text only it worked fine.
Case1 (test) Emergency
Case2 - Order (A/B/C)
Case3 - Customer
Case4 Stock (S)

It will be great, if this can be resolved, since I still need to use those characters in my data. the reason for the data table is a need to filter/subtotal the data and produce the report.

2 Likes
82

Let me check with data and ping you…

Thank you
Balamurugan.s

2 Likes
83

Thank you @balupad14!
On a side note. The “clipboard to datatable” will produce string-type columns, which will make the “Native group aggregation” unusable. Is there a better way to workaround it, other than looping through each column with the group by aggregation and building another data table?
Roman

84

Hi ,
Here is the video demonstration for find , find and replace.

Sample Project :
23FindReplace.zip (94.8 KB)

Video :

Thank you
Balamurugan.S