Read the excel calculated cell values using AddIn(VSTO not VBA) Formulas

Aspose.Cells Product Family
1

Requirement:

  1. Open Existing Excel file
  2. Two cells : One is Input and other is Output
  3. Output cell is holding VSTO Add-in formula
  4. Input Cell is passing values to output cell
  5. Output cell formula looks : VSTOFormula(“Test”, InputCellValue)
  6. Output Cell values changes to values return by the VSTOFormula say “You are Good”
  7. I want to copy that Return value

I am using Aspose.Cell C# Ver 17.3.0.0

2

Hi,

Thanks for the details.

Well, Aspose.Cells may not evaluate VSTO or VBA formula. Aspose.Cells formula calculation engine works fine to evaluate and calculate MS Excel built-in functions/formulas. By the way, Aspose.Cells also allows to create user define functions via its specified APIs, See the following documents/articles on how to implement custom functions:
Using ICustomFunction Feature
Implement Custom Calculation Engine to extend the Default Calculation Engine of Aspose.Cells

Moreover, you may post your template Excel file containing VSTO functions, we will check if we could do something for it. .

Thank you.