export to excel give me checkbox instead of string

Question

so I am doing the datasource export to excel, but i open the file i saw the column has checkbox instead of value true or false. how do i fixed this, indeed, i want to put a sting "active" or "inactive" depends on the value. how can i do that?

also i want to have string format for the phone number as well

and the code i have for model

  public string MobileNumber { get; set; }
  public bool? IsActive { get; set; }

how do i change in order for me to have the way that i want it ?

Have you tried converting your nullible boolean to a string before exporting? — JOpuckman
– JOpuckman, Commented Oct 17, 2012 at 20:34

System Down · Accepted Answer · 2012-10-17 21:03:19Z

2

Modify your model to return string for the IsActive property (or alternatively have two, one with bool and another with string). Then return the string value in the Linq query. Something like this:

from x in someTable
select new Model
    {
     .
     .
     .
     IsActive = (isActive ? "True" : "False");
     .
     .
    }

answered Oct 17, 2012 at 21:03

System Down

6,2711 gold badge33 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

ChrisLively Over a year ago

Similar solution for formatting the phone number, have the model format the retrieved data.

cool_spirit Over a year ago

hows the phone number differ from the isactive ?

cool_spirit Over a year ago

@System Down, sadly when i did IsActive = u.isActive ? "True" : "False" --- give me error about the : operator, do u know why ?

System Down Over a year ago

@cool_spirit - Why not open a new question? Put the full code there and the exact text of the exception.

Collectives™ on Stack Overflow

export to excel give me checkbox instead of string

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related