How to modify existing spreadsheet?

I have tried to avoid asking this, likely just an issue of pride, however, at this point I am frustrated and need some insight.

I'm using MVVM with Unity IOC containers, as seen in pic "1" I load up an existing spreadsheet using a "behavior" class (pics 2 & 3).  The existing spreadsheet has some pre-formatting that I would like to use, rather than doing it in code.  End goal is to open that "template spreadsheet" and then inject values into it via the ViewModel (pic 4).

But, what I actually see is that the spreadsheet loads in the control & for a moment I can see all of the injected values (pic 5), but then they are overwritten by the "template spreadsheet" (pic 6) and so far I have been unable to figure out what I am doing wrong since it all seems backwards from what I would expect.

In any case, I need to be able to load an existing spreadsheet to use as a "template" then inject changes into that template and have it rendered to the user so hopefully someone can provide an example of doing that, using MVVM.


Attachment: Pictures_4b3e8523.zip

3 Replies

BT Balamurugan Thirumalaikumar Syncfusion Team August 12, 2021 04:06 PM UTC

Hi Scott, 

Thank you for interesting in Syncfusion products. 

We could understand your scenario “How to modify existing spreadsheet?” at our end. In order to modify the existing spreadsheet’s any particular cell, we suggest you to refer the following KB article for your reference. 


Please let us know if you would require any other assistance. we will be happy to assist you. 

Balamurugan Thirumalaikumar  




SC Scott August 12, 2021 06:51 PM UTC

That was perfect, thank you.  I do not require anything further for this.



BT Balamurugan Thirumalaikumar Syncfusion Team August 13, 2021 05:35 AM UTC

Hi Scott, 

Thank you for contacting Syncfusion support. 

We are very glad to have the provided solution resolved your query. please get back to us at anytime if you need any other assistance. As always we will be happy to assist you. 

Balamurugan Thirumalaikumar  



Loader.
Up arrow icon