I think I am looking to do something simple: Update a named cell inside a workbook using openxml sdk.
The background: workbooks are received via email and contain a named cell called totalCredit that needs to be updated with the correct value and returned back to its sender.
What I have so far is:
- Locate the DefinedName
- Extracted the cell reference from the InnerXml property (split by ! then by $)
- Locate the cell under the worksheet with the parsed cell reference
- Update the CellValue with a new CellValue
This looks too convoluted. Is there a safer / easier way?