Spreadsheet Gear 2017 adds a new Spreadsheet Gear for .
NET Standard product, official support for Excel 2013 and Excel 2016, 51 new Excel functions, full conditional formatting support, enhanced workbook protection and encryption, cell gradient rendering, and more.
We introduced all three operational keyword sets: insert, replace value of, and delete; and used them to perform some of the more common XML modification operations.
We also pointed out some limitations and appropriate workarounds.
For example, an operation that tries to update the salary amount of two different employees in the following manner will fail: UPDATE HR_XML SET Salaries.modify('replace value of (/Salaries/Marketing/Employee[@ID=("2")]/Salary/text()) with ("60000")'), Salaries.modify('replace value of (/Salaries/Marketing/Employee[@ID=("1")]/Salary/text()) with ("60000")') GO Instead, multiple updates to the same XML value must be accomplished using entirely separate UPDATE statements. We need to update the salary amount to match that of employee #2 (60600): Notice that we had to perform two separate modify() operations in order to update the salary and tier data.