PHPExcel如何动态设置单元格值 [英] PHPExcel how to set cell value dynamically

问题描述

如何使用PHPExcel库动态设置单元格/列的值?

How to set cell/column value dynamically using PHPExcel library?

我正在从MySQL数据库中获取结果集，我想使用PHPExcel库以excel格式写入数据.查看示例

I am fetching result set from MySQL database and I want to write data in excel format using PHPExcel library. Looking at example

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'cell value here');

表示我们必须将单元格/列引用硬编码为'A1'，然后将其写入单元格/列A1.如何根据结果集中的行和相应的列值增加单元格/列和/或行引用?

indicates that we have to hard code cell/column reference As 'A1', then it writes to cell/column A1. How I can increment cell/column and/or row reference based on rows and corresponding column values from result set?

请指导.

推荐答案

我假设您已经连接到数据库.

I asume you have connected to your database already.

$sql = "SELECT * FROM my_table";
$result = mysql_query($sql);

$row = 1; // 1-based index
while($row_data = mysql_fetch_assoc($result)) {
    $col = 0;
    foreach($row_data as $key=>$value) {
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
        $col++;
    }
    $row++;
}

这篇关于PHPExcel如何动态设置单元格值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！