Support for Excel? RRS feed

  • Question

  • Is it possible to use Excel for data synchronisation if a custom provider for the sync framework was written? Or is it simply too unstructured to support the synchronisation methodology?


    Sunday, November 23, 2008 8:35 PM


  • Yes, this is certainly possible.  What I think will be the most important decision is what is the item level scope you will use for the document?  Or more specifically what is the level of change you will want to track and synchronize?  You could do it at the file level, worksheet, row, column + row, etc. 


    Certainly the file level is the easiest to implement as this is just simple file sync, however it is also the least efficient and I suspect not what you want to do.  If you go deeper down then there will be more work to detect which items have changed because as far as I know, excel does not provide a change tracking mechanism.  In this case you could do what we call a full enumeration which is to scan the entire set of items which compares the state of the items in our metadata to detect what has changed.  Once again not quite as efficient as if Excel could provide changes itself but certainly very workable.


    I am sorry to say that we do not have an Excel example, but hopefully some of the Sync101 samples (http://code.msdn.com/sync) will be a helpful place to start.




    Thursday, December 11, 2008 5:32 PM