Hi,

Thanks for your reply.

Code in excel button click:

TList<UsersTest> searchList = (TList<UsersTest>)Session["UsersTest"

];

ugUserGroupList.Browser =

BrowserLevel

.Auto;

ugUserGroupList.DisplayLayout.LoadOnDemand =

LoadOnDemand

.NotSet;

ugUserGroupList.DisplayLayout.Pager.CurrentPageIndex = 1;

false

;

ugUserGroupList.DisplayLayout.Pager.AllowCustomPaging =

false

;

ugUserGroupList.DisplayLayout.Pager.MinimumPagesForDisplay = 0;

"Next"

;

ugUserGroupList.DisplayLayout.Pager.PagerAppearance =

PagerAppearance

.Bottom;

ugUserGroupList.DisplayLayout.Pager.PageSize = 8;

"[default]"

;

ugUserGroupList.DisplayLayout.Pager.PrevText =

"Prev"

;

ugUserGroupList.DisplayLayout.Pager.QuickPages = 2;

PagerStyleMode

.Numeric;

//ugUserGroupList.DisplayLayout.Pager.

ugUserGroupList.DataSource = searchList;

ugUserGroupList.DataBind();

//ugUserGroupList.Columns.FromKey("Id").Hidden = true;

//ugUserGroupList.Columns.FromKey("Status").DataType = typeof(String).ToString();

UltraWebGridExcelExporter1.DownloadName =

DateTime.Now.ToString("yyyyMMdd hhmm") + "UsersTestList"

Display Layout of Grid:

<displaylayout allowcolsizingdefault="Free" allowcolumnmovingdefault="OnServer"

allowdeletedefault="No" allowsortingdefault="OnClient" AllowRowNumberingDefault="Continuous"

bordercollapsedefault="Separate"

headerclickactiondefault="SortMulti" name="uwgSearchList"

rowheightdefault="20px" rowselectorsdefault="No"

selecttyperowdefault="Extended" stationarymargins="Header"

stationarymarginsoutlookgroupby="True" tablelayout="Fixed" version="4.00"

viewtype="Flat" NoDataMessage="No Records found"

AutoGenerateColumns="False" CellClickActionDefault="RowSelect">

<framestyle backcolor="window" bordercolor="InactiveCaption"

borderstyle="Solid" borderwidth="1px" font-names="Microsoft Sans Serif"

font-size="8.25pt" ForeColor="#404040">

</framestyle>

<HeaderStyleDefault BackColor="#196155" Cursor="hand" Font-Names="Verdana" Font-Size="10px" Font-Bold="true" ForeColor="white">

<Padding Left="3px"/>

</HeaderStyleDefault>

<SelectedRowStyleDefault BackColor="#5ccf93"></SelectedRowStyleDefault>

<pager Alignment="Right" AllowPaging="True" PageSize="10">

<PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">

<borderdetails colorleft="White" colortop="White" widthleft="1px"

widthtop="1px" />

</PagerStyle>

</pager>

<editcellstyledefault borderstyle="None" borderwidth="0px">

</editcellstyledefault>

<footerstyledefault backcolor="LightGray" borderstyle="Solid" borderwidth="1px">

<borderdetails colorleft="White" colortop="White" widthleft="1px"

widthtop="1px" />

</footerstyledefault>

<RowStyleDefault BackColor="Window" BorderColor="#405b12" BorderStyle="solid" BorderWidth="1px"

Font-Names="Verdana" Font-Size="10px" ForeColor="black">

<Padding Left="5px" />

</RowStyleDefault>

<RowAlternateStyleDefault BackColor="#e2fcdf"></RowAlternateStyleDefault>

<groupbyrowstyledefault backcolor="Control" bordercolor="Window">

</groupbyrowstyledefault>

<groupbybox Hidden="True">

<boxstyle backcolor="ActiveBorder" bordercolor="Window">

</boxstyle>

</groupbybox>

<activationobject bordercolor="" borderwidth="">

</activationobject>

<filteroptionsdefault>

<filterdropdownstyle backcolor="White" bordercolor="Silver" borderstyle="Solid"

borderwidth="1px" customrules="overflow:auto;"

font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px" height="300px"

width="200px">

<padding left="2px" />

</filterdropdownstyle>

<filterhighlightrowstyle backcolor="#151C55" forecolor="White">

</filterhighlightrowstyle>

<filteroperanddropdownstyle backcolor="White" bordercolor="Silver"

borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;"

font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px">

<padding left="2px" />

</filteroperanddropdownstyle>

</filteroptionsdefault>

</displaylayout>

Note: For paging, I'm using pattern.

Kindly suggest.

Thanks!

;