I have an excel document which is sent daily to me.
I have a SharePoint List that is then update daily by me with all the excel documents information (complete overwrite each day).
The list is used to generate a few calculation and metrics reports.
Is there a way to associate the List and Excel document together so I can just overwrite an excel document in a document library and the list will populate? I know I can create a List from an excel document but that is only a one time process as far as I can tell.
I have excel services turned on so I can view the document in the browser.
Currently, I use a query like this to query the List. If this can be changed to query the excel document that is another viable option.
$().SPServices({
operation: "GetListItems",
CAMLQuery: "<Query><OrderBy><FieldRef Name='date'/></OrderBy></Query>",
CAMLViewFields: "<ViewFields><FieldRef Name=<fieldName>/></ViewFields>",
listName: <list id>,
completefunc: <functionname>
});
});