Reading and writing to xlsx document


#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 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

Node.js examples would be SetValueOfCell.js, CalculateCellFormula.js and GetCellWorksheet.js.

We have also written Postman example for your convenience: