Question

Mallikarjuna Reddy S on Fri, 11 Mar 2016 10:39:03


Can somebody help me in doing this using JavaScript by adding a web part. to have a button which by clicking should allow us to upload excel sheet when we chose the right sheet it should take those necessary columns from the sheet and add to the list if any thing changed to the old ones then it shall be updated.

Kindly someone help me in finding a solution to this.

Replies

Linda ZL on Mon, 14 Mar 2016 08:01:07


Hi Mallikarjuna Reddy S,

Import data from Excel to a SharePoint list using JavaScript, you need to use Excel Services ECMAScript (JavaScript).

Information about ECMAScript for your reference:

https://msdn.microsoft.com/en-us/library/office/ee556354.aspx

If you want to achieve it using code, here is an article about how to import data from Excel to a list by coding:

https://iarivu.wordpress.com/2015/01/05/import-data-to-sharepoint-list-from-excel/

Best regards,

Linda Zhang