4 Community Answers

Matillion Agent

Paul Johnson — Apr 06, 2018 08:44AM UTC

Hi Ganesh,

You can use the Cell Range property of the Excel Query component.

By default the whole worksheet is considered. However, you may optionally specify a range of cells instead. For example, A5:E100 would only consider rows 5-100 in columns A-E. Wildcards () are also supported, for example A5:E would consider columns A-E and rows 5 onwards.