是否存在用于XLSM(带有宏的Excel)解析/编辑的PHP库? [英] Is there a PHP library for XLSM(Excel with Macro) parsing/editing?

问题描述

• 我知道PHPExcel不支持XLSM文件.
• 我已经尝试过使用Iliaal的Libxl包装纸，可以在此处找到

但是他们两个都不支持 XLSM ，但是它们确实与 XLS 很酷.我已经在整个互联网上搜索了，没有找到库，也没有找到使用 PHP 的方法.

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.

顺便说一下，我的环境是 * NIX .

By the way, my environment is *NIX.

编辑 我不需要编辑宏本身.我不想碰它们，但我想使用库/包装器/命令行可执行文件(作为最后的手段)来处理XLSM文件(带有宏的XML Sheets).

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).

谢谢.

推荐答案

我们遇到了与您提到的完全相同的问题，我们需要修改Excel工作簿，但又不想影响现有的宏.

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.

为此，我们使用了LibXL库，从3.3.1版本开始，它支持保留.xls文件的宏.它不是用PHP编写的，因此我们编写了一个小型C ++程序，然后通过exec() PHP方法从php调用此程序.效果很好.

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.

这篇关于是否存在用于XLSM(带有宏的Excel)解析/编辑的PHP库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！