BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
<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; }
}
|