Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Russian Wyatt 2
Go to solution Solved by David Beagan ,

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...