cvs: peardoc /fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer rowcoltocell.xml send.xml spreadsheet-excel-writer.xml
/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook addformat.xml addworksheet.xml close.xml setcustomcolor.xml
settempdir.xml
| From: | Yannick Torres | Date: | Wed, 15 Mar 2006 21:24:33 +0000 |
| Subject: | cvs: peardoc /fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer rowcoltocell.xml send.xml spreadsheet-excel-writer.xml /fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook addformat.xml addworksheet.xml close.xml setcustomcolor.xml settempdir.xml |
||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-7673@lists.php.net to get a copy of this message | ||
yannick Wed Mar 15 21:24:33 2006 UTC
Added files:
/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer
rowcoltocell.xml
send.xml
spreadsheet-excel-writer.xml
/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook
addformat.xml
addworksheet.xml
close.xml
setcustomcolor.xml
settempdir.xml
Log:
initiale translation
http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/rowcoltocell.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/rowcoltocell.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/rowcoltocell.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.2 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell"> <refnamediv> <refname>Spreadsheet_Excel_Writer::rowcolToCell</refname> <refpurpose>Fonction pour l'écriture de formules</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>void <function>Spreadsheet_Excel_Writer::rowcolToCell</function></funcdef> <paramdef> integer <parameter>$row</parameter> </paramdef> <paramdef> integer <parameter>$col</parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell.desc"> &title.desc; <para> Fonction pour l'écriture de formules. Convertit les coordonnées d'une cellule en un format A1. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>integer $row</parameter> - Ligne de la cellule à convertir (indexé à partir de 0). </para> </listitem> <listitem> <para> <parameter>integer $col</parameter> - Colonne de la cellule à convertir (indexé à partir de 0). </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell.return"> &title.returns; <para> <emphasis>retour</emphasis> - L'identifiant de cellule dans un format A1 en cas de succès, une PEAR_Error en cas d'échec. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell.example"> &title.example; <example> <title>Exemple avec <function>rowcolToCell</function></title> <programlisting role="php"> <![CDATA[ require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('rowcol.xls'); $worksheet1 =& $workbook->addWorksheet("rowcol"); $first = 1; $last = 10; for ($i = $first; $i <= $last; $i++) { $worksheet1->write($i, 1, $i); } $cell1 = Spreadsheet_Excel_Writer::rowcolToCell($first, 1); $cell2 = Spreadsheet_Excel_Writer::rowcolToCell($last, 1); $worksheet1->write($last + 1, 0, "Total ="); $worksheet1->writeFormula($last + 1, 1, "=SUM($cell1:$cell2)"); $workbook->close(); ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/send.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/send.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/send.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.3 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send"> <refnamediv> <refname>Spreadsheet_Excel_Writer::send</refname> <refpurpose>Envoi les en-têtes HTTP pour le fichier Excel</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>void <function>Spreadsheet_Excel_Writer::send</function></funcdef> <paramdef> string <parameter>$filename</parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send.desc"> &title.desc; <para> Envoi les en-têtes HTTP pour le fichier Excel. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>string $filename</parameter> - Le nom du fichier à utiliser pour les en-têtes HTTP. </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send.example"> &title.example; <example> <title>Exemple avec <function>send</function></title> <programlisting role="php"> <![CDATA[ ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/spreadsheet-excel-writer.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/spreadsheet-excel-writer.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/spreadsheet-excel-writer.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.3 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer"> <refnamediv> <refname>Spreadsheet_Excel_Writer::Spreadsheet_Excel_Writer</refname> <refpurpose>Le constructeur. Il crée juste un manuel de travail</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>object The <function>Spreadsheet_Excel_Writer::Spreadsheet_Excel_Writer</function></funcdef> <paramdef> string <parameter><optional>$filename=''</optional></parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.desc"> &title.desc; <para> Le constructeur. Il crée juste un manuel de travail. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>string $filename</parameter> - Le nom du fichier optionnel pour le manuel de travail. </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.return"> &title.returns; <para> Retourne l'objet créé représentant le manuel de travail. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.example"> &title.example; <example> <title>Exemple avec <function>Spreadsheet_Excel_Writer</function></title> <programlisting role="php"> <![CDATA[ ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addformat.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addformat.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addformat.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat"> <refnamediv> <refname>Workbook::&addFormat</refname> <refpurpose>Ajoute un nouveau format au manuel de travail Excel</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>object reference <function>Workbook::&addFormat</function></funcdef> <paramdef> array <parameter><optional>$properties=array()</optional></parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.desc"> &title.desc; <para> Ajoute un nouveau format au manuel de travail Excel. Passe également toutes les propriétés au constructeur du format. Les propriétés valides sont : </para> <para> <itemizedlist> <listitem> <para> Align </para> </listitem> <listitem> <para> Bold </para> </listitem> <listitem> <para> Bottom </para> </listitem> <listitem> <para> Top </para> </listitem> <listitem> <para> Left </para> </listitem> <listitem> <para> Right </para> </listitem> <listitem> <para> Border </para> </listitem> <listitem> <para> BorderColor </para> </listitem> <listitem> <para> BottomColor </para> </listitem> <listitem> <para> TopColor </para> </listitem> <listitem> <para> RightColor </para> </listitem> <listitem> <para> LeftColor </para> </listitem> <listitem> <para> FgColor </para> </listitem> <listitem> <para> BgColor </para> </listitem> <listitem> <para> Color </para> </listitem> <listitem> <para> Pattern </para> </listitem> <listitem> <para> Underline </para> </listitem> <listitem> <para> TextRotation </para> </listitem> <listitem> <para> Size </para> </listitem> <listitem> <para> NumFormat </para> </listitem> <listitem> <para> Script </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>array $properties</parameter> - tableau contenant les propriétés pour l'initialisation du format. </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.return"> &title.returns; <para> Retourne un objet de référence d'un format Excel. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.example"> &title.example; <example> <title>Exemple avec <function>&addFormat</function></title> <programlisting role="php"> <![CDATA[ <?php require_once "Spreadsheet/Excel/Writer.php"; $workbook = new Spreadsheet_Excel_Writer(); $format =& $workbook->addFormat(array('Size' => 10, 'Align' => 'center', 'Color' => 'white', 'Pattern' => 1, 'FgColor' => 'magenta')); $worksheet =& $workbook->addWorksheet(); $worksheet->writeString(1, 0, "Bonjour en Magenta !", $format); $workbook->close(); ?> ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addworksheet.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addworksheet.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addworksheet.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.6 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet"> <refnamediv> <refname>Workbook::&addWorksheet</refname> <refpurpose>Ajoute une nouvelle feuille de travail à un manuel de travail Excel</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>object reference <function>Workbook::&addWorksheet</function></funcdef> <paramdef> string <parameter><optional>$name=''</optional></parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.desc"> &title.desc; <para> Ajoute une nouvelle feuille de travail à un manuel de travail Excel. Si aucun nom n'est donné, le nom de la feuille de travail sera "Sheet<parameter>i</parameter>" avec <parameter>i</parameter> de [1..] à n. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>string $name</parameter> - le nom optionnel de la feuille de travail. Ne peut pas contenir plus de 31 caractères. </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.return"> &title.returns; <para> Retourne une référence à un objet de feuille de travail en cas de succès, une PEAR_Error en cas d'échec. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.example"> &title.example; <example> <title>Exemple avec <function>&addWorksheet</function></title> <programlisting role="php"> <![CDATA[ <?php require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('test.xls'); $worksheet =& $workbook->addWorksheet('Ma première feuille de travail'); if (PEAR::isError($worksheet)) { die($worksheet->getMessage()); } $workbook->close(); ?> ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/close.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/close.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/close.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.close"> <refnamediv> <refname>Workbook::close</refname> <refpurpose>Appel les méthodes de finalisation d'un manuel de travail</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>void <function>Workbook::close</function></funcdef> <paramdef></paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.close.desc"> &title.desc; <para> Appel les méthodes de finalisation d'un manuel de travail. Cette méthode doit toujours être la dernière à être appelée pour tous les manuels de travail. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.close.return"> &title.returns; <para> Retourne &true; en cas de succès, une PEAR_Error en cas d'échec. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.close.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/setcustomcolor.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/setcustomcolor.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/setcustomcolor.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor"> <refnamediv> <refname>Workbook::setCustomColor</refname> <refpurpose>Modifie les composants RVB des éléments dans la palette des couleurs</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>integer <function>Workbook::setCustomColor</function></funcdef> <paramdef> integer <parameter>$index</parameter> </paramdef> <paramdef> integer <parameter>$red</parameter> </paramdef> <paramdef> integer <parameter>$green</parameter> </paramdef> <paramdef> integer <parameter>$blue</parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.desc"> &title.desc; <para> Modifie les composants RGB des éléments dans la palette des couleurs. La nouvelle couleur, définie par les composants RVB donnés, "écrasera" la couleur précédemment définie pour l'index donné. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>integer $index</parameter> - index de la couleur </para> </listitem> <listitem> <para> <parameter>integer $red</parameter> - valeur du rouge RVB [0-255] </para> </listitem> <listitem> <para> <parameter>integer $green</parameter> - valeur du vert RVB [0-255] </para> </listitem> <listitem> <para> <parameter>integer $blue</parameter> - valeur du bleu RVB [0-255] </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.return"> &title.returns; <para> <parameter>integer</parameter> - L'index de la palette pour la couleur personnalisée </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.example"> &title.example; <example> <title>Exemple avec <function>setCustomColor</function></title> <programlisting role="php"> <![CDATA[ require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); $worksheet =& $workbook->addWorksheet(); // vert "regulier" $format_regular_green =& $workbook->addFormat(); $format_regular_green->setFgColor('green'); // vert "spécial" $format_special_green =& $workbook->addFormat(); $format_special_green->setFgColor(11); // notre vert (écrasement de la couleur à l'index 12) $workbook->setCustomColor(12, 10, 200, 10); $format_our_green =& $workbook->addFormat(); $format_our_green->setFgColor(12); $worksheet->setColumn(0, 0, 30); $worksheet->write(0, 0, "Regular green", $format_regular_green); $worksheet->write(1, 0, "Special green (index 11)", $format_special_green); $worksheet->write(2, 0, "Our green", $format_our_green); $workbook->send('greens.xls'); $workbook->close(); ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/settempdir.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/settempdir.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/settempdir.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.3 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir"> <refnamediv> <refname>Workbook::&setTempDir</refname> <refpurpose>Définit le dossier temporaire à utiliser pour le fichier OLE</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>boolean<function>Workbook::&setTempDir</function></funcdef> <paramdef> string <parameter>$dir</parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.desc"> &title.desc; <para> Définit le dossier temporaire à utiliser pour le fichier OLE. Utilisez cette méthode si vous n'avez pas le droit d'écrire dans le dossier temporaire par défaut. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>string $dir</parameter> - Le dossier à utiliser en tant que dossier temporaire </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.return"> &title.returns; <para> <parameter>boolean</parameter> - &true; si le dossier fourni est valide, &false; sinon. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.example"> &title.example; <example> <title>Exemple avec <function>&setTempDir</function></title> <programlisting role="php"> <![CDATA[ <?php require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('test.xls'); $worksheet =& $workbook->addWorksheet('Ma première feuille de travail'); $workbook->setTempDir('/home/xnoguer/temp'); $worksheet->write(0, 0, "did this work?"); $workbook->close(); ?> ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 -->
http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/rowcoltocell.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/rowcoltocell.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/rowcoltocell.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.2 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell"> <refnamediv> <refname>Spreadsheet_Excel_Writer::rowcolToCell</refname> <refpurpose>Fonction pour l'écriture de formules</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>void <function>Spreadsheet_Excel_Writer::rowcolToCell</function></funcdef> <paramdef> integer <parameter>$row</parameter> </paramdef> <paramdef> integer <parameter>$col</parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell.desc"> &title.desc; <para> Fonction pour l'écriture de formules. Convertit les coordonnées d'une cellule en un format A1. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>integer $row</parameter> - Ligne de la cellule à convertir (indexé à partir de 0). </para> </listitem> <listitem> <para> <parameter>integer $col</parameter> - Colonne de la cellule à convertir (indexé à partir de 0). </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell.return"> &title.returns; <para> <emphasis>retour</emphasis> - L'identifiant de cellule dans un format A1 en cas de succès, une PEAR_Error en cas d'échec. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.rowcoltocell.example"> &title.example; <example> <title>Exemple avec <function>rowcolToCell</function></title> <programlisting role="php"> <![CDATA[ require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('rowcol.xls'); $worksheet1 =& $workbook->addWorksheet("rowcol"); $first = 1; $last = 10; for ($i = $first; $i <= $last; $i++) { $worksheet1->write($i, 1, $i); } $cell1 = Spreadsheet_Excel_Writer::rowcolToCell($first, 1); $cell2 = Spreadsheet_Excel_Writer::rowcolToCell($last, 1); $worksheet1->write($last + 1, 0, "Total ="); $worksheet1->writeFormula($last + 1, 1, "=SUM($cell1:$cell2)"); $workbook->close(); ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/send.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/send.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/send.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.3 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send"> <refnamediv> <refname>Spreadsheet_Excel_Writer::send</refname> <refpurpose>Envoi les en-têtes HTTP pour le fichier Excel</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>void <function>Spreadsheet_Excel_Writer::send</function></funcdef> <paramdef> string <parameter>$filename</parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send.desc"> &title.desc; <para> Envoi les en-têtes HTTP pour le fichier Excel. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>string $filename</parameter> - Le nom du fichier à utiliser pour les en-têtes HTTP. </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.send.example"> &title.example; <example> <title>Exemple avec <function>send</function></title> <programlisting role="php"> <![CDATA[ ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/spreadsheet-excel-writer.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/spreadsheet-excel-writer.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer/spreadsheet-excel-writer.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.3 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer"> <refnamediv> <refname>Spreadsheet_Excel_Writer::Spreadsheet_Excel_Writer</refname> <refpurpose>Le constructeur. Il crée juste un manuel de travail</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>object The <function>Spreadsheet_Excel_Writer::Spreadsheet_Excel_Writer</function></funcdef> <paramdef> string <parameter><optional>$filename=''</optional></parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.desc"> &title.desc; <para> Le constructeur. Il crée juste un manuel de travail. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>string $filename</parameter> - Le nom du fichier optionnel pour le manuel de travail. </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.return"> &title.returns; <para> Retourne l'objet créé représentant le manuel de travail. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer.spreadsheet-excel-writer.example"> &title.example; <example> <title>Exemple avec <function>Spreadsheet_Excel_Writer</function></title> <programlisting role="php"> <![CDATA[ ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addformat.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addformat.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addformat.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat"> <refnamediv> <refname>Workbook::&addFormat</refname> <refpurpose>Ajoute un nouveau format au manuel de travail Excel</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>object reference <function>Workbook::&addFormat</function></funcdef> <paramdef> array <parameter><optional>$properties=array()</optional></parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.desc"> &title.desc; <para> Ajoute un nouveau format au manuel de travail Excel. Passe également toutes les propriétés au constructeur du format. Les propriétés valides sont : </para> <para> <itemizedlist> <listitem> <para> Align </para> </listitem> <listitem> <para> Bold </para> </listitem> <listitem> <para> Bottom </para> </listitem> <listitem> <para> Top </para> </listitem> <listitem> <para> Left </para> </listitem> <listitem> <para> Right </para> </listitem> <listitem> <para> Border </para> </listitem> <listitem> <para> BorderColor </para> </listitem> <listitem> <para> BottomColor </para> </listitem> <listitem> <para> TopColor </para> </listitem> <listitem> <para> RightColor </para> </listitem> <listitem> <para> LeftColor </para> </listitem> <listitem> <para> FgColor </para> </listitem> <listitem> <para> BgColor </para> </listitem> <listitem> <para> Color </para> </listitem> <listitem> <para> Pattern </para> </listitem> <listitem> <para> Underline </para> </listitem> <listitem> <para> TextRotation </para> </listitem> <listitem> <para> Size </para> </listitem> <listitem> <para> NumFormat </para> </listitem> <listitem> <para> Script </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>array $properties</parameter> - tableau contenant les propriétés pour l'initialisation du format. </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.return"> &title.returns; <para> Retourne un objet de référence d'un format Excel. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addformat.example"> &title.example; <example> <title>Exemple avec <function>&addFormat</function></title> <programlisting role="php"> <![CDATA[ <?php require_once "Spreadsheet/Excel/Writer.php"; $workbook = new Spreadsheet_Excel_Writer(); $format =& $workbook->addFormat(array('Size' => 10, 'Align' => 'center', 'Color' => 'white', 'Pattern' => 1, 'FgColor' => 'magenta')); $worksheet =& $workbook->addWorksheet(); $worksheet->writeString(1, 0, "Bonjour en Magenta !", $format); $workbook->close(); ?> ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addworksheet.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addworksheet.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/addworksheet.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.6 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet"> <refnamediv> <refname>Workbook::&addWorksheet</refname> <refpurpose>Ajoute une nouvelle feuille de travail à un manuel de travail Excel</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>object reference <function>Workbook::&addWorksheet</function></funcdef> <paramdef> string <parameter><optional>$name=''</optional></parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.desc"> &title.desc; <para> Ajoute une nouvelle feuille de travail à un manuel de travail Excel. Si aucun nom n'est donné, le nom de la feuille de travail sera "Sheet<parameter>i</parameter>" avec <parameter>i</parameter> de [1..] à n. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>string $name</parameter> - le nom optionnel de la feuille de travail. Ne peut pas contenir plus de 31 caractères. </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.return"> &title.returns; <para> Retourne une référence à un objet de feuille de travail en cas de succès, une PEAR_Error en cas d'échec. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.addworksheet.example"> &title.example; <example> <title>Exemple avec <function>&addWorksheet</function></title> <programlisting role="php"> <![CDATA[ <?php require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('test.xls'); $worksheet =& $workbook->addWorksheet('Ma première feuille de travail'); if (PEAR::isError($worksheet)) { die($worksheet->getMessage()); } $workbook->close(); ?> ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/close.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/close.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/close.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.close"> <refnamediv> <refname>Workbook::close</refname> <refpurpose>Appel les méthodes de finalisation d'un manuel de travail</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>void <function>Workbook::close</function></funcdef> <paramdef></paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.close.desc"> &title.desc; <para> Appel les méthodes de finalisation d'un manuel de travail. Cette méthode doit toujours être la dernière à être appelée pour tous les manuels de travail. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.close.return"> &title.returns; <para> Retourne &true; en cas de succès, une PEAR_Error en cas d'échec. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.close.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/setcustomcolor.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/setcustomcolor.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/setcustomcolor.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor"> <refnamediv> <refname>Workbook::setCustomColor</refname> <refpurpose>Modifie les composants RVB des éléments dans la palette des couleurs</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>integer <function>Workbook::setCustomColor</function></funcdef> <paramdef> integer <parameter>$index</parameter> </paramdef> <paramdef> integer <parameter>$red</parameter> </paramdef> <paramdef> integer <parameter>$green</parameter> </paramdef> <paramdef> integer <parameter>$blue</parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.desc"> &title.desc; <para> Modifie les composants RGB des éléments dans la palette des couleurs. La nouvelle couleur, définie par les composants RVB donnés, "écrasera" la couleur précédemment définie pour l'index donné. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>integer $index</parameter> - index de la couleur </para> </listitem> <listitem> <para> <parameter>integer $red</parameter> - valeur du rouge RVB [0-255] </para> </listitem> <listitem> <para> <parameter>integer $green</parameter> - valeur du vert RVB [0-255] </para> </listitem> <listitem> <para> <parameter>integer $blue</parameter> - valeur du bleu RVB [0-255] </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.return"> &title.returns; <para> <parameter>integer</parameter> - L'index de la palette pour la couleur personnalisée </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.setcustomcolor.example"> &title.example; <example> <title>Exemple avec <function>setCustomColor</function></title> <programlisting role="php"> <![CDATA[ require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); $worksheet =& $workbook->addWorksheet(); // vert "regulier" $format_regular_green =& $workbook->addFormat(); $format_regular_green->setFgColor('green'); // vert "spécial" $format_special_green =& $workbook->addFormat(); $format_special_green->setFgColor(11); // notre vert (écrasement de la couleur à l'index 12) $workbook->setCustomColor(12, 10, 200, 10); $format_our_green =& $workbook->addFormat(); $format_our_green->setFgColor(12); $worksheet->setColumn(0, 0, 30); $worksheet->write(0, 0, "Regular green", $format_regular_green); $worksheet->write(1, 0, "Special green (index 11)", $format_special_green); $worksheet->write(2, 0, "Our green", $format_our_green); $workbook->send('greens.xls'); $workbook->close(); ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewcvs.cgi/peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/settempdir.xml?view=markup&rev=1.1 Index: peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/settempdir.xml +++ peardoc/fr/package/fileformats/spreadsheet-excel-writer/spreadsheet-excel-writer-workbook/settempdir.xml <?xml version="1.0" encoding="iso-8859-1" ?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.3 Maintainer: yannick Status: ready --> <refentry id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir"> <refnamediv> <refname>Workbook::&setTempDir</refname> <refpurpose>Définit le dossier temporaire à utiliser pour le fichier OLE</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcsynopsisinfo> require_once "Spreadsheet/Excel/Writer.php"; </funcsynopsisinfo> <funcprototype> <funcdef>boolean<function>Workbook::&setTempDir</function></funcdef> <paramdef> string <parameter>$dir</parameter> </paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.desc"> &title.desc; <para> Définit le dossier temporaire à utiliser pour le fichier OLE. Utilisez cette méthode si vous n'avez pas le droit d'écrire dans le dossier temporaire par défaut. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.parameter"> &title.param; <para> <itemizedlist> <listitem> <para> <parameter>string $dir</parameter> - Le dossier à utiliser en tant que dossier temporaire </para> </listitem> </itemizedlist> </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.return"> &title.returns; <para> <parameter>boolean</parameter> - &true; si le dossier fourni est valide, &false; sinon. </para> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.note"> &title.note; ¬e.notstatic; <simpara></simpara> </refsect1> <refsect1 id="package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-workbook.settempdir.example"> &title.example; <example> <title>Exemple avec <function>&setTempDir</function></title> <programlisting role="php"> <![CDATA[ <?php require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('test.xls'); $worksheet =& $workbook->addWorksheet('Ma première feuille de travail'); $workbook->setTempDir('/home/xnoguer/temp'); $worksheet->write(0, 0, "did this work?"); $workbook->close(); ?> ]]> </programlisting> </example> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 -->