Leave one line free per copy

Help Studio
1

Hello everyone,

I have a short question that is probably relatively easy if you know how to do it.
I have copied several Excel files into one Excel file, but now I want to have one row empty between the different data.

Is it possible to do this with For Each Excel row Activity?

2

@Matthias_Kuntz

check it

3

we would recommend that clear criteria be defined, where the data is separated (1 line per different Excel, each line). Depending on this definition we can check for realization options

depending on above definitions

  • Yes
  • has also chance to get realized by other options e.g. LINQ
4

Hi @Matthias_Kuntz

Can you try the below

image
image1135×3032 279 KB

Input:

image
image829×193 3.61 KB

Output:

image

BlankProcess18.zip (224.8 KB)

Cheers!!

6

@Matthias_Kuntz

Can you please show that expression or Can you please delete that activity and reassign it

7

Hi @Matthias_Kuntz ,

Hope you doing good

try to find the length of the data before you are going to append
then use length+1 row while appending

Cheers

8

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