Re: Read EXCEL Worksheet by Column

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

Hi Jeff,

XLPARSER4 is for reading the whole spreadsheet.

The POI Java classes (and my HSSFR4 utilities for working with them) 
have routines to retrieve cells.  For example, if you want cell C15, you 
need to get column 2 (since col A=0, B=1, C=2) and row 14 (since their 
numbered from 0 in POI)

   rowno = 14;
   colno = 2;

   row = SSSheet_getRow( mySheet: rowno );
   cell = SSRow_getCell( row : colno );

Now you have a POI SSCell object.  You can retrieve it's contents using:

    SSCell_getCellType() -- tells you the type of cell
                             (numeric, string, formula, etc)

    SSCell_getFormula() -- retrieves a formula

    SSCell_getNumericCellValue() -- retrieves a number

    SSCell_getStringValue() -- retrieves a string

...etc...


On 2/27/2012 2:00 PM, Jeff Young wrote:
> All,
> I seem to recall that Scott Klement had procedures that could be used to
> read an EXCEL Worksheet and select a specific column to be retrieved, but
> can not seem to find anything like that.
>
> The only thing I can find is the XLPARSE4 and the similar ones from
> Easy/400, but they read the entire worksheet and pass control to a
> subprocedure based on the data type of the column.
>
> Does anyone recall such a procedure and know where I can find them?
>
> Thanks,
> ,