API formula support

Hi.
I am searching for library to manage excel files on server (ASP.NET Core 2.0 targeting netcoreapp2.0).

I need API to:

  • open excel files
  • write some values to cell
  • execute formulas:
    • =+VLOOKUP(C2,List2!A:B,2)
    • =SUM(List2!B1:B23)
    • =SQRT(D6)
    • =ROUNDUP(E6,0)
    • =ROUNDDOWN(E6,1)
    • =ROUND(E6,2)
    • =LEFT(F2,5)
    • =RIGHT(F2,3)
    • =MID(F2,6,8)
    • =CONCATENATE(G2," “,H2,” ",I2)
  • read values from formula cells

Can I do that with your library? Which price model do I need (Pricing - Purchase - aspose.com)?
I am building one ASP.NET Core application for our customers.

@OpalInformatika,

Thanks for your query.

I think Aspose.Cells does support your needs well. It provides a separate .NET Core assembly which supports all your mentioned formulas, see the document on supported formulas/functions for your reference:

You should try our latest version/fix: Aspose.Cells for .NET v18.4

Regarding subscription, pricing or licensing queries, please start a new thread in Aspose.Purchase section and one of our sales staff member will help you soon.