Hello all,
I'm looking for a way to automatically publish tables in Excel into Sharepoint such that if the table is updated in excel the corresponding list is updated in Sharepoint.
I am able to perform the initial publish of the excel table into Sharepoint, but any subsequent attempts results in an error message being thrown that the List name already exists and I'm not seeing an Overwrite option. We do not want to create a new list every time we perform a sync, because then the new List's view has to be managed pretty extensively on the Sharepoint side.
right now the publishing code that works for the initial push is:
where:
"Table4" is the table name in Excel
"list4" is the list name in Sharepoint (that I want to overwrite)
Suggestions appreciated!
Thanks
-o
Bookmarks