Free Support Forum - aspose.com

Working with VBA scripts in java

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

Hi Saileela,

We will soon provide the java version of the method.

Thank you.

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");