Reviving datasheet view in SharePoint 2013 for selective sites

 In SharePoint 2013 the datasheet view is deprecated by Microsoft and Quick edit was promoted. Datasheet view is an ActiveX component which has tight dependency with Internet Explorer and Quick Edit is based on HTML 5, CSS and JS achieving cross platform and cross browser compatibility.

                Datasheet view in legacy platform is ideal for doing bulk row edits and inserts without facing performance issues with few caveats.

How Data Sheet view works?

Datasheet view is an ActiveX component called ListNet from STSList.Dll which accept the below parameters to work properly

• ListName
• ViewGuid
• RootFolder
• ListWeb
• ListData
• ViewSchema
• ListSchema

Pros and Cons

 Pros

•  Users will get the legacy control to work in the same fashion without the need of exporting to excel.

Cons

• Document Center is not supported.
• Managed metadata is not supported.
• Cross browser and Cross platform incompatible.