Display a string for a boolean type column.

[Corazon Cruz Sanchez]

Hi,

I have a grid that has a property of Boolean type, as I can show it in "Active", "Inactive" according to whether it is true or false, besides that I need
export it to excel passing the values ​​of "Active" and "Inactive"

Stay tuned.

Regards!

[Prasanna Kumar Viswanathan]

Hi Corazon, 

Thanks for using Syncfusion support.  

Based on your query we understand that you need to export the Grid records to excel with different text for Boolean column instead of True / False. So, we suggest you to achieve your requirement using ServerExcelQueryInfo event of grid while exporting.  

Refer the below code example 

[C#] 

 

public ActionResult ExportToExcel(string GridModel) 

        { 

            ExcelExport exp = new ExcelExport(); 

            var DataSource = order.ToList(); 

            GridProperties obj = (GridProperties)Syncfusion.JavaScript.Utils.DeserializeToModel(typeof(GridProperties), GridModel); 

            obj.ServerExcelQueryCellInfo = QueryCellInfo; 

            GridExcelExport excelExp = new GridExcelExport(); 

            excelExp.FileName = "Export.xlsx"; excelExp.Excelversion = ExcelVersion.Excel2010; 

            excelExp.Theme = "flat-saffron"; 

            return exp.Export(obj, DataSource, excelExp); 

        } 

 

 

        public void QueryCellInfo(object currentCell) 

        { 

            IRange range = (IRange)currentCell; 

            if (range.Column == 5) 

            { 

 

                if(range.Value == "TRUE") 

                    range.Value = "Active"; 

                else                 

                    range.Value = "InActive"; 

                 

            } 

 

        } 

For your convenience we have prepared a sample which can be downloaded from below link 

Sample:  https://www.syncfusion.com/downloads/support/forum/139335/7z/WebApplication1-1350909689  

Refer our UG documentation on server side exporting events. 

https://help.syncfusion.com/aspnet-core/grid/exporting?cs-save-lang=1&cs-lang=csharp#exporting-server-events    

 

Regards, 

Prasanna Kumar N.S.V 

[Corazon Cruz Sanchez]

Hi Prasanna,

My problem was solved thank you very much.

Regards!

[Prasanna Kumar Viswanathan]

Hi Corazon, 

We are happy to hear that your issue has been solved. 

Please let us know if you need any further assistance. 

Regards, 

Prasanna Kumar N.S.V