duanmu3049 2012-01-24 14:57
浏览 603
已采纳

PHPExcel setReadDataOnly无法使用Excel 2007

I am using phpexcel class to read .xls, .ods and .xlsx files, I need to ignore blank cells, even, if these cells have format.

I have used setReadDataOnly method to get it, and it's working fine with .xls and .ods files but it's not working with .xlxs files.

  • 写回答

1条回答 默认 最新

  • duancong7358 2012-01-24 15:05
    关注

    What exactly do you mean by "not working".

    The setReadDataOnly(TRUE) option on read doesn't prevent blank cells from being read if the cell actually exists in the spreadsheet file, it simply means that it doesn't read the formatting for any of the cells... a blank cell is still a blank cell, and unless you create a read filter to prevent certain cells from being read, then they will still be loaded.

    This behaviour is identical for xls, ods and for xlsx.

    The only facility provided in PHPExcel to "skip" blank cells is within the Cell Iterator.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥30 用arduino开发esp32控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题