Last post Nov 10, 2009 02:36 PM by Mikesdotnetting
Nov 09, 2009 03:33 PM|shafiqm|LINK
I am uploading an excel file and then reading the excel file into dataset. It is working fine. But problem comes, when loaded excel file have checkboxes. Does any one know how to read checkboxes from excel file using .Net?
Nov 09, 2009 04:34 PM|Mikesdotnetting|LINK
Right click on the checkbox control then choose Format Control. See if the Cell Link option has an entry in it. If it does, it is pointing to the cell that contains the value that controls the Checkbox. Read that into the DataSet.
Nov 10, 2009 11:59 AM|shafiqm|LINK
Thanks for the input. Is this will be the same for drop down lists?
Nov 10, 2009 02:36 PM|Mikesdotnetting|LINK
Not sure. If I were you, I'd select * from the excel file and bind it to a GridView. Look at the values in it and compare them to the excel sheet. That should help you locate where specific values are stored.