Set Cell value, calculate formula and get Cell value in Excel with Node.js using Aspose.Cells REST API

Aspose.Cells Cloud Product Family
, ,
1

Hi,

I have an existing xlsx document. The xlsx document have some formulas as well.
Based on input, the cell value changes.

Using node js with aspose, do we have any api that can update the cell and get the updated cell value back?

For example:
I have EMI Calculator, If i update “C3”, “C7” will change automatically. Question is : using aspose api how will i write to C3 and read C7 after that?EMI_Calculator.zip (22 Bytes)

2

@AbhijeetSinha

Thank you for contacting Aspose Support.

EMI_Calculator.zip file is corrupted, we cannot expand it. Please check Aspose.Cells for Cloud API Reference page, it lists down all APIs of Aspose.Cells for Cloud.

3

EMI Calculator.zip (38.9 KB)
Hi,

Thanks for your quick response. I uploaded the file again for you to check.

4

@AbhijeetSinha

Thank you for providing the input file. We are going to share with you a working example shortly.

5

@AbhijeetSinha

Please call following three APIs in the given order, they would serve your purpose:

  1. Set Cell Value Aspose.Cells Cloud - API References
  2. Calculate Formula Aspose.Cells Cloud - API References
  3. Read cell data by cell’s name Aspose.Cells Cloud - API References

Aspose.Cells Cloud SDK for Node.js examples

We have also written Postman example for your convenience: