Re: Skipping Cells

[Mihael Knezevic <m.knezevic@xxxxxxxx>]

perhaps you have a look at the apache jakarta poi project. it's a java lib to 
read and write microsoft office documents. you could make calls from rpg to 
java to read and write spreadsheet files.

http://jakarta.apache.org/poi/index.html

afaik there are allready some examples on the net how to do this.

Am Mittwoch, 2. März 2005 15:44 schrieb Bruce:
> 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?
> > 
> > 
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>