Hi Eduardo,

I will evaluate the possibility of adding the Calculate functionality to the component.

Thank you for the request!

CA

Hi again Eduardo,

I've uploaded a new version of the component, with three new actions:

• Workbook_Calculate() - calculates all formulas in the Workbook
• Worksheet_Calculate() - calculates all formulas in one Worksheet
• Cell_CalculateByIndex() - calculates the formula of a cell, defined by its index

Thank you for your request and hope this helps!

CA

Thanks! It will be useful! :)

Hi,

Please pardon the noob question... how do i add a formula to a cell?

When i write a formula, it just displays as text in the excel, the calculate function doesn't seem to do anything.

Thanks

Hello Vibhu,

Thank you for this request, I've uploaded a new version of the component, with the ability to write a formula to a Cell identified by index or name.

Thank you.

CA

Hello Carlos, do you have any example of setting formula in the excel cell? I tried but it it will display "#value!" calculation error after the excel file is generated. Then, when I open the excel file and click "Enable Editing", the formulas work well.

Any tricks?

Maple Field

Hi Carlos,

Is it possible to read the excel with headers starting from row 12 instead of row 1?

Thanks,

Saicharan