reading excel file -> getting checkbox value

Question

So i think ive tried everything now. Im trying to get the values from radiobuttons and checkboxes from an excel sheet. My first approach was to use the Excel Data Reader: http://exceldatareader.codeplex.com/. The cells with checkboxes render empty.

Same thing if i use OLEDB;

string filename = @"C:\\" + "uploads\\SmartAuditSheet.xls";
        string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                                      "Data Source=" + filename + ";" +
                                      "Extended Properties=Excel 8.0;";

        OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",    connectionString);

        DataSet myDataSet = new DataSet();
        dataAdapter.Fill(myDataSet, "BookInfo");
        DataTable dataTable = myDataSet.Tables["BookInfo"];

        gv.DataSource = myDataSet;
        gv.DataBind();

Help please.

Will you have Excel installed on the machine? If so, have you tried MS Office Interop? — Jetti
– Jetti, Commented Oct 6, 2011 at 13:45
I have it, but i guess it wont work when i host the site on some webserver. — Johan
– Johan, Commented Oct 6, 2011 at 13:47

CouncilScribe · Accepted Answer · 2011-10-25 06:13:29Z

1

I would suggest you try something like the following.

 OLEObject ole = (OLEObject)excelWorksheet.OLEObjects("Checkbox1");

answered Oct 25, 2011 at 6:13

CouncilScribe

7117 silver badges19 bronze badges

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

Comments

Yahia · Accepted Answer · 2011-10-25 06:31:32Z

0

I would recommend using some 3rd-party library for that - there are several out there (free and commercial) that do NOT require Excel being installed:

OpenXML 2.0 (free library from MS) can be used to read/modify the content of an .xlsx so you can do with it what you want
EPPlus (free library) works with XLSX
some (commercial) 3rd-party libraries come with grid controls allowing you to do much more with excel files (most can do not only XLSX but XLS too) in your application (be it Winforms/WPF/ASP.NET...) like SpreadsheetGear, Aspose.Cells, Flexcel etc.

answered Oct 25, 2011 at 6:31

Yahia

70.5k9 gold badges117 silver badges147 bronze badges

Comments

Martin · Accepted Answer · 2014-10-13 11:35:22Z

0

bool state = Convert.ToBoolean(ws.OLEObjects("Checkbox1").Object.value());

answered Oct 13, 2014 at 11:35

Martin

3,5128 gold badges44 silver badges68 bronze badges

Comments

Ashok kumar Muthukumaran · Accepted Answer · 2022-08-02 18:01:21Z

You get the object values using OpenXML. Below Code shows how to get checkbox object values using OpenXML.

using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
public static bool GetCheckBoxValue( String filePath )
{
    bool isChecked = false;
    using (SpreadsheetDocument document = SpreadsheetDocument.Open(filePath, false))                   
    {
        WorkbookPart wbPart = document.WorkbookPart;
        // Sheet object to retrieve a reference to the first worksheet.
        Sheet theSheet = wbPart.Workbook.Descendants<Sheet>().Where(s => s.Name == "Sheet1").FirstOrDefault();
        var control = wsPart.Worksheet.Descendants<DocumentFormat.OpenXml.Spreadsheet.Control>().FirstOrDefault();
        var controlProperies = (ControlPropertiesPart)wsPart.GetPartById(control.Id);
        isChecked = controlProperies.FormControlProperties.Checked == "Checked";
    }
    return isChecked ;
}

Collectives™ on Stack Overflow

reading excel file -> getting checkbox value

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related