I need to import an excel file to Sharepoint list without using manual import (Import to Excel). Instead, I want to import automatically by specifying the path of the Excel sheet or by using any Scheduler. Suggest me...
1 Answer
I dont know what do you mean by "manual import" but SharePoint provides you OOB functionality for this, go to view all Site Contents, there you will find the option "Import Spreadsheet", it imports automatically by specifying the path of the Excel, but if you must perform some custom action while importing the data you should consider developing a webpart