Append data in excel from the begining

Help
1

Hi,
Please help!!

1.How to append data from the beginning of an excel file which has some existing data.
2.And also how to copy “formula” of a cell and apply to all other cells in the column.

Thanks in advance

2

@keerthishree

  1. Have you tried the ‘Append Range’ activity?
  2. You can use ‘Write Cell’ or ‘Write Range’ to enter formulas.

Depending on your configuration please bear in mind these activities need to be inside an excel application scope.

1 Like
3

InsertRowXLS.zip (7.3 KB)

Use the Insert/Delete Rows activity.

2 Likes
4

copyformula.zip (8.2 KB)

(2). use the Read Cell Formula activity and add the “=” at the Write Cell activity

1 Like
5

could you please help on how to append data from C column.
for Example:
File1: data in file is from"A to E" column(5 columns)
File 2 :i want to add data from “C to E” leaving A and B blank ,

How to achieve this

6

ExcelCopyRange.zip (8.8 KB)

Please take a look.

7

Thanks…but i want to copy columns “A,B,C,D” to “C,D,E F” means data present in “A” must place into “C” column and “B” to “C” and so on, leaving A and B blank,could please help on this.

8

ExcelCopyAE.xaml (10.1 KB)

Updated workflow as requested.

image

9

Thanks a lot

1 Like
10

I have a formula =right(E2,6) and have red the cell formula and have used “write cell” activity
the formula is taking =right(E2,6) for all the rows,how to get formula based on row number
like =right(E3,6),=right(E4,6),=right(E5,6)…etc.

11

image

Use variable for the Row number
:slightly_smiling_face:

12

Flowchart.xaml (17.1 KB)
Consolidated.xlsx (8.6 KB)
downloadedfile.xlsx (7.9 KB)
Please check the files and let me know where am wrong

13

If the same formula will use by other row, build the formula manually might be a solution.

formula = “RIGHT(E” + myCounter + “,5)”

1 Like
14

thanks