Use aspose API to run VBA macro on a templet

Aspose.Cells Product Family
1

Hi,

This question is been ask before but I just want to make sure I have the latest official response.

Is there any way to run VBA macro store on a templet using Aspose.cells ?

Thanks,

2

Hi,

Please download the latest version:
Aspose.Cells for .NET v7.0.2.1

You cannot run VBA macros using Aspose.Cells nor you can manipulate them, but Aspose.Cells will allow you to preserve macros and you will not lost them if you will save the macros containing workbook using Aspose.Cells APIs

3

I am trying to automate a report with a pivot table on it.

The automation needs to pulls data from a DB then paste it on a templet and then use that pasted data as a source of a pivot then copy the output of the pivot to a different sheet then erase the pivot.

My question is can I access the pivot on the templet from aspose?

4

Hi,


Well, as my fellow member told you that Aspose.Cells does not support to run VBA/Macro in the template file. The issue is already logged with an id: 13561. The feature might be supported in future though and not very soon.

“ am trying to automate a report with a pivot table on it.

The automation needs to pulls data from a DB then paste it on a templet and then use that pasted data as a source of a pivot then copy the output of the pivot to a different sheet then erase the pivot.

My question is can I access the pivot on the templet from aspose?”

Well, Aspose.Cells does support to create and even manipulate existing pivot tables in the template files. Also, you may import data from variety of data sources e.g DataTable, Arrays etc. I think you may import data from database tables to fill data to a worksheet. Now you can create/update pivot tables in different sheets based on the inserted data. See some topics in the regards:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/importing-data-to-worksheets.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/how-to-create-a-pivottable.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/setting-pivottables-appearance.html


Thank you.

5

Hi,

Thanks for using Aspose.Cells.

We only plan to create,
manipulate or embed VBA codes/ macros later. We however cannot support
to run or execute macros. Does it fit your needs?