over 300 functions of Excel

[Greg]

How do I call these functions to give me the same answer as Excel?

It appears that this marketing sales pitch only refers to the ability to write function statements out to an xls file.

I want to execute these functions without Excel, using either ExcelRW or Grid or both. i.e. Excel equivalent function calls that return Excel equivalent results.

Please advise.

Thanks,
Greg

[Administrator]

Hi Greg,

ExcelRW can only be used to write the function statements to an xls file. All the calculations are done by MS Excel when the file is opened, so there is no way to call these functions directly without using MS Excel. However, this can be done using Essential Grid.

Essential Grid has a built in formula engine that supports many of Excel''s functions. We are constantly adding new functions to the formula engine and even in the eventuality that a specific function is not found in the formula engine, you can easily implement the function yourself. Please let me know if you have any questions. Thanks.

Best regards,

Stephen.

>How do I call these functions to give me the same answer as Excel?
>
>It appears that this marketing sales pitch only refers to the ability to write function statements out to an xls file.
>
>I want to execute these functions without Excel, using either ExcelRW or Grid or both. i.e. Excel equivalent function calls that return Excel equivalent results.
>
>Please advise.
>
>Thanks,
>Greg
>

[Amal k v]

Excel’s functions run on Excel’s own calculation engine, so they can’t be executed exactly without Excel. Tools like ExcelRW or grid libraries mainly read/write files, not calculate formulas. To get Excel-equivalent results, you’d need a library that re-implements Excel functions (partial support) or run Excel itself in the background for full accuracy.

[Gowtham Ponraj]

Hi Team,

XlsIO supports more than 400 formula, Please refer to this UG Working with Formulas | Syncfusion.

Regards,

Gowtham