当前位置: 动力学知识库 > 问答 > 编程问答 >

phpexcel - Is there a PHP library for XLSM(Excel with Macro) parsing/editing?

问题描述:

  • I know that PHPExcel does not support XLSM files.
  • I have tried Iliaal's wrapper around Libxl, can be found here

However both of them do not support XLSM, they do cool with XLS though. I have searched all over the internet and didn't find a library, or a method with PHP to do so.

By the way, my environment is *NIX.

EDIT

I do not need to edit macros itself. I don't want to touch them, but I want a library/wrapper/command line executable(as last resort) to work with XLSM files(XML Sheets with Macros).

Thanks.

网友答案:

We've faced the exact same problem as you mentioned where we need to modify Excel workbooks but to do not want to impact the existing macros.

To do so, we've used the LibXL library and as of version 3.3.1 it supports the preservation of macros for .xls files. It is not written in PHP, therefore we wrote a small C++ program and then we call this program from php via the exec() PHP method. It works very well.

网友答案:

This is completely out of my knowledge as I'm only familiar with PHPExcel... However there might be something for you in this discussion about Read/Write macro in .xlsm? There seems to be no library but this sure looks promising.

Read/Write macro in .xlsm

分享给朋友:
您可能感兴趣的文章:
随机阅读: