The following query is used to get data in which flagchecked is boolean.

```
var reducedList = alarmlog.Select(e => 
new { 
    e.ID, 
    e.alarmname, 
    e.alarmmessage, 
    e.metername, 
    e.starttime, e.flagchecked 
}).ToList();

```

I am using reducedList to export data to excel. Excel displays boolean values as checkboxes.I would like to have text "True" or "Done" for corresponding boolean true/false.