dsfw2154 2017-05-18 11:21
浏览 23

不能从数据库setcellvalue但静态值工作?

I am using this code to set cellvalue from database but it does not work.

    $excel2 = PHPExcel_IOFactory::createReader('Excel2007');
    $excel2 = $excel2->load("test.xlsx"); // Empty Sheet


    $excel2->getActiveSheet()->setCellValue('A1', 'Date');

    $m=2;
    $result=mysqli_query($con,"select * from settings");

    while($row=mysqli_fetch_array($result))
    {
      $chan=$row['channelID'];
                $excel2->getActiveSheet()->setCellValue("C$m", $chan);
    echo $chan;
    echo "<br>";
    $m++;
    }

But when I change this line to static text it works fine

 $excel2->getActiveSheet()->setCellValue("C$m", "static text");

I don't know where I am doing wrong I want to set value from the database any help would be appreciated.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算