[prev in list] [next in list] [prev in thread] [next in thread]
List: poi-user
Subject: AW: AW: Is XML a solution for creating large excel-files?
From: Jörn_Heid <heid () fh-heilbronn ! de>
Date: 2002-03-31 20:56:29
[Download RAW message or body]
If you want to know it....
Those data are measurements from a nuclear power plant for a visualisation
(no critical data of course ;).
If you want to see for example a curve of temperatures throughout one month
you will receive a lot of data :)
Most queries result in about 300 lines but some won't...
-----Ursprüngliche Nachricht-----
Von: Andrew C. Oliver [mailto:acoliver@apache.org]
Gesendet: Sonntag, 31. März 2002 10:07
An: poi users
Betreff: Re: AW: Is XML a solution for creating large excel-files?
What always baffles me... is who the heck reads these long
spreadsheets!?
-Andy
On Sun, 2002-03-31 at 02:22, Jörn Heid wrote:
> Thanks for your answer.
>
> The problem is that my program is running on normal desktop systems (with
> about 128 mb RAM). I can increase the heap size but because of swapping
the
> system will nearly freeze when the vm reaches about 80 mb.
>
> Well, I have to insert a warning message about that (I've already got one
> for that stupid 65,000 row limit).
>
> Thanks again for your answer.
>
> JOERN
>
>
> -----Ursprüngliche Nachricht-----
> Von: Andrew C. Oliver [mailto:acoliver@apache.org]
> Gesendet: Samstag, 30. März 2002 23:34
> An: poi users
> Betreff: Re: Is XML a solution for creating large excel-files?
>
>
> Why can't you just pass -Xmx100m or something to your JVM and allocate
> more memory?
>
> The serializer is no work around for this problem. Large files require
> a lot of memory. The structure of an XLS file requires us to keep the
> whole thing in memory before writing it out (sorry to say). The reason
> being that there are upstream pointers in the file to downstream
> portions. So we have to have the whole thing constructed before we know
> where the latter item is going to be. If you're not working in an
> applet then supplying a batch file that relies on JAVA_HOME and shell
> script is standard practice.
>
> -Andy
>
> On Fri, 2002-03-29 at 06:09, Jörn Heid wrote:
> >
> > I have to create some excel files with up to 65,000 rows (excel limit)
and
> > about 20 cols.
> > Using the HSSF API will result in a out of memory exception (well, it
> should
> > work on clients so I can't set up the heap size as swapping will freeze
my
> > program).
> >
> > So perhaps it would be possible to use the HSSF serializer. I just have
to
> > generate SAX events - and if it's possible - the result can be
continously
> > written to disc.
> >
> >
> > So, here's question No. 1: Will this work (will the memory consumption
> keep
> > low)?
> >
> >
> > To make a first test I took an xml example from Cocoon 2.0.2 (attached)
> and
> > the following, simple source code:
> >
> > // I used 1.2dev from Sourceforge and Cocoon 2.0.2-libs and Xerces 2.0.1
> > import net.sourceforge.poi.serialization.HSSFSerializer;
> > import java.io.*;
> > import javax.xml.parsers.*;
> > import org.xml.sax.*;
> >
> > public class SerializerTest {
> >
> > public static void main (String[] argv) throws Exception {
> > HSSFSerializer hssf = new HSSFSerializer();
> > hssf.setOutputStream (new FileOutputStream ("result.xls"));
> >
> > XMLReader reader = SAXParserFactory.newInstance ().newSAXParser
> > ().getXMLReader ();
> > reader.setContentHandler (hssf);
> > reader.parse (new InputSource (new FileInputStream ("test.xml")));
> > }
> > }
> >
> > When running everything works fine (no exception). When opening the
> > result.xls Excel says that the file is corrupted (attached).
> >
> >
> > So I tried the lib drom Cocoon 2 (jakarta-poi-1.5-dev-20020315.jar).
> >
> > After changing the source code (just altered the first import statement)
I
> > receive the following error:
> >
> > Exception in thread "main" java.lang.NullPointerException
> > at
> > org.apache.cocoon.serialization.ElementProcessorSerializer.startEleme
> > nt(ElementProcessorSerializer.java:490)
> > at
> > org.apache.xerces.parsers.AbstractSAXParser.startElement(AbstractSAXP
> > arser.java:434)
> > at
> > org.apache.xerces.impl.XMLNamespaceBinder.startElement(XMLNamespaceBi
> > nder.java:571)
> > at
> > org.apache.xerces.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidat
> > or.java:796)
> > at
> > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen
> > t(XMLDocumentFragmentScannerImpl.java:752)
> > at
> > org.apache.xerces.impl.XMLDocumentScannerImpl$ContentDispatcher.scanR
> > ootElementHook(XMLDocumentScannerImpl.java:927)
> > at
> > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent
> > Dispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1519)
> > at
> > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(XM
> > LDocumentFragmentScannerImpl.java:333)
> > at
> > org.apache.xerces.parsers.StandardParserConfiguration.parse(StandardP
> > arserConfiguration.java:529)
> > at
> > org.apache.xerces.parsers.StandardParserConfiguration.parse(StandardP
> > [...]
> >
> >
> > Please help.
> >
> > Regards,
> > JOERN
> >
> > ----
> >
>
> > <?xml version="1.0"?>
> > <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7">
> > <gmr:Attributes>
> > <gmr:Attribute>
> > <gmr:name>WorkbookView::show_horizontal_scrollbar</gmr:name>
> > <gmr:type>4</gmr:type>
> > <gmr:value>TRUE</gmr:value>
> > </gmr:Attribute>
> > <gmr:Attribute>
> > <gmr:name>WorkbookView::show_vertical_scrollbar</gmr:name>
> > <gmr:type>4</gmr:type>
> > <gmr:value>TRUE</gmr:value>
> > </gmr:Attribute>
> > <gmr:Attribute>
> > <gmr:name>WorkbookView::show_notebook_tabs</gmr:name>
> > <gmr:type>4</gmr:type>
> > <gmr:value>TRUE</gmr:value>
> > </gmr:Attribute>
> > </gmr:Attributes>
> > <gmr:Summary>
> > <gmr:Item>
> > <gmr:name>application</gmr:name>
> > <gmr:val-string>gnumeric</gmr:val-string>
> > </gmr:Item>
> > <gmr:Item>
> > <gmr:name>author</gmr:name>
> > <gmr:val-string>Jody Goldberg</gmr:val-string>
> > </gmr:Item>
> > </gmr:Summary>
> > <gmr:SheetNameIndex>
> > <gmr:SheetName>Sheet 0</gmr:SheetName>
> > </gmr:SheetNameIndex>
> > <gmr:Names/>
> > <gmr:Geometry Width="1166" Height="752"/>
> > <gmr:Sheets>
> > <gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false"
> HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
> OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
> > <gmr:Name>Sheet 0</gmr:Name>
> > <gmr:MaxCol>6</gmr:MaxCol>
> > <gmr:MaxRow>20</gmr:MaxRow>
> > <gmr:Zoom>1.000000</gmr:Zoom>
> > <gmr:Names/>
> > <gmr:PrintInformation>
> > <gmr:Margins>
> > <gmr:top Points="72" PrefUnit="in"/>
> > <gmr:bottom Points="72" PrefUnit="in"/>
> > <gmr:left Points="54" PrefUnit="in"/>
> > <gmr:right Points="54" PrefUnit="in"/>
> > <gmr:header Points="36" PrefUnit="in"/>
> > <gmr:footer Points="36" PrefUnit="in"/>
> > </gmr:Margins>
> > <gmr:vcenter value="0"/>
> > <gmr:hcenter value="0"/>
> > <gmr:grid value="0"/>
> > <gmr:even_if_only_styles value="1"/>
> > <gmr:monochrome value="0"/>
> > <gmr:draft value="0"/>
> > <gmr:titles value="0"/>
> > <gmr:repeat_top value=""/>
> > <gmr:repeat_left value=""/>
> > <gmr:order>d_then_r</gmr:order>
> > <gmr:orientation>landscape</gmr:orientation>
> > <gmr:Header Left="" Middle="&[TAB]" Right=""/>
> > <gmr:Footer Left="" Middle="Page &[PAGE]" Right=""/>
> > <gmr:paper>US-Letter</gmr:paper>
> > </gmr:PrintInformation>
> > <gmr:Styles>
> > <gmr:StyleRegion startCol="1" startRow="13" endCol="1"
> endRow="13">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="6" Color="0:0:0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="2" startRow="14" endCol="3"
> endRow="14">
> > <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="1" startRow="1" endCol="1"
endRow="1">
> > <gmr:Style HAlign="1" VAlign="1" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="6" Color="0:0:0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="6" Color="0:0:0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="0" startRow="13" endCol="0"
> endRow="13">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="1" startRow="14" endCol="1"
> endRow="14">
> > <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="6" Color="0:0:0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="0" startRow="15" endCol="3"
> endRow="15">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="0" startRow="14" endCol="0"
> endRow="14">
> > <gmr:Style HAlign="4" VAlign="4" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="8" startRow="0" endCol="15"
> endRow="255">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="16" startRow="0" endCol="63"
> endRow="4095">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="7" startRow="0" endCol="7"
endRow="31">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="6" startRow="21" endCol="6"
> endRow="31">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="6" startRow="0" endCol="6"
endRow="19">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="4" startRow="0" endCol="5"
endRow="31">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="6" startRow="20" endCol="6"
> endRow="20">
> > <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="4" startRow="32" endCol="7"
> endRow="255">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="0" startRow="16" endCol="3"
> endRow="255">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="0" startRow="256" endCol="15"
> endRow="4095">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="64" startRow="0" endCol="255"
> endRow="65535">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="2" startRow="2" endCol="3"
endRow="12">
> > <gmr:Style HAlign="1" VAlign="1" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="1" startRow="0" endCol="3"
endRow="0">
> > <gmr:Style HAlign="8" VAlign="4" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="0" startRow="4096" endCol="63"
> endRow="65535">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="1" startRow="2" endCol="1"
endRow="12">
> > <gmr:Style HAlign="1" VAlign="1" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="6" Color="0:0:0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="0" startRow="1" endCol="0"
endRow="12">
> > <gmr:Style HAlign="4" VAlign="4" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="2" startRow="13" endCol="3"
> endRow="13">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="0" startRow="0" endCol="0"
endRow="0">
> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > <gmr:StyleRegion startCol="2" startRow="1" endCol="3"
endRow="1">
> > <gmr:Style HAlign="1" VAlign="1" WrapText="0" Orient="1"
> Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0"
> Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)">
> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0"
> StrikeThrough="0">Helvetica</gmr:Font>
> > <gmr:StyleBorder>
> > <gmr:Top Style="6" Color="0:0:0"/>
> > <gmr:Bottom Style="0"/>
> > <gmr:Left Style="0"/>
> > <gmr:Right Style="0"/>
> > <gmr:Diagonal Style="0"/>
> > <gmr:Rev-Diagonal Style="0"/>
> > </gmr:StyleBorder>
> > </gmr:Style>
> > </gmr:StyleRegion>
> > </gmr:Styles>
> > <gmr:Cols DefaultSizePts="48">
> > <gmr:ColInfo No="0" Unit="97" MarginA="1" MarginB="2"/>
> > <gmr:ColInfo No="1" Unit="80" MarginA="1" MarginB="2"
Count="4"/>
> > <gmr:ColInfo No="6" Unit="48" MarginA="2" MarginB="2"/>
> > </gmr:Cols>
> > <gmr:Rows DefaultSizePts="12.8">
> > <gmr:RowInfo No="0" Unit="20" MarginA="1" MarginB="0"
Count="15"/>
> > <gmr:RowInfo No="20" Unit="18" MarginA="0" MarginB="0"/>
> > </gmr:Rows>
> > <gmr:Selections CursorCol="2" CursorRow="28">
> > <gmr:Selection startCol="2" startRow="28" endCol="2"
endRow="28"/>
> > </gmr:Selections>
> > <gmr:Objects>
> > <gmr:SheetObjectFilled Type="102" Width="1"
ObjectBound="D15:E16"
> ObjectOffset="0.00934579409658909 0.0370370373129845 0.359375
> 0.0588235296308994" ObjectAnchorType="0 0 0 0" Direction="255"/>
> > </gmr:Objects>
> > <gmr:Cells>
> > <gmr:Cell Col="1" Row="0" ValueType="60">
> > <gmr:Content>DOS</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="0" ValueType="60">
> > <gmr:Content>Linux</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="0" ValueType="60">
> > <gmr:Content>SCO</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="1" ValueType="60">
> > <gmr:Content>Jannuary</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="1" ValueType="30">
> > <gmr:Content>1000</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="1" ValueType="30">
> > <gmr:Content>900</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="1" ValueType="30">
> > <gmr:Content>500</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="2" ValueType="60">
> > <gmr:Content>February</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="2" ValueType="30">
> > <gmr:Content>900</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="2" ValueType="30">
> > <gmr:Content>2500</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="2" ValueType="30">
> > <gmr:Content>300</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="3" ValueType="60">
> > <gmr:Content>March</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="3" ValueType="30">
> > <gmr:Content>800</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="3" ValueType="30">
> > <gmr:Content>4100</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="3" ValueType="30">
> > <gmr:Content>100</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="4" ValueType="60">
> > <gmr:Content>April</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="4" ValueType="30">
> > <gmr:Content>700</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="4" ValueType="30">
> > <gmr:Content>5700</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="4" ValueType="30">
> > <gmr:Content>-100</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="5" ValueType="60">
> > <gmr:Content>May</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="5" ValueType="30">
> > <gmr:Content>600</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="5" ValueType="30">
> > <gmr:Content>7300</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="5" ValueType="30">
> > <gmr:Content>-300</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="6" ValueType="60">
> > <gmr:Content>June</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="6" ValueType="30">
> > <gmr:Content>500</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="6" ValueType="30">
> > <gmr:Content>8900</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="6" ValueType="30">
> > <gmr:Content>-500</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="7" ValueType="60">
> > <gmr:Content>July</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="7" ValueType="30">
> > <gmr:Content>400</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="7" ValueType="30">
> > <gmr:Content>10500</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="7" ValueType="30">
> > <gmr:Content>-700</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="8" ValueType="60">
> > <gmr:Content>August</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="8" ValueType="30">
> > <gmr:Content>300</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="8" ValueType="30">
> > <gmr:Content>12100</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="8" ValueType="30">
> > <gmr:Content>-900</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="9" ValueType="60">
> > <gmr:Content>September</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="9" ValueType="30">
> > <gmr:Content>200</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="9" ValueType="30">
> > <gmr:Content>13700</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="9" ValueType="30">
> > <gmr:Content>-1100</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="10" ValueType="60">
> > <gmr:Content>October</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="10" ValueType="30">
> > <gmr:Content>100</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="10" ValueType="30">
> > <gmr:Content>15300</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="10" ValueType="30">
> > <gmr:Content>-1300</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="11" ValueType="60">
> > <gmr:Content>November</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="11" ValueType="30">
> > <gmr:Content>0</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="11" ValueType="30">
> > <gmr:Content>16900</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="11" ValueType="30">
> > <gmr:Content>-1500</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="12" ValueType="60">
> > <gmr:Content>December</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="12" ValueType="30">
> > <gmr:Content>-100</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="12" ValueType="30">
> > <gmr:Content>18500</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="12" ValueType="30">
> > <gmr:Content>-1700</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="0" Row="14" ValueType="60">
> > <gmr:Content>Totals:</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="1" Row="14">
> > <gmr:Content>=sum(B2:B13)</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="2" Row="14">
> > <gmr:Content>=sum(C1:C13)</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="3" Row="14">
> > <gmr:Content>=sum(D2:D13)</gmr:Content>
> > </gmr:Cell>
> > <gmr:Cell Col="6" Row="20" ValueType="60">
> > <gmr:Content>Bad year</gmr:Content>
> > </gmr:Cell>
> > </gmr:Cells>
> > <gmr:Solver TargetCol="-1" TargetRow="-1" ProblemType="1"
> Inputs=""/>
> > </gmr:Sheet>
> > </gmr:Sheets>
> > <gmr:UIData SelectedTab="0"/>
> > </gmr:Workbook>
> --
> http://www.superlinksoftware.com
> http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound
> Document
> format to java
> http://developer.java.sun.com/developer/bugParade/bugs/4487555.html
> - fix java generics!
> The avalanche has already started. It is too late for the pebbles to
> vote.
> -Ambassador Kosh
>
--
http://www.superlinksoftware.com
http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound
Document
format to java
http://developer.java.sun.com/developer/bugParade/bugs/4487555.html
- fix java generics!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic