Invalid formula:"'C:\blp\api\dde\Blp.xla'!BLP(CONCATENATE($A1- " equity")-"bid")"

Aspose.Cells Product Family
1

_oWorkSheet.Cells[column, 2].Formula="'C:\blp\api\dde\Blp.xla'!BLP(CONCATENATE($A2, " equity"),"bid")";

_oWorkSheet.Cells[column, 2].Formula="'C:\\blp\\api\\dde\\Blp.xla'!BLP(CONCATENATE($A2, \" equity\"),\"bid\")";

when i am adding formula to excel cells the following error is ocured.

Invalid formula:"'C:\blp\api\dde\Blp.xla'!BLP(CONCATENATE($A1, " equity"),"bid")"

please resolve it as soon as possible

Manish

2

Hi Manish,

For inserting add-in formula or custom function, you may utilize Cell.SetAddInFormula() method.

For reference, please check the document:

http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/SetFormula.html

Thank you.

3

thanx team, it’s a nice artical :slight_smile: