Excel Advanced Package & Loop

Thank you, Zaid Chougle  I have sent you an example of starting my author using Get multipel calls. Can I continue?

mewky wrote:

Thank you, Zaid Chougle  I have sent you an example of starting my author using Get multipel calls. Can I continue?

After Using Excel Open → Get number of rows, Then use loop for Excel Advanced and in that use specific rows and then first iteration as 2 and last as RowNumbers which is the output of Get number of rows.

@mewky , please find below approach which will be perfect in your scenario : 

Note : Select Loop through specific rows as mentioned in below image.

Zaid Chougle

Thank you, but I still don't quite understand it. I just learned to use it. This program Do you have any samples or videos? If so, I'd like to study them, please.

Okay @mewky,

Let me explain you line by line : 

• Open your excel file using Excel Advanced → Open with the path.
• Use action → Get number of rows present under Excel Advanced. In this the output will be in a number type variable.
• Drag and Drop Loop→ For each rows in a excel advanced → Loop through Specific rows→ From Row should be always 2 as first row has headers, To Row will be the number variable which has the total number of rows which has data in the excel file.

Feel free to let me know whether you understood or not.

Zaid Chougle

First of all, I want to apologize for not understanding your meaning. Because I just learned how to do it. I configured it like this and it doesn't work. I'm still confused.

mewky wrote:

Zaid Chougle

First of all, I want to apologize for not understanding your meaning. Because I just learned how to do it. I configured it like this and it doesn't work. I'm still confused.

No issues @mewky 😄,

• Firstly let me know whether the data is present in the Sheet1 or Sheet2 in the excel that you have opened, reason being you have entered index 2 in Gen number or rows.
• Secondly In the loop instead of All rows select → Loop through specific rows and in that → Set the start from 2 and end to $ExcelRowsVolume$(Variable that you created in action Get number of rows.

Feel free to ask any question you have.