如何使用带有WordPress插件快捷代码的phpspadsheet删除Excel下载中的html代码

i trying to make excel download in front page (not admin pages) with call own wordpress plugin shortcode

here is my excel download code :

<?php
    global $wpdb;
    $item = get_items( $_GET[\'id\'] );
    $product_info = $wpdb->get_row(\'SELECT * FROM \'.$wpdb->prefix.\'_table_product WHERE id="\'.$item->prd_id.\'"\', ARRAY_A);

    /* PhpSpreadsheet Load */
    require dirname( __FILE__ ).\'/phpspreadsheet/autoload.php\';

    use PhpOffice\\PhpSpreadsheet\\Spreadsheet;
    use PhpOffice\\PhpSpreadsheet\\Writer\\Xlsx;
    // use PhpOffice\\PhpSpreadsheet\\IOFactory;

    /* Settings
     * url : https://phpspreadsheet.readthedocs.io/en/develop/topics/recipes/#write-a-newline-character-n-in-a-cell-altenter
     */
    \\PhpOffice\\PhpSpreadsheet\\Cell\\Cell::setValueBinder( new \\PhpOffice\\PhpSpreadsheet\\Cell\\AdvancedValueBinder() );

    /* Get Template Excel */
    $template_file = dirname(__FILE__) . \'/template.xlsx\';

    $reader = new \\PhpOffice\\PhpSpreadsheet\\Reader\\Xlsx();
    $spreadsheet = $reader->load($template_file);

    /* Write Value Current Registration Form Data */
    ... some set value codes ...


    /* Save Excel and Download */
    $spreadsheet->getActiveSheet()->setTitle(\'registration\');
    $spreadsheet->setActiveSheetIndex(0);

    $reg_date = date(\'Ymd\', strtotime($item->reg_date));
    $filename = $reg_date.\'_\'.$item->user_name;

    ob_start();

    // Redirect output to a client’s web browser (Xlsx)
    header(\'Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\');
    header(\'Content-Disposition: attachment;filename="\'.$filename.\'.xlsx"\');
    header(\'Cache-Control: max-age=0\');
    // If you\'re serving to IE 9, then the following may be needed
//    header(\'Cache-Control: max-age=1\');

    $writer = new Xlsx($spreadsheet);
    ob_get_clean();
    $writer->save(\'php://output\');

?>

after download, and open file. but, didn\'t opened excel file with error messages like "it is not available excel type ..."

and open excel file using VSCODE excel files contents below :

<!DOCTYPE html>
<!--[if IE 9 ]><html lang="ko-KR" prefix="og: http://ogp.me/ns# fb: http://ogp.me/ns/fb#" class="no-js ie ie9"> <![endif]-->
<!--[if IE 10 ]><html lang="ko-KR" prefix="og: http://ogp.me/ns# fb: http://ogp.me/ns/fb#" class="no-js ie ie10"> <![endif]-->
<!--[if (gte IE 11)|!(IE)]><!--><html lang="ko-KR" prefix="og: http://ogp.me/ns# fb: http://ogp.me/ns/fb#" class="no-js"><!--<![endif]-->
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="naver-site-verification" content="dfc8906033b9ecd79b0a715f6e12e05589e78947"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

    <meta name="description" content="">
    <link rel="profile" href="http://gmpg.org/xfn/11">
    <link rel="pingback" href="https://test.com/xmlrpc.php">
    <link rel="stylesheet" href="https://test.com/wp-content/themes/testtheme/style.css">

    <title>TITLE</title>
...
▼ MORE Header Code
...

▼ BINARY CODE (it seems excel code) 
                PK

phpspreadsheet v1.6.0 (i guess)

anybody had this issues? and solving?

error page is this

please help, experts. thanks.

是否可以使用unctions.php将文本插入到html标记中？

我的意思是：我正在使用一个名为“pods”的插件，它允许创建自定义（CPT）并在这些CPT之间建立关系。然而，我可以看到一个小小的缺陷，我为美国各州创建了一个CPT，所以每个CPT都是一个单独的州，这意味着在这个CPT中创建的每个帖子都有州的标题。下面是HTML和相关CSS<header class=\"entry-header clr\"> <h2 class=\"single-post-title entry-title\" itemprop=\"headline\"

相关推荐

是否可以使用unctions.php将文本插入到html标记中？