Forum Discussion
Importing multiple Excel files into Sharepoint that are each being updated daily (same headers)
Hello everyone,
Help, please. I would like to import multiple Excel files into a Sharepoint list. The Excel files all have the same headings, although they will have different information in each column. There are 15 files representing 15 different areas of the company. Each file will have the company area in column A e.g. Company Area 1 (first file), Company Area 2 (second file) etc. The files will be updated on a daily basis so the import must recognise this and place new records in new lines in Sharepoint i.e. not overwrite the record beneath. Is this possible?
Many thanks, Pillsbury33.
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.
1 Reply
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.