File: demo_template.xml

Recommend this page to a friend!
demo_template.xml
File:	`demo_template.xml`
Role:	Auxiliary data
Content type:	`text/plain`
Description:	example and test - Excel template
Class:	TinyButStrong plug-in for Excel Generate Excel spreadsheets using template plug-in
Author:	By Skrol29
Last change:	new version of the plug-in
Date:	13 years ago
Size:	`11,716 bytes`
Download
<?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">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>Skrol29</Author>
  <LastAuthor>Qwerty</LastAuthor>
  <Created>1996-10-21T11:03:58Z</Created>
  <LastSaved>2006-05-30T22:05:56Z</LastSaved>
  <Version>14.00</Version>
 </DocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <DownloadComponents/>
  <LocationOfComponents HRef="file:///F:\"/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>4500</WindowHeight>
  <WindowWidth>9180</WindowWidth>
  <WindowTopX>240</WindowTopX>
  <WindowTopY>135</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
  <DisplayInkNotes>False</DisplayInkNotes>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Arial" x:Family="Swiss"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s62" ss:Name="Euro">
   <NumberFormat
    ss:Format="_-* #,##0.00\ &quot;€&quot;_-;\-* #,##0.00\ &quot;€&quot;_-;_-* &quot;-&quot;??\ &quot;€&quot;_-;_-@_-"/>
  </Style>
  <Style ss:ID="s63">
   <Font ss:FontName="Times New Roman" x:Family="Roman" ss:Size="16" ss:Bold="1"/>
  </Style>
  <Style ss:ID="s64">
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Bold="1"/>
  </Style>
  <Style ss:ID="s65">
   <Font ss:FontName="Arial" x:Family="Swiss"/>
   <NumberFormat ss:Format="yyyy\-mm\-dd"/>
  </Style>
  <Style ss:ID="s66">
   <NumberFormat ss:Format="yyyy\-mm\-dd"/>
  </Style>
  <Style ss:ID="s67">
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Color="#008000" ss:Bold="1"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s68">
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Color="#008000" ss:Bold="1"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="#,##0_ ;\-#,##0\ "/>
  </Style>
  <Style ss:ID="s69">
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Color="#008000" ss:Bold="1"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="#,##0.00\ &quot;€&quot;;\-#,##0.00\ &quot;€&quot;"/>
  </Style>
  <Style ss:ID="s70">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Bold="1"/>
   <Interior ss:Color="#99CCFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s71">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </Style>
  <Style ss:ID="s73" ss:Parent="s62">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s74">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <NumberFormat ss:Format="0;\ \-0;\ &quot;-&quot;"/>
  </Style>
  <Style ss:ID="s75" ss:Parent="s62">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </Style>
  <Style ss:ID="s77">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s78">
   <Alignment ss:Vertical="Bottom" ss:Rotate="90"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s79">
   <Alignment ss:Vertical="Bottom" ss:Rotate="90"/>
  </Style>
  <Style ss:ID="s80">
   <Interior ss:Color="#99CCFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s81">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Bold="1"/>
   <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="0.0"/>
  </Style>
  <Style ss:ID="s82">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <NumberFormat ss:Format="0.0;\-0.0;&quot;-&quot;"/>
  </Style>
 </Styles>
 <Names>
  <NamedRange ss:Name="bonjour" ss:RefersTo="=#REF!"/>
 </Names>
 <Worksheet ss:Name="Example1">
  <Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="9" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="60">
   <Column ss:AutoFitWidth="0" ss:Width="20.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="189"/>
   <Column ss:AutoFitWidth="0" ss:Width="63.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="55.5"/>
   <Row ss:AutoFitHeight="0" ss:Height="20.25">
    <Cell ss:Index="2" ss:StyleID="s63"><Data ss:Type="String">Books in stock</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="3" ss:StyleID="s64"><Data ss:Type="String">PHP version:</Data></Cell>
    <Cell ss:StyleID="s65"><Data ss:Type="String">[onshow..cst.PHP_VERSION]</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="3" ss:StyleID="s64"><Data ss:Type="String">TBS version:</Data></Cell>
    <Cell ss:StyleID="s65"><Data ss:Type="String">[onshow..version]</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="3" ss:StyleID="s64"><Data ss:Type="String">Current date:</Data></Cell>
    <Cell ss:StyleID="s66"><Data ss:Type="String">[onload..now;ope=xlDT]</Data></Cell>
   </Row>
   <Row ss:Index="6">
    <Cell ss:Index="3" ss:StyleID="s67"><Data ss:Type="String">Total:</Data></Cell>
    <Cell ss:StyleID="s68"
     ss:Formula="=SUM(R[2]C:R[2]C)+N(&quot;[book.#;ope=xlPushRef]&quot;)"><Data
      ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s69"
     ss:Formula="=SUM(R[2]C:R[2]C)+N(&quot;[book.#;ope=xlPushRef]&quot;)"><Data
      ss:Type="Error">#VALUE!</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="2" ss:StyleID="s70"><Data ss:Type="String">Title</Data></Cell>
    <Cell ss:StyleID="s70"><Data ss:Type="String">Price</Data></Cell>
    <Cell ss:StyleID="s70"><Data ss:Type="String">Stock</Data></Cell>
    <Cell ss:StyleID="s70"><Data ss:Type="String">Amount</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="15">
    <Cell ss:Index="2" ss:StyleID="s71"><Data ss:Type="String">[book.title;block=Row]</Data></Cell>
    <Cell ss:StyleID="s73"><Data ss:Type="String">[book.price;ope=xlNum]</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">[book.stock;ope=xlNum]</Data></Cell>
    <Cell ss:StyleID="s75" ss:Formula="=RC[-1]*RC[-2]"><Data ss:Type="Error">#VALUE!</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="3" ss:StyleID="s67"><Data ss:Type="String">Total:</Data></Cell>
    <Cell ss:StyleID="s68" ss:Formula="=SUM(R8C:R[-1]C)"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s69" ss:Formula="=SUM(R8C:R[-1]C)"><Data ss:Type="Error">#VALUE!</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.4921259845"/>
    <Footer x:Margin="0.4921259845"/>
    <PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
     x:Right="0.78740157499999996" x:Top="0.984251969"/>
   </PageSetup>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <HorizontalResolution>600</HorizontalResolution>
    <VerticalResolution>0</VerticalResolution>
   </Print>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>14</ActiveRow>
     <ActiveCol>2</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
 <Worksheet ss:Name="Example2">
  <Table ss:ExpandedColumnCount="24" ss:ExpandedRowCount="3" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="60">
   <Column ss:AutoFitWidth="0" ss:Width="15"/>
   <Column ss:AutoFitWidth="0" ss:Width="131.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="22.5" ss:Span="1"/>
   <Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="20.25" ss:Span="19"/>
   <Row ss:AutoFitHeight="0" ss:Height="20.25">
    <Cell ss:Index="2" ss:StyleID="s63"><Data ss:Type="String">Time spent by task</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="101.25">
    <Cell ss:Index="3" ss:StyleID="s77"><Data ss:Type="String">Tot</Data></Cell>
    <Cell ss:StyleID="s78"><Data ss:Type="String">[tsk1.title;block=Cell]</Data></Cell>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
   </Row>
   <Row>
    <Cell ss:Index="2" ss:StyleID="s80"><Data ss:Type="String">[emp.fname;block=Row] [emp.lname]</Data></Cell>
    <Cell ss:StyleID="s81"
     ss:Formula="=SUM(RC[1]:RC[1])+N(&quot;[tsk1.#;ope=xlPushRef]&quot;)"><Data
      ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s82"><Data ss:Type="String">[var.times2.[tsk2.t_id;block=Cell].[emp.e_id];ope=xlNum;noerr]</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.4921259845"/>
    <Footer x:Margin="0.4921259845"/>
    <PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
     x:Right="0.78740157499999996" x:Top="0.984251969"/>
   </PageSetup>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <HorizontalResolution>-3</HorizontalResolution>
    <VerticalResolution>0</VerticalResolution>
   </Print>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>7</ActiveRow>
     <ActiveCol>1</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
About us
Advertise on this site
For more information send a message to info at phpclasses dot org.
File: demo_template.xml

Contents
