Excel Read Range all columns from second to last row

Help Studio
, , , ,
1

Hey everyone!
I have a workflow in which I have an Excel sheet which I would like to copy (see screenshot).
I would like to take the second row from column A to L and copy the data from all rows so just drag it down because the amount of rows can differ (so from row 2 until open end). I hope you can help me out :blush:

Kind regards

image
image1536×94 7.78 KB

2

@felixrand
when you are using read range activity , keep range field empty and addHeader checked in the properties. hope it’s help.
image

1 Like
3

Thank you very much!
I declared it to a variable and used another Excel Application Scope with write range to copy paste the data. Unfortunately “Copy Sheet” didn’t work for some reason.
How can I paste the copied data to the row after the last row of the other Excel file?
Like I have a new Excel file which has 300 rows and I want to paste my copied data starting from row 301 of the new Excel file. Is there a solution for that?

4

@felixrand - Use Append Range to write from 301th row.

1 Like
5

Hi @prasath17
Can you show me with a screenshot how it would like? Append Range only has the datatable and the sheetname which doesn’t help me very much :sweat_smile:

6

Hi @felixrand ,

First use the read range then assign the output to a datatable. Eg: mainExcelDt
image

Then, use append range activity from workbook or use another excel scope and provide the second excel file name path. There you have to use the data table variable . Then it will append the 1st excel sheet data to the 2nd excel without affecting any data of 2nd excel. Hope this explanation helps u.

Thanks!
image

7

Hey @sharmi_86
thanks for answering.
Look at my screenshot and see what it looks like and the error on the bottom.
I read the range of “EXPORT.XLSX” and assign it as “export_datei” which I use in Append Range. “Export” includes the data which I want to put into the other Excel file which is in the Append Range activity. I read the range “Sheet1” from the first Excel and I use the Sheet “EP_FY2021” which is from the second Excel file. That is how I understand the use of the activities.
As you can see there is an error in the parameter name.
I can show you some other screenshots in the next reply which can help us solving the issue and so that we have a better overview :smiley:

8

@sharmi_86
This is how the “EXCEL.xlsx” looks like and the data go until row 477."
However on the second screenshot is the other Excel file “04_Legierungszuschlag Auswertung Januar FY2021.xlsx” where the columns a little different which might be the problem here.
The columns of the first screenshot start column B on the second screenshot/Excel file and goes even further until column Q. You can see the code on the third screenshot (seems I forgot it before)
I need to make more replies so that I can the needed screenshots.

image
image1523×72 5.11 KB

9

@sharmi_86

image
image1849×59 8.72 KB

10

@sharmi_86
I hope you can help me out! :slight_smile:

image
image1920×858 77.5 KB

11

Hi @felixrand ,

Sorry for responding late . Can you try the activities in two separate excel scope?
image
Like this , and see if still it shows any error.
I tried with same excel file but 2 different sheets. Sheet2 has 3 columns and sheet3 has 4 columns.

image
image518×883 17.3 KB

You can use filter data table to remove the Column A and append the rest columns.
image