Copy and Paste automation

Help StudioX
,
1

Hello,

Is there a function like below ?

An automation for copy datas and paste in Excel sheet.
It was pasted from A1 to A5 in Excel.

For next time, if execute the automation again and when paste to Excel , it should be pasted starting from A6.

Is there a function like this ?

2

@PARK_Bin
Increment the Index value with 5 in the loop
then 2nd time it will paste in A6 to A10

3

Hello @PARK_Bin

  • Read Range (Sheet: YourSheetName) Output: excelDataTable
  • Assign nextRow = excelDataTable.Rows.Count + 2 // Add 1 to the last row to find the next available row
  • Write Range (Sheet: YourSheetName, Range: “A” + nextRow.ToString + “:A” + (nextRow + 4)ToString) // Paste 5 rows of data starting from the next available row
  • Excel Application Scope (Save and Close)
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.