Hi Marty,
why not xml ... you can create these files easy with CGIDEV2
the table section is not harder than this ...
<Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="4" x:FullColumns="1"
x:FullRows="1">
<Column ss:AutoFitWidth="0" ss:Width="99"/>
<Column ss:AutoFitWidth="0" ss:Width="126.75"/>
<Column ss:AutoFitWidth="0" ss:Width="89.25"/>
<Row>
<Cell><Data ss:Type="String">heading a1</Data></Cell>
<Cell><Data ss:Type="String">heading b1</Data></Cell>
<Cell><Data ss:Type="String">heading c1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">data a2</Data></Cell>
<Cell><Data ss:Type="String">data b2</Data></Cell>
<Cell><Data ss:Type="String">data c2</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s21"><Data ss:Type="String">data a3 bold</Data></Cell>
<Cell><Data ss:Type="String">data b3</Data></Cell>
<Cell><Data ss:Type="String">data c3</Data></Cell>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="25.5">
<Cell><Data ss:Type="String">data a4</Data></Cell>
<Cell ss:StyleID="s22"><Data ss:Type="String">data b4</Data></Cell>
<Cell><Data ss:Type="String">data c4</Data></Cell>
</Row>
</Table>
I used Excel to create a spreadsheet, saved it as an XML file then opened
it in wordpad and saved it again as a textfile with .xls as suffix/filetype
Try to open the attached file with wordpad ...
rgds
henrik
| "itpweb1" <[EMAIL PROTECTED]>
Sent by: [email protected] 15-12-2005 14:44
|
|
What are my options for creating Excel spreasheets from AS/400
programs. AS/400 PF and spool file donwload is great, but
users are starting to want more than basic CSV import functionality.
CSV format is good but lacks support for column width, formatting,
multi-tabed documents.
Some power users have successfully built large complicated 'import and
format' VBA spreadsheets, but these tend to require constant
maintenance, do not scale well, are dificult to audit and usually end
up at IT's doorstep in a panic at year-end months after their creator
has left.
We are trying to replace these VBA creations with a more centalized,
streamlined approach, but come up short in formatting and layout options.
Ultimately I would like to generate Excel .xls files as easily as I
can now create .html files with CGIDEV2, hopefully without adding new
dedicated servers or complicated client-side software.
I see the open source java world is getting there with new tools like
POIFS (Poor Obfuscation Implementation File System)
HSSF (Horrible Spreadsheet Format)
ref: http://www.javaworld.com/javaworld/jw-03-2004/jw-0322-poi_p.html
What are my options in the as/400 world?
marty
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income homes are not online. Make a difference this holiday season!
http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/wbFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Easy400Group/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
YAHOO! GROUPS LINKS
- Visit your group "Easy400Group" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
test3.xls
Description: MS-Excel spreadsheet
