Re: Skipping Cells -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.