Excel Addins

Aspose.Cells Product Family
1

Hello,

Can I create Excel addins with Aspose Cells ?

Regards

Sereno

2

Hi,


Well, Aspose.Cells is a class library that is used to manage Excel spreadsheets at every level. No, you cannot create Excel Add-ins by Aspose.Cells, but you may specify your existing Add-ins and use in the formulas to specify them via Aspose.Cells.

In short, if developers need to add some custom functions or formulas, they can do it by using their add-in functions because Aspose.Cells is highly flexible to support Add-in functions. Developers can call AddInFormula method of the Cell class to set an add-in formula or function to a cell.

e.g
//Setting an add-in formula on the “H11” cell of the worksheet

worksheet.Cells[“H11”].SetAddInFormula(“HRVSTTRK.xla”, “=pct_overcut(F3:G3)”);

See the topic for reference:
http://www.aspose.com/docs/display/cellsnet/Using+Formulas+or+Functions+to+Process+Data

Let us know if you have any confusion.

Thank you.

3

Hello Amjad,

Thank you very much for yout quick response.
In fact, I use addin, mainly because I don't want users to be dependent
on a particular worbook.
Addins seems for me easier to deploy and update.
But, perhaps am I misusing classical Excel Aspose applications.

Regards

4

Hi,

Thanks for your posting and using Aspose.Cells.

Please use the function as mentioned above to fulfill your needs. If you face any other issue, please feel free to let us know. We will be glad to help you further.