8-5-2 插入表格到word中

您沒有觀看影片的權限

請先登入，登入後，確認您的權限後，即可觀看影片。

1. 表格常用樣式設定

   // 表格樣式設定
   $tableStyle = ['borderColor' => '000000', 'borderSize' => 6, 'cellMargin' => 80];
   // 橫列樣式
   $rowStyle = ['cantSplit' => true, 'tblHeader' => true];
   // 儲存格標題文字樣式設定
   $headStyle = ['bold' => true];
   // 儲存格內文文字樣式設定
   $cellStyle = ['valign' => 'center'];

    

2. 建立表格

   $table = $section->addTable($tableStyle);

    

3. 建立一個橫列（參數均可省略）

   $table->addRow($height, $rowStyle);

    

4. 建立儲存格

   $table->addCell($width, $cellStyle)->addText('內容', $fontStyle, $paraStyle);

    

5. 合併儲存格（套用不同儲存格樣式即可達成）

   $cellRowSpan  = array('vMerge' => 'restart'); //垂直合併
   $cellContinue = array('vMerge' => 'continue'); //略過
   $cellColSpan  = array('gridSpan' => 2); //水平合併

    

6. 完成 word_signup.php 如：

   <?php
   use PhpOffice\PhpWord\IOFactory;
   use PhpOffice\PhpWord\PhpWord;
   use PhpOffice\PhpWord\Shared\Converter;
   use Xmf\Request;
   use XoopsModules\Tadtools\TadDataCenter;
   use XoopsModules\Tad_signup\Tad_signup_actions;
   use XoopsModules\Tad_signup\Tad_signup_data;
   /*-----------引入檔案區--------------*/
   require_once __DIR__ . '/header.php';
   
   if (!$_SESSION['can_add']) {
       redirect_header($_SERVER['PHP_SELF'], 3, "您沒有權限使用此功能");
   }
   
   $id = Request::getInt('id');
   $action = Tad_signup_actions::get($id);
   
   require_once XOOPS_ROOT_PATH . '/modules/tadtools/vendor/autoload.php';
   $phpWord = new PhpWord();
   $phpWord->setDefaultFontName('標楷體'); //設定預設字型
   $phpWord->setDefaultFontSize(12); //設定預設字型大小
   // $header = $section->addHeader(); //頁首
   // $footer = $section->addFooter(); //頁尾
   // $footer->addPreserveText('{PAGE} / {NUMPAGES}', $fontStyle, $paraStyle);
   
   // 標題文字樣式設定
   $Title1Style = ['color' => '000000', 'size' => 18, 'bold' => true];
   $Title2Style = ['color' => '000000', 'size' => 16, 'bold' => true];
   // 內文文字設定
   $fontStyle = ['color' => '000000', 'size' => 14, 'bold' => false];
   // 置中段落樣式設定
   $paraStyle = ['align' => 'center', 'valign' => 'center'];
   // 靠左段落樣式設定
   $left_paraStyle = ['align' => 'left', 'valign' => 'center'];
   // 靠右段落樣式設定
   $right_paraStyle = ['align' => 'right', 'valign' => 'center'];
   // 表格樣式設定
   $tableStyle = ['borderColor' => '000000', 'borderSize' => 6, 'cellMargin' => 80];
   // 橫列樣式
   $rowStyle = ['cantSplit' => true, 'tblHeader' => true];
   // 儲存格標題文字樣式設定
   $headStyle = ['bold' => true];
   // 儲存格內文段落樣式設定
   $cellStyle = ['valign' => 'center'];
   
   $phpWord->addTitleStyle(1, $Title1Style, $paraStyle); //設定標題1樣式
   $phpWord->addTitleStyle(2, $Title2Style, $paraStyle); //設定標題1樣式
   
   //產生內容
   $section = $phpWord->addSection();
   $sectionStyle = $section->getStyle();
   $sectionStyle->setMarginTop(Converter::cmToTwip(2.5));
   $sectionStyle->setMarginLeft(Converter::cmToTwip(2.2));
   $sectionStyle->setMarginRight(Converter::cmToTwip(2.2));
   
   $title = "{$action['title']}簽到表";
   
   $section->addTitle($title, 1); //新增標題
   $section->addTextBreak(1);
   $section->addText("活動日期：{$action['action_date']}", $fontStyle, $left_paraStyle);
   $section->addTextBreak(1);
   
   $TadDataCenter = new TadDataCenter('tad_signup');
   $TadDataCenter->set_col('pdf_setup_id', $id);
   $pdf_setup_col = $TadDataCenter->getData('pdf_setup_col', 0);
   $col_arr = explode(',', $pdf_setup_col);
   $col_count = count($col_arr);
   if (empty($col_count)) {
       $col_count = 1;
   }
   
   $w = 10.6 / $col_count;
   
   $table = $section->addTable($tableStyle);
   $table->addRow();
   $table->addCell(Converter::cmToTwip(1.5), $cellStyle)->addText('編號', $fontStyle, $paraStyle);
   foreach ($col_arr as $col_name) {
       $table->addCell(Converter::cmToTwip($w), $cellStyle)->addText($col_name, $fontStyle, $paraStyle);
   }
   $table->addCell(Converter::cmToTwip(4.5), $cellStyle)->addText('簽名', $fontStyle, $paraStyle);
   
   $signup = Tad_signup_data::get_all($action['id'], null, true, true);
   $i = 1;
   foreach ($signup as $signup_data) {
       $table->addRow();
       $table->addCell(Converter::cmToTwip(1.5), $cellStyle)->addText($i, $fontStyle, $paraStyle);
       foreach ($col_arr as $col_name) {
           $table->addCell(Converter::cmToTwip($w), $cellStyle)->addText(implode('、', $signup_data['tdc'][$col_name]), $fontStyle, $paraStyle);
       }
   
       $table->addCell(Converter::cmToTwip(4.5), $cellStyle)->addText('', $fontStyle, $paraStyle);
       $i++;
   }
   
   $objWriter = IOFactory::createWriter($phpWord, 'Word2007');
   header('Content-Type: application/vnd.ms-word');
   header("Content-Disposition: attachment;filename={$title}.docx");
   header('Cache-Control: max-age=0');
   $objWriter->save('php://output');
   

    

link to https://github.com/tadlearn/tad_signup/commit/5257b1d9e2870da77abefd7a9f35d9903be04624 \