I have a folder into which a new Excel Sheet is periodically copied.
Once every day I want to import the sheet data into a Sharepoint list. I know how to do this by hand, convert the data into list form and publish or merge to a sharepoint list. But what I need to do is do all this programatically.
I have a sharepoint list and want to merge new data from a normal Excel List into it. I want to be able to schedule this task to run as
soon as a new sheet is available in the target folder.
Can this be done using the Exel Object model through .Net/C#?
How would I do this?