Delete the first two rows from an excel import file (raw file).

Hi all,

I would like to delete the first two rows from my excel import to my application as you can see below.


So Rows 1 & 2 


And start my for each widget from row 3.

Any help please ?


Thank you in anticipation

Anastasios

Hi,

you can use start index property in for each to start from row 3.

Hi Bruno,

Sure but what is the command to do that please?

thanks

The standard ExcelToRecordlist will not work if the first 2 rows wont fit into your record definition structure.


There are some cool Excel utils on the forge. I would try the Advanced Excel to manipulate the excel and then use the ExcelToRecordlist to import the rows you need.

Thanks Stefano,

I will try that then!