我正在使用 PHPExcel 从 MYSQL 数据库导出数据并将其导入到 Excel 文件中。
我有一个如下所示的数据库(这也是我使用 PHPExcel 生成 Excel 文件时当前的样子):
======================================================
| Question | Answer |
=========+===========+===============================|
| Do you listen to music? | YES |
|----------------------------------------------------|
| Who is your favorite music artists? | Justin Beiber|
|----------------------------------------------------|
| <p> Select an Answer<p> | |
|----------------------------------------------------|
|Are you a Male or female | M |
|----------------------------------------------------|
我希望我的 Excel 文件如下所示:
======================================================
| Question | Answer |
=========+===========+===============================|
| Do you listen to music? | YES |
|----------------------------------------------------|
| Who is your favorite music artists? | Justin Beiber|
|----------------------------------------------------|
|Are you a Male or female | M |
|----------------------------------------------------|
我正在使用这段代码:
$objPHPExcel = new PHPExcel();
$col = 1;
while($row_data = mysql_fetch_assoc($result)) {
$row = 1;
if ($col == 1) {
$row_headings = array_keys($row_data);
foreach($row_headings as $value) {
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
$row++;
}
$row = 1;
$col++;
}
foreach($row_data as $value) {
if (!strstr('<p>', $value)){
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
$row++;
}
}
$col++;
}
一种选择是排除<p> Select an Answer<p>
当执行 SQL 查询时,您将选择您的列和行,然后从您的选择中您可以DELETE WHERE question = "<p> Select an Answer<p> "
或者如果列Anwser
值为null
or ""
when Question
值为<p> Select an Answer<p>
,那么你也可以说:
if($value !== null)
{
// Output...
}
在示例中:
$objPHPExcel = new PHPExcel();
$col = 1;
while($row_data = mysql_fetch_assoc($result)) {
$row = 1;
if ($col == 1) {
$row_headings = array_keys($row_data);
foreach($row_headings as $value) {
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
$row++;
}
$row = 1;
$col++;
}
foreach($row_data as $value) {
if($value !== null || $value !== '')
{
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
$row++;
}
}
$col++;
}
或者您可以简单地删除包含以下内容的行<p> Select an Answer<p>
除非你需要它们。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)