newbie question



hi,

my source is a xml file. via xsl i want to generate xls.
as in my subject mentioned, i am a total newbie.
the only thing i found on the web was this documentation:

http://www.superlinksoftware.com/gnumeric-xml.pdf

there is no second release of this manual.
i found loads of docs how to create xls with java and what xml - generated
with excel - looks like.

maybe you can help me to get familiar to this subject.

my second question:
i tried some tasks of the documentation i found on the web.
but some ( simple) thing just don' t want to work, or better: i do
something wrong, but i don't have a clue what this is.
e.g.

snip
          <gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="
false" HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
            <gmr:Name>floras sheet</gmr:Name>
            <gmr:MaxCol>20</gmr:MaxCol>
            <gmr:Cols DefaultSizePts="148">
               <gmr:ColInfo No="0" Unit="18" MarginA="2" MarginB="2" Count
="7"/>
            </gmr:Cols>
            <gmr:Zoom>5.000000</gmr:Zoom>
            <gmr:Rows DefaultSizePts="50.8">
               <gmr:RowInfo No="0" Unit="42.8" MarginA="0" MarginB="0"
Count="9"/>
               <gmr:RowInfo No="10" Unit="12.8" MarginA="1" MarginB="0"
Count="24"/>
            </gmr:Rows>
            <gmr:Cells>
               <gmr:Styles>
                 <gmr:StyleRegion startCol="0" startRow="0" endCol="255"
endRow="65535">
                    <gmr:Style HAlign="8" WrapText="0" Orient="4" Shade="0"
Indent="0" Fore="3000:3000:3000" Back="3000:3000:3000" PatternColor="
3000:3000:3000" Format="General">
                      <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
Strikethrough="0">Helvetica</gmr:Font>
                      <gmr:StyleBorder>
                         <gmr:Top Style="1"/>
                         <gmr:Bottom Style="1"/>
                         <gmr:Left Style="1"/>
                         <gmr:Right Style="1"/>
                         <gmr:Diagonal Style="1"/>
                         <gmr:Rev-Diagonal Style="2"/>
                      </gmr:StyleBorder>
                    </gmr:Style>
                 </gmr:StyleRegion>
               </gmr:Styles>
               <gmr:Cell Col="1" Row="1" ValueType="60">
                 <gmr:Content>10</gmr:Content>
               </gmr:Cell>
               <gmr:Cell Col="3" Row="1" ValueType="60">
                 <gmr:Content>=(B2)</gmr:Content>
               </gmr:Cell>
               <gmr:Selections CursorCol="2" CursorRow="3">
                 <gmr:Selection startCol="2" startRow="3" endCol="2" endRow
="3"/>
               </gmr:Selections>
            </gmr:Cells>
          </gmr:Sheet>
snip
but the formular, border and the backgroundcolor just does not work

thanks in advance

flora





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]