Load Certain Excel Cell

[jasonwills]

Hi All,

I know this is a silly, simple one, but I cannot figure it out.

I have a load statement that is loading data from an excel sheet - however, what I'd like to do is to specify a certain cell to import.

e.g - I only want to import the data from E6 on the Data sheet for example.

Thanks in advance all, I do appreciate it.

Regards

Jason

[tamilarasu · Accepted solution]

Hi Jason,

Try like below,

E19:

LOAD E

FROM

Sourcefile.xlsx (ooxml, no labels, table is Sheet1)  WHERE RecNo() = 6;

Here, "E" is column name as we have mentioned no labels for headers. Recno() specifies the cell address. Let me know.

[jasonwills]

Perfect, thanks Tamil,

it was getting the RecNo() syntax in there which I was not doing.

Thankyou very much.

Jason

[tamilarasu]

You are welcome.