Re: Skipping Cells

[Bruce <bruce@xxxxxxxxxxx>]

What about xml?  Office2003 can save as xml.  It has lots of extra stuff 
in there, but simple xml can be created and viewed as classic 
spreadsheets.  Not sure if back version work or can be retro'd. 
StarOffice didn't much like it either.

Here's my silly sample.
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
     xmlns:o="urn:schemas-microsoft-com:office:office"
     xmlns:x="urn:schemas-microsoft-com:office:excel"
     xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
     xmlns:html="http://www.w3.org/TR/REC-html40";>
    <Worksheet ss:Name="Sheet1">
        <Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="3" 
x:FullColumns="1" x:FullRows="1">
            <Row>
                <Cell><Data ss:Type="String">A1</Data></Cell>
                <Cell ss:Index="3"><Data ss:Type="Number">1</Data></Cell>
            </Row>
            <Row>
                <Cell><Data ss:Type="String">A2</Data></Cell>
                <Cell><Data ss:Type="String">B2</Data></Cell>
                <Cell><Data ss:Type="Number">2</Data></Cell>
            </Row>
            <Row>
                <Cell><Data ss:Type="String">A3</Data></Cell>
                <Cell><Data ss:Type="Number">123</Data></Cell>
                <Cell ss:Formula="=SUM(R[-2]C:R[-1]C)"><Data 
ss:Type="Number">3</Data></Cell>
            </Row>
        </Table>
    </Worksheet>
</Workbook>

When viewed in Excel, will display as the following:
A1              1
A2    B2        2
A3       123    3


A google search might turn up more info on the tags and attributes. 
Good luck.


hth,
Bruce in AR

Bob O. wrote:
> 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.  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?