[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-doc-cvs
Subject:    [DOC-CVS] [doc-en] master: Fix xlswriter examples (#3294)
From:       Luffy via GitHub <noreply () php ! net>
Date:       2024-03-30 3:50:45
Message-ID: 4DDGSokg9Ozn9VyiZ3miUrktqrSEtguUMwE1QTzM0 () main ! php ! net
[Download RAW message or body]

Author: Luffy (sy-records)
Committer: GitHub (web-flow)
Pusher: sy-records
Date: 2024-03-30T11:50:40+08:00

Commit: https://github.com/php/doc-en/commit/547a556ea0ffcae65a07fba5eac97f6f5c4faf2c
Raw diff: https://github.com/php/doc-en/commit/547a556ea0ffcae65a07fba5eac97f6f5c4faf2c.diff


Fix xlswriter examples (#3294)

Changed paths:
  M  reference/xlswriter/xlsx-format/align.xml
  M  reference/xlswriter/xlsx-format/bold.xml
  M  reference/xlswriter/xlsx-format/italic.xml
  M  reference/xlswriter/xlsx-format/underline.xml
  M  reference/xlswriter/xlsx-kernel/set-column.xml
  M  reference/xlswriter/xlsx-kernel/set-row.xml


Diff:

diff --git a/reference/xlswriter/xlsx-format/align.xml \
b/reference/xlswriter/xlsx-format/align.xml index da4920e81246..e8bcc69e9525 100644
--- a/reference/xlswriter/xlsx-format/align.xml
+++ b/reference/xlswriter/xlsx-format/align.xml
@@ -51,7 +51,7 @@
  <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>example</title>
+   <title>Align style example</title>
    <programlisting role="php">
 <![CDATA[
 <?php
@@ -59,16 +59,15 @@ $config = [
     'path' => './tests'
 ];
 
-$excel  = new \Vtiful\Kernel\Excel($config);
+$excel = new \Vtiful\Kernel\Excel($config);
+$excel->fileName('tutorial01.xlsx');
 
-$fileObject = $excel->fileName('tutorial01.xlsx');
-$fileHandle = $fileObject->getHandle();
+$format = new \Vtiful\Kernel\Format($excel->getHandle());
+$alignStyle = $format->align(\Vtiful\Kernel\Format::FORMAT_ALIGN_LEFT)->toResource();
  
-$alignStyle = \Vtiful\Kernel\Format::align($fileHandle, \
                \Vtiful\Kernel\Format::FORMAT_ALIGN_LEFT);
-
-$fileObject->header(['name', 'age'])
+$excel->header(['name', 'age'])
     ->data([['viest', 21]])
-    ->setColumn('A:A', 200, $align)
+    ->setColumn('A:A', 200, $alignStyle)
     ->output();
 ?>
 ]]>
diff --git a/reference/xlswriter/xlsx-format/bold.xml \
b/reference/xlswriter/xlsx-format/bold.xml index 7f492d114b53..de42ce604147 100644
--- a/reference/xlswriter/xlsx-format/bold.xml
+++ b/reference/xlswriter/xlsx-format/bold.xml
@@ -42,7 +42,7 @@
  <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>example</title>
+   <title>Bold style example</title>
    <programlisting role="php">
 <![CDATA[
 <?php
@@ -50,14 +50,13 @@ $config = [
     'path' => './tests'
 ];
 
-$excel  = new \Vtiful\Kernel\Excel($config);
+$excel = new \Vtiful\Kernel\Excel($config);
+$excel->fileName('tutorial01.xlsx');
 
-$fileObject = $excel->fileName('tutorial01.xlsx');
-$fileHandle = $fileObject->getHandle();
+$format = new \Vtiful\Kernel\Format($excel->getHandle());
+$boldStyle = $format->bold()->toResource();
 
-$boldStyle = \Vtiful\Kernel\Format::bold($fileHandle);
-
-$fileObject->header(['name', 'age'])
+$excel->header(['name', 'age'])
     ->data([['viest', 21]])
     ->setColumn('A:A', 200, $boldStyle)
     ->output();
diff --git a/reference/xlswriter/xlsx-format/italic.xml \
b/reference/xlswriter/xlsx-format/italic.xml index f6feba88bfea..2d7dd07ca84b 100644
--- a/reference/xlswriter/xlsx-format/italic.xml
+++ b/reference/xlswriter/xlsx-format/italic.xml
@@ -42,7 +42,7 @@
  <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>example</title>
+   <title>Italic style example</title>
    <programlisting role="php">
 <![CDATA[
 <?php
@@ -50,14 +50,13 @@ $config = [
     'path' => './tests'
 ];
 
-$excel  = new \Vtiful\Kernel\Excel($config);
+$excel = new \Vtiful\Kernel\Excel($config);
+$excel->fileName('tutorial01.xlsx');
 
-$fileObject = $excel->fileName('tutorial01.xlsx');
-$fileHandle = $fileObject->getHandle();
+$format = new \Vtiful\Kernel\Format($excel->getHandle());
+$italicStyle = $format->italic()->toResource();
 
-$italicStyle = \Vtiful\Kernel\Format::italic($fileHandle);
-
-$fileObject->header(['name', 'age'])
+$excel->header(['name', 'age'])
     ->data([['viest', 21]])
     ->setColumn('A:A', 200, $italicStyle)
     ->output();
diff --git a/reference/xlswriter/xlsx-format/underline.xml \
b/reference/xlswriter/xlsx-format/underline.xml index 37f30354e9c0..c2be0fa9d1b6 \
                100644
--- a/reference/xlswriter/xlsx-format/underline.xml
+++ b/reference/xlswriter/xlsx-format/underline.xml
@@ -51,7 +51,7 @@
  <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>example</title>
+   <title>Underline style example</title>
    <programlisting role="php">
 <![CDATA[
 <?php
@@ -59,14 +59,13 @@ $config = [
     'path' => './tests'
 ];
 
-$excel  = new \Vtiful\Kernel\Excel($config);
+$excel = new \Vtiful\Kernel\Excel($config);
+$excel->fileName('tutorial01.xlsx');
 
-$fileObject = $excel->fileName('tutorial01.xlsx');
-$fileHandle = $fileObject->getHandle();
+$format = new \Vtiful\Kernel\Format($excel->getHandle());
+$underlineStyle = $format->underline(\Vtiful\Kernel\Format::UNDERLINE_SINGLE)->toResource();
  
-$underlineStyle = \Vtiful\Kernel\Format::underline($fileHandle, \
                \Vtiful\Kernel\Format::UNDERLINE_SINGLE);
-
-$fileObject->header(['name', 'age'])
+$excel->header(['name', 'age'])
     ->data([['viest', 21]])
     ->setColumn('A:A', 200, $underlineStyle)
     ->output();
diff --git a/reference/xlswriter/xlsx-kernel/set-column.xml \
b/reference/xlswriter/xlsx-kernel/set-column.xml index 5c6d48a85d17..a870f8fd9f2e \
                100644
--- a/reference/xlswriter/xlsx-kernel/set-column.xml
+++ b/reference/xlswriter/xlsx-kernel/set-column.xml
@@ -60,7 +60,7 @@
 <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>example</title>
+   <title>setColumn example</title>
    <programlisting role="php">
 <![CDATA[
 <?php
@@ -68,14 +68,13 @@ $config = [
     'path' => './tests'
 ];
 
-$excel  = new \Vtiful\Kernel\Excel($config);
+$excel = new \Vtiful\Kernel\Excel($config);
+$excel->fileName('tutorial01.xlsx');
 
-$fileObject = $excel->fileName('tutorial01.xlsx');
-$fileHandle = $fileObject->getHandle();
+$format = new \Vtiful\Kernel\Format($excel->getHandle());
+$boldStyle = $format->bold()->toResource();
 
-$boldStyle = \Vtiful\Kernel\Format::bold($fileHandle);
-
-$fileObject->header(['name', 'age'])
+$excel->header(['name', 'age'])
     ->data([['viest', 21]])
     ->setColumn('A:A', 200, $boldStyle)
     ->output();
diff --git a/reference/xlswriter/xlsx-kernel/set-row.xml \
b/reference/xlswriter/xlsx-kernel/set-row.xml index 78ed1632a58e..0bdd4e9ae99c 100644
--- a/reference/xlswriter/xlsx-kernel/set-row.xml
+++ b/reference/xlswriter/xlsx-kernel/set-row.xml
@@ -60,7 +60,7 @@
 <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>example</title>
+   <title>setRow example</title>
    <programlisting role="php">
 <![CDATA[
 <?php
@@ -68,16 +68,15 @@ $config = [
     'path' => './tests'
 ];
 
-$excel  = new \Vtiful\Kernel\Excel($config);
+$excel = new \Vtiful\Kernel\Excel($config);
+$excel->fileName('tutorial01.xlsx');
 
-$fileObject = $excel->fileName('tutorial01.xlsx');
-$fileHandle = $fileObject->getHandle();
+$format = new \Vtiful\Kernel\Format($excel->getHandle());
+$boldStyle = $format->bold()->toResource();
 
-$boldStyle = \Vtiful\Kernel\Format::bold($fileHandle);
-
-$fileObject->header(['name', 'age'])
+$excel->header(['name', 'age'])
     ->data([['viest', 21]])
-    ->setRow('A1', 20, $boldStyle,)
+    ->setRow('A1', 20, $boldStyle)
     ->output();
 ]]>
    </programlisting>


[prev in list] [next in list] [prev in thread] [next in thread]