Free Support Forum - aspose.cloud

Reading and writing to XLSX document with Node.js SDK of Aspose.Cells Cloud API

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)

@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.

EMI Calculator.zip (38.9 KB)
Hi,

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

@AbhijeetSinha

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

@AbhijeetSinha

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

  1. Set Cell Value https://apireference.aspose.cloud/cells/#!/Cells/Cells_PostWorksheetCellSetValue
  2. Calculate Formula https://apireference.aspose.cloud/cells/#!/Cells/Cells_PostCellCalculate
  3. Read cell data by cell’s name https://apireference.aspose.cloud/cells/#!/Cells/Cells_GetWorksheetCell

Aspose.Cells Cloud SDK for Node.js examples

We have also written Postman example for your convenience:
https://documenter.getpostman.com/view/2744137/set-calculate-and-get-cell-value/RVu7Eoba