如何在PHPExcel中选择特定的列顺序 - how to select specific column order in PHPExcel

how to select specific column order in PHPExcel

本文关键字：顺序选择 PHPExcel | 更新日期: 2023-09-27

我想选择和写入特定的列名，因为我想怎么做?情况是:

$stockQuery = mysql_query("SELECT stokId,urunAdi,tlFiyat,stokMiktari,tlFiyat*stokMiktari,urunGrup,maliyetTipi FROM proje_stok where projeID =".$projeID);

但是我想选择像

select * from proje_stok where ......

和我现在写的代码是

while($row_data = mysql_fetch_assoc($stockQuery)) {
$col = 0;
if ($col == 0) {
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $order);
    $col++;
}
foreach($row_data as $key=>$value) {
   $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
   $col++;
}
$row++;
$order++;
}

我想用

这样的代码来代替它

foreach($row_data as $key=>$value) {
   $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value['HEREWHATIWANTTOPUTCOLUMNNAME']);
   $col++;
}

有什么建议可以处理吗?

对

$col = $row = $order = 1;
if ($row_data = mysql_fetch_assoc($stockQuery))
{
    foreach ($row_data as $key => $value)
       $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(++$col, $row, $key);
    do
    {
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col = 1, ++$row, $order++);
        foreach ($row_data as $value)
           $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(++$col, $row, $value);
    }
    while ($row_data = mysql_fetch_assoc($stockQuery));
}