PHP Classes
Icontem

File: demo_template.xls


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Skrol29  >  TinyButStrong plug-in for Excel  >  demo_template.xls  
File: demo_template.xls
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
 

Contents

Class file image 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>12.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"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s64" ss:Name="Euro">
   <NumberFormat
    ss:Format="_-* #,##0.00\ &quot;€&quot;_-;\-* #,##0.00\ &quot;€&quot;_-;_-* &quot;-&quot;??\ &quot;€&quot;_-;_-@_-"/>
  </Style>
  <Style ss:ID="s65">
   <Font ss:FontName="Times New Roman" x:Family="Roman" ss:Size="16" ss:Bold="1"/>
  </Style>
  <Style ss:ID="s66">
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Color="#008000" ss:Bold="1"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
  </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"/>
   <NumberFormat ss:Format="#,##0_ ;\-#,##0\ "/>
  </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.00\ &quot;€&quot;;\-#,##0.00\ &quot;€&quot;"/>
  </Style>
  <Style ss:ID="s69">
   <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="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>
  </Style>
  <Style ss:ID="s72" ss:Parent="s64">
   <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="s73">
   <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="s74" ss:Parent="s64">
   <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="s75">
   <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="s76">
   <Alignment ss:Vertical="Bottom" ss:Rotate="90"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s77">
   <Alignment ss:Vertical="Bottom" ss:Rotate="90"/>
  </Style>
  <Style ss:ID="s78">
   <Interior ss:Color="#99CCFF" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s79">
   <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="s80">
   <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="5" 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="59.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="55.5"/>
   <Row ss:AutoFitHeight="0" ss:Height="20.25">
    <Cell ss:Index="2" ss:StyleID="s65"><Data ss:Type="String">Books in stock</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="3" ss:StyleID="s66"><Data ss:Type="String">Total:</Data></Cell>
    <Cell ss:StyleID="s67"
     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="s68"
     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="s69"><Data ss:Type="String">Title</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Price</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Stock</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Amount</Data></Cell>
   </Row>
   <Row ss:Height="15">
    <Cell ss:Index="2" ss:StyleID="s70"><Data ss:Type="String">[book.title;block=Row]</Data></Cell>
    <Cell ss:StyleID="s72"><Data ss:Type="String">[book.price;ope=xlNum]</Data></Cell>
    <Cell ss:StyleID="s73"><Data ss:Type="String">[book.stock;ope=xlNum]</Data></Cell>
    <Cell ss:StyleID="s74" ss:Formula="=RC[-1]*RC[-2]"><Data ss:Type="Error">#VALUE!</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="3" ss:StyleID="s66"><Data ss:Type="String">Total:</Data></Cell>
    <Cell ss:StyleID="s67" ss:Formula="=SUM(R4C:R[-1]C)"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s68" ss:Formula="=SUM(R4C: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>
     <ActiveCol>1</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="s65"><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="s75"><Data ss:Type="String">Tot</Data></Cell>
    <Cell ss:StyleID="s76"><Data ss:Type="String">[tsk1.title;block=Cell]</Data></Cell>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
    <Cell ss:StyleID="s77"/>
   </Row>
   <Row>
    <Cell ss:Index="2" ss:StyleID="s78"><Data ss:Type="String">[emp.fname;block=Row] [emp.lname]</Data></Cell>
    <Cell ss:StyleID="s79"
     ss:Formula="=SUM(RC[1]:RC[1])+N(&quot;[tsk1.#;ope=xlPushRef]&quot;)"><Data
      ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s80"><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>

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products