Step towards SharePoint

function GetItems() {       $.ajax     ({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('SharePoint List Name')/items?$select=Column1,Column2",         type: type,         data: data,         headers:         {             "Accept": "application/json;odata=verbose",             "Content-Type": "application/json;odata=verbose",             "X-RequestDigest": $("#__REQUESTDIGEST").val(),             "IF-MATCH": "*",             "X-HTTP-Method": null         },         cache: false,         success: function(data)           {     //success - bind values here     ...

function deleteItemByID(id) {     $.ajax     ({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('SharePoint List Name')/items("+id+")",         type: "POST",         headers:         {             "X-RequestDigest": $("#__REQUESTDIGEST").val(),             "IF-MATCH": "*",             "X-HTTP-Method": "DELETE"         },         success: function(data, status, xhr)         {             //alert("Success");         },         error: function(xhr, status, error)         {            //Failure         }     }); }  

function updateListItem(id) {     var titleVal = $("#txtTitle").val();     $.ajax     ({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('SharePoint List Name')/items("+id+")", // list item ID         type: "POST",         data: JSON.stringify         ({             __metadata:             {                 type: "SP.Data.TestListItem"             },             Title: titleVal         }),         headers:         {             "Accept": "application/json;odata=verbose",             "Content-Type": "application/json;odata=verbose",       ...

Add List Item function AddItem() {     var titleVal = $("#txtTitle").val();      var metadataVal = {                 "__metadata": { "type": getListItemType("SharePoint List Name") },                 "Title": titleVal             };     $.ajax         ({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('SharePoint List Name')/items",         type: "POST",         data: JSON.stringify(metadataVal),         headers:         {             "Accept": "application/json;odata=verbose",             "Content-Type": "application/json;odata=verbose",             "X-RequestDigest": $("#__REQUESTDIGEST"...

< script type ="text/javascript" language ="javascript" src ="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></ script > < script type ="text/javascript" language ="javascript">     $(document).ready( function () {         $( ".ms-vb a" ).attr( 'target' , '_blank' );     }); </ script >

Convert DataTable to Stream private static MemoryStream WriteExcelFile (string sheetName , DataTable table ) {  MemoryStream stream = new MemoryStream();  using (SpreadsheetDocument document = SpreadsheetDocument.Create( stream , SpreadsheetDocumentType.Workbook,true))  {   WorkbookPart workbookPart = document.AddWorkbookPart();   workbookPart.Workbook = new Workbook();   WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();   var sheetData = new SheetData();   worksheetPart.Worksheet = new Worksheet(sheetData);   Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());   Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = sheetName };   sheets.Append(sheet);   Row headerRow = new Row();   List<String> columns = new List<string>(); ...

completefunc: function (xData, Status) {            var ItemCount = $(xData.responseXML).SPFilterNode("rs:data").attr("ItemCount"); }

Generate the below URL for any list / library SiteURL/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={ List ID }&View={ View ID }&CacheControl=1 Ex: http://SharepointSiteCollection:80/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={XXXXXXXX-XXXX-XXXX-XXXXXXXXX&View={XXXXXXXX-XXXX-XXXX-XXXXXXXXX}&CacheControl=1 Note : For List ID and View ID, you could get it from List Setting page and View page respectively