How to execute macros using Aspose.cells

I am using Aspose.cells,can it execute the macro from *.xlsm ? if yes, how to do that?

Thanks!

Hi,


Thanks for your posting and considering Aspose.Cells.

We are afraid, Aspose.Cells cannot execute macros and this feature is not supported. However, this feature is already logged in our database but we are afraid, it is a difficult thing for us and we are unable to implement it so far. However, we have attached your thread with the existing ticket.

This issue has already been logged as

  • CELLSNET-40353 - Support for VBA Macros

Is it fair to say that this feature will never be supported? I see that the issue was initially logged back in 2012, and there is no update to date. It’d be good to understand the road map as it relates to CELLSNET-40353.

Hi,


Thanks for your posting and considering Aspose.Cells.

In order to support execution of VB macros, there must be a whole VB macro engine (or execution environment) just like CLR executes C# code and JRE executes Java code or Web Browsers (Chrome, FireFox) executes Javascript code. This is the reason, Microsoft Excel is a big application more than 500MB and Aspose.Cells is just 10 MB. So from here you can imagine its complexity. It needs lots of research and development which is not feasible for us. But the issue is still open, we have not closed it yet. So we have now logged your comment. If there is any update for you, we will let you know asap.

Hi,


Thanks for considering Aspose.Cells.

We have closed this ticket permanently for the reasons as described in the previous post. Sorry for the inconvenience.