Read checkbox control value from excel sheet using C#

Question

I am working on reading excel sheet using C#. Here, I get stuck when reading check box control from excel. We need to read whether a checkbox is checked or unchecked.

We are using office open xml to read the excel.

OfficeOpenXml.ExcelWorksheet worksheet=Package.workbook.worksheets["abc"];

var  draw=worksheet.Drawings.SingleOrDefault(a=>a.name ==  "Check Box 45");

using draw.text I am getting checkbox text but I'm not able to read whether it is checked or unchecked.

Thanks,

Thanks, Ashish

Try casting to ExcelControlCheckBox (or use dynamic). Then read the Checked property. — Ben Voigt
– Ben Voigt, Commented Aug 17, 2021 at 18:14

Sujit Patel · Accepted Answer · 2021-08-17 18:39:10Z

0

Link checkbox with some other cell. and store value true/false in that cell based on checkbox check/uncheck.

Here I have linked checkbox with cell[z:1]. when user check i will add value in cell[z:1] as true. if user uncheck, I will add false. after that i will read value from cell[z:1] as like below.

ExcelWorksheet loExcelSheet = excel.Workbook.Worksheets.SingleOrDefault(a => a.Name == "SheetName");
                    ExcelDrawing cbox1 = loExcelSheet.Drawings.SingleOrDefault(a => a.Name == "CBox1");
                   var lsRes = loExcelSheet.Cells["Z1"].Value.ToString();

answered Aug 17, 2021 at 18:39

Sujit Patel

1558 bronze badges

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

4 Comments

Ashish Shinde Over a year ago

Link checkbox with some other cell. -- This solution will not work in my case as end user is going to upload excel file with check box checked or unchecked.

Ashish Shinde Over a year ago

Link checkbox with some other cell - This solution is not suitable for my project. As these excels are generated from other application/other team, so we do not have control over excel. User uploads these files in our application, where these file needs to auto read and insert values in database. We need to read checkbox value without changing the template.

Ashish Shinde Over a year ago

Hi @sujit-patel How it can be cast using open xml or any other solution for it?

Sujit Patel Over a year ago

@AshishShinde I need to check for the same.

Ashok kumar Muthukumaran · Accepted Answer · 2022-08-05 03:43:27Z

0

You can read the value using OpenXml's control properties.

var control = wsPart.Worksheet.Descendants<DocumentFormat.OpenXml.Spreadsheet.Control>().FirstOrDefault();
        var controlProperies = (ControlPropertiesPart)wsPart.GetPartById(control.Id);
        isChecked = controlProperies.FormControlProperties.Checked == "Checked";

original post reading excel file -> getting checkbox value

answered Aug 5, 2022 at 3:43

Ashok kumar Muthukumaran

11 bronze badge

Collectives™ on Stack Overflow

Read checkbox control value from excel sheet using C#

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related