How to export DataTable to Excel using C#

In this post we will be exporting the DataTable to an Excel using C#
Below is the method which will do the trick. Just pass the parameters datatable and the filename.

private void ExportDataTableToExcel(DataTable thetable, string fileName)

        {

            string attachment = "attachment; filename=" + fileName + ".xls";

            Response.ClearContent();

            Response.AddHeader("content-disposition", attachment);

            Response.ContentType = "application/vnd.ms-excel";

            //write columns from DataTable to Excel      

            string tab = "";

            foreach (DataColumn dc in thetable.Columns)

            {

                string title = string.Empty;

                if (dc.ColumnName.Contains("Meta"))

                    title = "Metadata Properties";

                else

                    title = dc.ColumnName;

                Response.Write(tab + title);

                tab = "\t";

            }

            Response.Write("\n");

            //write rows from DataTable to Excel  

            int i;

            foreach (DataRow dr in thetable.Rows)

            {

                tab = "";

                for (i = 0; i < thetable.Columns.Count; i++)

                {

                    Response.Write(tab + dr[i].ToString());

                    tab = "\t";

                }

                Response.Write("\n");

            }

            //To throw the excel file generated

            Response.End();

        }


Hope this helps...

Deleting all versions of a document present in document library except last 2 major and 1 minor versions Moss2007/Sharepoint2010

Recently i came across a requirement to develop a admin component which will delete all the versions of the document except some major and minor verisons present in a Sharepoint document library. Thought of sharing with you guys aswell.

In this post we are going to Delete all versions of a document present in document library except last 2 major and 1 minor versions

Below is the code snippet which performs the action.

You can made the variables int majorVersionsRequired and int minorVersionsRequired are as configurable depending on the versions you require.

try

{

   using (SPSite site = new SPSite("<<http://siteurl/>>"))

   {

      using (SPWeb web = site.OpenWeb())

      {

         SPList list = web.Lists["<<Doc Lib Name>>"];

         int majorVersionsRequired = 2;

         int minorVersionsRequired = 1;

         foreach (SPListItem item in list.Items)

         {

            SPListItemVersionCollection versionCol = item.Versions;

            int count = versionCol.Count;

            int tempMajorVersionsRequired = 0;

            int tempMinorVersionsRequired = 0;

            int versionSiNo = 0;

                           

            for (int i = 0; i <= count - 1; i++)

            {

               if (versionCol[i - versionSiNo].Level == SPFileLevel.Published)

               {

                  // this is a major version

                  tempMajorVersionsRequired++;

                  if (tempMajorVersionsRequired > majorVersionsRequired)

                  {

                     SPListItemVersion version = versionCol[i - versionSiNo];

                     version.Delete();

                     versionSiNo++;

                  }

               }

               else if (versionCol[i - versionSiNo].Level == SPFileLevel.Draft)

               {

                  //this is a minor version

                  tempMinorVersionsRequired++;

                  if (tempMinorVersionsRequired > minorVersionsRequired)

                  {

                     SPListItemVersion version = versionCol[i - versionSiNo];

                     version.Delete();

                     versionSiNo++;

                  }

               }

            }

          } 

      }

   }

}

catch (Exception ex)

{

}

Hope this helps...

jQuery SPServices to get current user sharepoint groups

In this post we are going to get information of all the sharepoint user groups in which current user belongs using SPServices.

Below is the jQuery code snippet which will do this action.

In this example we will be looping all the groups which the current user is present and adding it to the variable  loggedinUserGroup.

// add the ref of jQuery file
<script type="text/javascript" src="/style library/jquery-1.7.2.js"></script>
// add the ref of jQuery SPServices file
<script type="text/javascript" src="/style library/jquery.SPServices-0.7.0.min.js"></script>
<script type="text/javascript">
var loggedinUserGroup;
$(document).ready(function() {
 Getrolesforuser();
 alert(loggedinUserGroup);
});
function Getrolesforuser()
{
 loggedinUserGroup="";
 $().SPServices({ 
  operation: "GetGroupCollectionFromUser", 
        userLoginName: $().SPServices.SPGetCurrentUser(), 
        async: false, 
        completefunc: function(xData, Status)
        {
         $(xData.responseXML).find("Group").each(function()
         {
              if(loggedinUserGroup=="")
              {
                  loggedinUserGroup = $(this).attr("Name");
              }
              else
              {
                  loggedinUserGroup = loggedinUserGroup + "\n"+ $(this).attr("Name");
              }
         });
               
  }
 });
}

</script>

Hope this helps... Follow this page for more updates.
Related post- jQuery spservices to get current user name for sharepoint site
Related post- How to display user information using ProfilePropertyLoader in sharepoint