I have 2 folders. The first folder carries 3 files and the second folder carries 4 files.
I want to upload those files into sharepoint in a way such that:
1) It creates two document libraries in SP. Each document library will have the same as the folder name.
2) Each document library will carry the files that are present in the folder.
3) There is one excel sheet at the root location which carries metadata associated with all the files.
4) code should read the metadata from the excel sheet and update that metadata information while uploading file into the sharepoint document library.
I want to use C# code to do this.
Any help is highly appreciated.