Working with VBA scripts in java

Aspose.Cells Product Family
1

Hi,
We have a requirement to work with VBA script using aspose.cell for java.
setAddinFormula method is available with .net version .
Please let us know if similar version is available with java version also.
With regards
Saileela

2

Hi Saileela,

We will soon provide the java version of the method.

Thank you.

3

Hi Sailieela,

Please try this fix.

We have added Cell.setAddInFormula() method .See following codes:

Workbook book = new Workbook();
Cells cells = book.getWorksheets().getSheet(0).getCells();
Cell cell = cells.getCell("A1");
cell.setAddInFormula("myaddin.xla", "=Addin_Func()");
book.save("C:\\Book1.xls");