Re: Skipping Cells

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

> I have a project where I need to grab data from the as400 via an RPG 
> program and dump it into an existing excel spreadsheet.

How are you doing that?  Are you outputting a CSV file? Are you using the 
HSSF routines to generate the actual spreadsheet?  Are you outputting 
HTML that Excel understands?  Are you outputting a physical file that is, 
in turn, read by Excel via ODBC? Are you using a third party product to 
generate the spreadsheet?


> There are cells on the spreadsheet that perfrom calculations.  I need to 
> "skip" over these cells so as not to overwrite the formulas.  Is there a 
> way to accomplish this?

I know how to do that with HSSF.  You can call the getCellType() method 
of the HSSFCell class to find out whether the cell is a formula, string 
or numeric cell.

You can't really do it with CSV or HTML, since you don't have the original 
spreadsheet in that case in order to read the contents of existing cells.

I'm sure you can do it with VBA from within Excel, but I've no experience 
with that method, so I'll let other people give you advice if that's the 
case.