VBA Function Support

Aspose.Cells Product Family
1

Hi Ive been using Aspose.Cells for the last year and have been impressed with the speed and ease of use of the API.

Im now working on another project which has pre-existing workbooks that contain VBA functions. There are several hundred versions of these workbooks with different VBA functions. These workbooks are used to perform calculations by passing in data, evaluating the workbooks and taking back some data to store in a database. The process is slow and laborious as it uses COM interop to excel from managed C# code. There is no plan to revist these workbooks

So Ive looked at using Aspose.Cells rather than interop and unfortunately it does not appear that Aspose.Cells supports executing VBA code in an Aspose.Workbook (that is a cell referencing a VBA function). Are there any plans to add this feature in the future?

2

Hi,

Yes, I am afraid Aspose.Cells does not support to run VBA code, anyways we will get back to you soon if we can plan this feature in future.

By the way, could you try some Aspose.Cells APIs for import / export task to database if it can suit your need e.g Cells.ImportDataTable(), Cells.ExportDataTable() etc.

Thank you.