Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
144345 | May 2,2019 12:21 AM UTC | May 3,2019 05:27 AM UTC | ASP.NET Web Forms | 3 |
![]() |
Tags: Grid |
<ej:Grid ID="FlatGrid" runat="server" IsResponsive="true" AllowFiltering="True" AllowGrouping="true" AllowReordering="true" AllowSorting="true" OnServerExcelQueryCellInfo="FlatGrid_ServerExcelQueryCellInfo" OnServerPdfQueryCellInfo="FlatGrid_ServerPdfQueryCellInfo" OnServerWordExporting="FlatGrid_ServerWordExporting" OnServerPdfExporting="FlatGrid_ServerPdfExporting" OnServerExcelExporting="FlatGrid_ServerExcelExporting" AllowPaging="True">
<ToolbarSettings ShowToolbar="true" ToolbarItems="excelExport,wordExport,pdfExport"></ToolbarSettings>
<Columns>
……………………………………..
<ej:Column Field="Verified" HeaderText="True/False" Width="90" />
</Columns>
</ej:Grid>
/////////////////////////////
protected void FlatGrid_ServerExcelQueryCellInfo(object obj)
{
IRange range = (IRange)obj;
if ( range.Column == 7)
{
if (range.Value == "TRUE")
range.Value = "Ok";
else
range.Value = "Not Ok";
}
}
//////////////////////////////
protected void FlatGrid_ServerPdfQueryCellInfo(object obj)
{
PdfGridCell gCell = (PdfGridCell)obj;
if (gCell.Value.ToString() == "true")
gCell.Value = "Ok";
else if (gCell.Value.ToString() == "false")
gCell.Value = "Not Ok";
}
|
|
|
<ej:Grid ID="FlatGrid" runat="server" IsResponsive="true" ShowColumnChooser="true" AllowFiltering="True" AllowGrouping="true" AllowReordering="true" AllowSorting="true" OnServerExcelRowInfo="FlatGrid_ServerExcelRowInfo" OnServerPdfRowInfo="FlatGrid_ServerPdfRowInfo" OnServerPdfExporting="FlatGrid_ServerPdfExporting" OnServerExcelExporting="FlatGrid_ServerExcelExporting" AllowPaging="True">
<ToolbarSettings ShowToolbar="true" ToolbarItems="excelExport,pdfExport"></ToolbarSettings>
<Columns>
……………………………….
</Columns>
</ej:Grid>
// Server End
public GridProperties obj;
List<cols> column = new List<cols>();
protected void FlatGrid_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
ExcelExport exp = new ExcelExport();
obj = ConvertGridObject(e.Arguments["model"].ToString());
GridExcelExport exp1 = new GridExcelExport() { Theme = "flat-lime", FileName = "Export.xlsx" };
exp.Export(obj, (IEnumerable)FlatGrid.DataSource, exp1);
}
protected void FlatGrid_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
PdfExport exp = new PdfExport();
obj = ConvertGridObject(e.Arguments["model"].ToString());
GridPdfExport exp1 = new GridPdfExport() { Theme = "flat-lime", FileName = "Export.pdf" };
exp.Export(obj, (IEnumerable)FlatGrid.DataSource, exp1);
}
private GridProperties ConvertGridObject(string gridProperty)
{
…………..
}
protected void FlatGrid_ServerExcelRowInfo(object currentCell)
{
GridColumnChange();
IRange range = (IRange)currentCell;
for (var y = 0; y < range.Column; y++)
{
if (column[y].Field == "Verified") // Check the Boolean values field name and apply the customization.
{
if (range.Value == "TRUE")
range.Value = "Ok";
else
range.Value = "Not Ok";
}
}
}
protected void FlatGrid_ServerPdfRowInfo(object currentCell)
{
GridColumnChange();
Syncfusion.Pdf.Grid.PdfGridRow range = (Syncfusion.Pdf.Grid.PdfGridRow)currentCell;
for (var i = 0; i < range.Cells.Count; i++)
{
if (column[i].Field == "Verified") // Check the Boolean values field name and apply the customization.
{
if (range.Cells[i].Value.ToString() == "true")
range.Cells[i].Value = "Ok";
else if (range.Cells[i].Value.ToString() == "false")
range.Cells[i].Value = "Not Ok";
}
}
}
public void GridColumnChange()
{
for (var j = 0; j < obj.Columns.Count; j++)
{
if (obj.Columns[j].Visible == true)
{
column.Add(new cols() { Field = obj.Columns[j].Field }); // Add Visible column Field here.
}
}
}
public class cols
{
public string Field { get; set; }
}
|
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.