Forum Discussion
Importing multiple Excel files into Sharepoint that are each being updated daily (same headers)
Pillsbury33 Yes it is possible and there is ore than one way and your organisational ecosystem. Less cumbersome approach is to write timer job if you are in on-premise or azure scheduler with console app to do this for you.
Step 1: get the files in to one common location such as file path or share point folders
Step 2: write the console app/timer job which will handle the documents and their business logic
Step 3:Have some sort of logging and notification mechanism which will handle the error or exception and notify you accordingly
Hopefully this helps.
Pillsbury33 Yes it is possible and there is ore than one way and your organisational ecosystem. Less cumbersome approach is to write timer job if you are in on-premise or azure scheduler with console app to do this for you.
Step 1: get the files in to one common location such as file path or share point folders
Step 2: write the console app/timer job which will handle the documents and their business logic
Step 3:Have some sort of logging and notification mechanism which will handle the error or exception and notify you accordingly
Hopefully this helps.