Trying to read just one row of an Excel file, ignoring earlier and later rows

[Russian Wyatt 2]

Part of this project is reading an Excel file and moving the data into an XFOCUS database and in this case I need data from a single row so I can do calculations elsewhere.

I have my .acx/mas files setup so it starts from row 4 of the spreadsheet (row 3 is a garbage header). As you can see below I really only care about the data in Column B, Row 4.

But I don't know how to just read that one line without it reading the rest of the spreadsheet

any ideas?

--------------

SEGNAME=CompanyName, WORKSHEET=Sheet1, HROWS=3, NUMDATA=RAW, $

--------------

FILENAME=CompanyName,SUFFIX=DIREXCEL,

DATASET=CompanyName.xlsx, $

 SEGMENT=CompanyName, SEGTYPE=S0, $

  FIELDNAME=Garbage, ALIAS=Garbage, USAGE=A200V, ACTUAL=A200V, MISSING=ON, TITLE='Garbage', $

  FIELDNAME=UniqueID, ALIAS=UniqueID, USAGE=A10V, ACTUAL=A10V, MISSING=ON, TITLE='UniqueID', $

--------------

TABLE FILE CompanyName

PRINT UniqueID

ON TABLE SET BYDISPLAY ON

END

[David Beagan]

Does this get it for you?

TABLE FILE CompanyName

PRINT UniqueID

WHERE RECORDLIMIT IS 1

ON TABLE SET BYDISPLAY ON

END

[Russian Wyatt 2]

Yes that is exactly what I needed! Thanks