- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我正在尝试在单击按钮后生成 excel 文件。我把它做成表格:
<form method="post" action="ExcelStudio.php" target="_blank" style="float:right;">
<input type="submit" name="export_excel_studio" class="button" value="Studio Report"></input>
</form>
因此在提交表单后我继续生成 excel 文件:
<?php
require_once ('PHPExcel/Classes/PHPExcel.php');
header('Content-Type: text/html; charset=utf-8');
include('inc/database_connection.php');
$conn = mysqli_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD, DATABASE_NAME);
$output = '';
$conn->set_charset('utf8_unicode_ci');//if not by default
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
$F = $objPHPExcel->getActiveSheet();
if(isset($_POST["export_excel_studio"]))
{
// 1.Get data
$sql2 = '
select
p2.proc_leader as username,
max(case when studio = "APEX" then "x" else "" end) as APEX,
max(case when studio = "BASECAMP" then "x" else "" end) as BASECAMP,
max(case when studio = "CANVAS" then "x" else "" end) as CANVAS,
max(case when studio = "HORIZON" then "x" else "" end) as HORIZON,
max(case when studio = "LAUNCHPAD" then "x" else "" end) as LAUNCHPAD,
max(case when studio = "NEBULA" then "x" else "" end) as NEBULA,
max(case when studio = "ORBIT" then "x" else "" end) as ORBIT,
max(case when studio = "PALETTE" then "x" else "" end) as PALETTE,
max(case when studio = "SANDBOX" then "x" else "" end) as SANDBOX,
max(case when studio = "STELLAR" then "x" else "" end) as STELLAR,
max(case when studio = "THE CLIMB" then "x" else "" end) as THECLIMB,
max(case when studio = "TOONIGAMI" then "x" else "" end) as TOONIGAMI,
max(case when studio = "TREEHOUSE" then "x" else "" end) as TREEHOUSE
from process p1
left join (
select *
from proc_leader
union all
select *
from proc_checker
union all
select *
from proc_staff
) p2 on p1.projectNo = p2.projectNo
and p1.process = p2.process
group by p2.proc_leader
';
// 2. Output table
$query2 = mysqli_query($conn, $sql2);
$header = '<th style="border: 1px solid black;">Username</th>
<th style="border: 1px solid black;">Studio APEX</th>
<th style="border: 1px solid black;">Studio BASECAMP</th>
<th style="border: 1px solid black;">Studio CANVAS</th>
<th style="border: 1px solid black;">Studio HORIZON</th>
<th style="border: 1px solid black;">Studio LAUNCHPAD</th>
<th style="border: 1px solid black;">Studio NEBULA</th>
<th style="border: 1px solid black;">Studio ORBIT</th>
<th style="border: 1px solid black;">Studio PALETTE</th>
<th style="border: 1px solid black;">Studio SANDBOX</th>
<th style="border: 1px solid black;">Studio STELLAR</th>
<th style="border: 1px solid black;">Studio THECLIMB</th>
<th style="border: 1px solid black;">Studio TOONIGAMI</th>
<th style="border: 1px solid black;">Studio TREEHOUSE</th>';
$body = '';
while ($data2 = mysqli_fetch_assoc($query2)) {
$username = $data2['username'];
$apex = $data2['APEX'];
$basecamp = $data2['BASECAMP'];
$canvas = $data2['CANVAS'];
$horizon = $data2['HORIZON'];
$launchpad = $data2['LAUNCHPAD'];
$nebula = $data2['NEBULA'];
$orbit = $data2['ORBIT'];
$palette = $data2['PALETTE'];
$sandbox = $data2['SANDBOX'];
$stellar = $data2['STELLAR'];
$theclimb = $data2['THECLIMB'];
$toonigame = $data2['TOONIGAMI'];
$treehouse = $data2['TREEHOUSE'];
$row = '<td style="border: 1px solid black;">' . htmlspecialchars($username) . '</td>
<td style="border: 1px solid black;">' . $apex . '</td>
<td style="border: 1px solid black;">' . $basecamp . '</td>
<td style="border: 1px solid black;">' . $canvas . '</td>
<td style="border: 1px solid black;">' . $horizon . '</td>
<td style="border: 1px solid black;">' . $launchpad . '</td>
<td style="border: 1px solid black;">' . $nebula . '</td>
<td style="border: 1px solid black;">' . $orbit . '</td>
<td style="border: 1px solid black;">' . $palette . '</td>
<td style="border: 1px solid black;">' . $sandbox . '</td>
<td style="border: 1px solid black;">' . $stellar . '</td>
<td style="border: 1px solid black;">' . $theclimb . '</td>
<td style="border: 1px solid black;">' . $toonigame . '</td>
<td style="border: 1px solid black;">' . $treehouse . '</td>';
$body .= "<tr style='border: 1px solid black;'>$row</tr>";
}
$output .= "
<table class='table' style='border: 1px solid black;'>
<thead><tr>$header</tr></thead>
<tbody>$body</tbody>
</table>
";
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="StudioReport.xls"');
header('Cache-Control: max-age=0');
echo $output;
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
}
它工作正常,除了一件事,我在表格后得到了奇怪的符号。所以我认为这意味着某处有问题。这是我打开 excel 文件后得到的 .可能是什么问题,我该如何解决?谢谢
最佳答案
通过更改文件让它工作:
header( "Content-Type: application/vnd.ms-excel" );
header( "Content-disposition: attachment; filename=StudioReport.xls" );
include('inc/database_connection.php');
$conn = mysqli_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD, DATABASE_NAME);
$output = '';
$conn->set_charset('utf8_unicode_ci');//if not by default
// print your data here. note the following:
// - cells/columns are separated by tabs ("\t")
// - rows are separated by newlines ("\n")
if(isset($_POST["export_excel_studio"]))
{
// 1.Get data
$sql2 = '
select
p2.proc_leader as username,
max(case when studio = "APEX" then "x" else "" end) as APEX,
max(case when studio = "BASECAMP" then "x" else "" end) as BASECAMP,
max(case when studio = "CANVAS" then "x" else "" end) as CANVAS,
max(case when studio = "HORIZON" then "x" else "" end) as HORIZON,
max(case when studio = "LAUNCHPAD" then "x" else "" end) as LAUNCHPAD,
max(case when studio = "NEBULA" then "x" else "" end) as NEBULA,
max(case when studio = "ORBIT" then "x" else "" end) as ORBIT,
max(case when studio = "PALETTE" then "x" else "" end) as PALETTE,
max(case when studio = "SANDBOX" then "x" else "" end) as SANDBOX,
max(case when studio = "STELLAR" then "x" else "" end) as STELLAR,
max(case when studio = "THE CLIMB" then "x" else "" end) as THECLIMB,
max(case when studio = "TOONIGAMI" then "x" else "" end) as TOONIGAMI,
max(case when studio = "TREEHOUSE" then "x" else "" end) as TREEHOUSE
from process p1
left join (
select *
from proc_leader
union all
select *
from proc_checker
union all
select *
from proc_staff
) p2 on p1.projectNo = p2.projectNo
and p1.process = p2.process
group by p2.proc_leader
';
// 2. Output table
$query2 = mysqli_query($conn, $sql2);
$header = '<th style="border: 1px solid black;">Username</th>
<th style="border: 1px solid black;">Studio APEX</th>
<th style="border: 1px solid black;">Studio BASECAMP</th>
<th style="border: 1px solid black;">Studio CANVAS</th>
<th style="border: 1px solid black;">Studio HORIZON</th>
<th style="border: 1px solid black;">Studio LAUNCHPAD</th>
<th style="border: 1px solid black;">Studio NEBULA</th>
<th style="border: 1px solid black;">Studio ORBIT</th>
<th style="border: 1px solid black;">Studio PALETTE</th>
<th style="border: 1px solid black;">Studio SANDBOX</th>
<th style="border: 1px solid black;">Studio STELLAR</th>
<th style="border: 1px solid black;">Studio THECLIMB</th>
<th style="border: 1px solid black;">Studio TOONIGAMI</th>
<th style="border: 1px solid black;">Studio TREEHOUSE</th>';
$body = '';
while ($data2 = mysqli_fetch_assoc($query2)) {
$username = $data2['username'];
$apex = $data2['APEX'];
$basecamp = $data2['BASECAMP'];
$canvas = $data2['CANVAS'];
$horizon = $data2['HORIZON'];
$launchpad = $data2['LAUNCHPAD'];
$nebula = $data2['NEBULA'];
$orbit = $data2['ORBIT'];
$palette = $data2['PALETTE'];
$sandbox = $data2['SANDBOX'];
$stellar = $data2['STELLAR'];
$theclimb = $data2['THECLIMB'];
$toonigame = $data2['TOONIGAMI'];
$treehouse = $data2['TREEHOUSE'];
$row = '<td style="border: 1px solid black;">' . htmlspecialchars($username) . '</td>
<td style="border: 1px solid black;">' . $apex . '</td>
<td style="border: 1px solid black;">' . $basecamp . '</td>
<td style="border: 1px solid black;">' . $canvas . '</td>
<td style="border: 1px solid black;">' . $horizon . '</td>
<td style="border: 1px solid black;">' . $launchpad . '</td>
<td style="border: 1px solid black;">' . $nebula . '</td>
<td style="border: 1px solid black;">' . $orbit . '</td>
<td style="border: 1px solid black;">' . $palette . '</td>
<td style="border: 1px solid black;">' . $sandbox . '</td>
<td style="border: 1px solid black;">' . $stellar . '</td>
<td style="border: 1px solid black;">' . $theclimb . '</td>
<td style="border: 1px solid black;">' . $toonigame . '</td>
<td style="border: 1px solid black;">' . $treehouse . '</td>';
$body .= "<tr style='border: 1px solid black;'>$row</tr>";
}
$output .= "
<table class='table' style='border: 1px solid black;'>
<thead><tr>$header</tr></thead>
<tbody>$body</tbody>
</table>
";
echo $output;
}
关于php - 从 html 表生成 excel 文件后的奇怪符号,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/41755897/
给定一个字符串,例如 s="##$$$#",我如何找到索引之前的“#”符号数等于“”数的索引$"符号在索引之后? 示例:如果 s="##$$$#",则输出将为 2。 解释:在索引 2 之前我们有 2
在本教程中,您将借助示例了解 JavaScript 符号。 JavaScript 符号 JavaScript ES6 引入了一种新的原始数据类型,称为 Symbol(符号)。符号是不可变的(不能更改)
在“函数编程的工艺”一书中,符号 '>.>' 将函数连接在一起,与 '.' 的方向相反。但是当我使用 ghci 实现它时,它显示了超出范围的错误 '>.>'。为什么?它是不再使用的旧符号吗? 最佳答案
很难说出这里问的是什么。这个问题是含糊的、模糊的、不完整的、过于宽泛的或修辞性的,无法以目前的形式得到合理的回答。如需帮助澄清此问题以便重新打开它,visit the help center 。 已关
我需要从向量中删除 \"。这是我的数据: data <- c("\"https://click.linksynergy.com/link?id=RUxZriH*PWc&offerid=323058.1
我在 Nginx 配置中使用正则表达式来捕获文件 URL,但如果文件 URL 包含 # 符号,正则表达式模式将不会捕获它。 这里是nginx的配置部分。 location ~ ^/p/(?[\w\-=
如何使 & 符号在此图表的第一组条形/列下正确显示: http://jsfiddle.net/VxbrK/2/ 应该是“Apples & Oranges”而不是“Apples & Oranges”。
**在verilog中是什么意思? 我为测试台提供了以下逻辑 localparam NUM_INPUT_BITS = 1; localparam NUM_OUTPUT_BITS
我有一个使用正则表达式来验证电子邮件地址的方法。 public String searchFormail(String searchWord) { Pattern pattern = Patt
我想将一个字符串拆分为数字部分和文本/符号部分我当前的代码不包含负数或小数,并且表现得很奇怪,在输出的末尾添加了一个空列表元素 import re mystring = 'AD%5(6ag 0.33-
我有一些代码需要从数组中选择一个随机字符串,但它一直返回单个字母或数字。如何解决这个问题? var name = ["Yayek", "Vozarut", "Gezex",
我刚开始使用 Python,我在考虑应该使用哪种表示法。我读过 PEP 8关于 Python 符号的指南,我同意那里的大多数内容,除了函数名称(我更喜欢混合大小写风格)。 在 C++ 中,我使用匈牙利
在用 C# 编写代码时,我错误地在 if 语句中的变量前添加了一个符号(而不是感叹号)。 bool b = false; if (@b) { } 我很惊讶它编译成功,没有任何错误。 我想知道:上面的代
本文实例为大家分享了特殊字符替换电话号码中某一部分的方法,ios利用-号替换电话号码中间四位,供大家参考,具体内容如下 1、效果图 2、代码 rootviewcontroll
当我使用“x”和“z”作为符号时,这段代码没有问题: from sympy import * x, z = symbols('x z') y = -6*x**2 + 2*x*z**0.5 + 50*x
我需要从文本中删除标点符号: data <- "Type the command AT&W enter. in order to save the new protocol on modem;"
我有几个数字是 numeric 类。下面的例子。 df = c(12974,12412,124124,124124,34543,4576547,32235) 现在我想在每个数字前添加 '$' 符号而不
我有一个 highcharts 图例,其中符号以不同的大小显示,因为它们在实际图表中的大小不同。不幸的是,当数据点的大小增加时,它们也会在图例中增加。无论数据点大小如何,我都希望图例符号保持相同的大小
我需要使用包含平均值+-SD的标题。到目前为止,我只能得到以下信息: "Mean +- SD or N (%)" [1] "Mean +- SD or N (%)" 如何直接使用“+-”符号?您知道一
使用 XSLT 和 XPath 1.0,我有一个要转义的字符串以用于 URL,例如: one word & another 因此,描述元素的 text() 应该进行 URL 转义。 我该怎么做
我是一名优秀的程序员,十分优秀!