Excel Activities for Processing and Filtering v1.3

Help Marketplace
,
1

Hi everyone, i’d like to share the NEW version to my custom activity. Feel free to use it and ask any questions

for v1.0,1.1 thread :

v1.2

v1.3 functions
1. Find column letter of text in row - Returns column letter where the specified string exists in the specified rows.

Input

  1. in_excelPath – excel path
  2. in_rowNumberToSearch – the row number you want to search in
  3. in_SheetName - sheet
  4. in_textToSearch – the text you want to search for

Output

  1. found column Letter

image
image851×560 66.9 KB

2. Drag formulas in one or more columns - Drag formulas in one or more columns.

Inputs

  1. in_excelPath- excel path

  2. in_sheetName – sheet

  3. in_columnLettersList_String – columns where you want to drag formula e.g. “K,L” means you
    want to drag formulas in column K and L

  4. first formula row – row containing the first formula (robot will use this row and drag to the rows
    below)

  5. clearFirst – if TRUE, will clear the old formulas before dragging again

  6. index column Letter – the column that will determine how long to drag the formulas
    a. Example: If index column letter = “F”, then formulas will be dragged to row 15 because
    the last row of column F = 15
    image

    b. if blank, then formula will be dragged to the last row of the whole sheet

image
image848×800 78.3 KB

1 Like
2

Good one @jack.chan. Thanks for the contribution and share.

1 Like