How to consider data from specific row of excel

[snagalapur]

Hi All,

Please suggest how to consider data from specific  row of excel as initial few rows are not useful .

Thank you.

[Sebastiaandb]

Hi @snagalapur,

If the first rows are not useful (and also not counting as headers), then just start importing from a specific line like:

If you have multiple null rows after the header, use a filter tool to filter out the first rows. You probably have some null values in a specific column until the point of the rows you actually want to use, just use the filter tool on that specific column and you'll be fine :-).

Greetings,

Seb

[mathieuf · Accepted solution]

Hi @snagalapur,

When connecting to an Excel file you also have the ability to select a range or named range:

[snagalapur]

Thank you for help.

[snagalapur]

Hi Seb,

Thank you for help, because of file type i was unable to use this option.