cvs: peardoc /en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet repeatcolumns.xml repeatrows.xml

xnoguer Fri May 2 15:52:12 2003 EDT Modified files: /peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet repeatcolumns.xml repeatrows.xml Log: adding example Index: peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatcolumns.xml diff -u peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatcolumns.xml:1.1 peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatcolumns.xml:1.2 --- peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatcolumns.xml:1.1 Thu Apr 10 20:08:06 2003 +++ peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatcolumns.xml Fri May 2 15:52:12 2003 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.1 $ --> +<!-- $Revision: 1.2 $ --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-worksheet.repeatcolumns"> <refnamediv> <refname>Worksheet::repeatColumns</refname> @@ -17,7 +17,7 @@ </paramdef> <paramdef> - resource <parameter><optional>$last_col=NULL</optional></parameter> + integer <parameter><optional>$last_col=NULL</optional></parameter> </paramdef> @@ -27,7 +27,7 @@ <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-worksheet.repeatcolumns.desc"> &title.desc; <para> - Set the columns to repeat at the left hand side of each printed page. See also the _storeNames() methods in Workbook.php + Set the columns to repeat at the left hand side of each printed page. </para> </refsect1> @@ -45,7 +45,7 @@ <listitem> <para> - <parameter>resource $last_col</parameter> - + <parameter>integer $last_col</parameter> - Last column to repeat. Optional. </para> </listitem> Index: peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatrows.xml diff -u peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatrows.xml:1.1 peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatrows.xml:1.2 --- peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatrows.xml:1.1 Thu Apr 10 20:08:06 2003 +++ peardoc/en/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-worksheet/repeatrows.xml Fri May 2 15:52:12 2003 @@ -1,8 +1,8 @@ -<!-- $Revision: 1.1 $ --> +<!-- $Revision: 1.2 $ --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-worksheet.repeatrows"> <refnamediv> <refname>Worksheet::repeatRows</refname> - <refpurpose>Set the rows to repeat at the top of each printed page. See also the</refpurpose> + <refpurpose>Set the rows to repeat at the top of each printed page.</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> @@ -17,7 +17,7 @@ </paramdef> <paramdef> - resource <parameter><optional>$last_row=NULL</optional></parameter> + integer <parameter><optional>$last_row=NULL</optional></parameter> </paramdef> @@ -27,7 +27,7 @@ <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-worksheet.repeatrows.desc"> &title.desc; <para> - Set the rows to repeat at the top of each printed page. See also the _store_name_xxxx() methods in Workbook.php + Set the rows to repeat at the top of each printed page. </para> </refsect1> @@ -45,7 +45,7 @@ <listitem> <para> - <parameter>resource $last_row</parameter> - + <parameter>integer $last_row</parameter> - Last row to repeat. Optional. </para> </listitem> @@ -73,6 +73,29 @@ <title>Using <function>repeatRows</function></title> <programlisting role="php"> <![CDATA[ +<?php + require_once 'Spreadsheet/Excel/Writer.php'; + + $workbook = new Spreadsheet_Excel_Writer('test.xls'); + $worksheet =& $workbook->addWorkSheet(); + $worksheet->setColumn(0,0,100); + $worksheet->write(0,0,"99 Bottles Of Beer On The Wall- The Complete Lyrics"); + // repeat only the first row + $worksheet->repeatRows(0); + for ($i = 99; $i > 0; $i--) + { + if ($i > 1) { + $next = $i - 1; + } + else { + $next = "no more"; + } + $worksheet->write(100 - $i,0,"$i Bottles of beer on the wall, $i bottles of beer, ". + "take one down, pass it around, ". + "$next bottles of beer on the wall."); + } + $workbook->close(); +?> ]]> </programlisting> </example>