MS Excel - How to format cell as Yes/No instead of TRUE/FALSE

Question

I use Epplus to export excel as following

        FileInfo newFile = new FileInfo(@"sample6.xlsx");
        using (ExcelPackage pck = new ExcelPackage(newFile))
        {
            var ws = pck.Workbook.Worksheets.Add("Content");
            ws.Cells["A1"].Value = true;
            ws.Cells["A2"].Value = false;
            pck.Save();
        }

The result excel show TRUE and FALSE

How can I show those cells as Yes/No

Answer 1

You should use excel template with custom format "Yes";;"No";

Then load that template and write 1/0 instead of True/False

        FileInfo newFile = new FileInfo(@"sample6.xlsx");
        using (ExcelPackage pck = new ExcelPackage(newFile))
        {
            var ws = pck.Workbook.Worksheets["Content"];
            ws.Cells["A1"].Value = 1;
            ws.Cells["A2"].Value = 0;
            pck.Save();
        }