We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Cannot access Checkbox items in Excel doucment

Hi,

I currently have an excel spreadsheet that I am using as a template to generate a document. I have a web app that contains data. I have been using named ranges in Excel to map and this has worked perfectly so far.

I have a series of checkboxes that I am having difficulty updating. Syncfusion provides a method to get all of the checkboxes in a document. I have been using it like this:

IWorksheet sheet = document.Worksheets[worksheetName];
ICheckBoxShape checkBox = sheet.CheckBoxes[checkBoxName];

Where the whorksheetName is a string that is the name of the worksheet I am trying to access and checkBoxName is a string that is the name of the checkbox as defined in the excel spreadsheet.

This for me is returning an error. When debugging the code I discovered that the CheckBoxes count under IWorksheet isreturning 0 results.

I have multiple checkboxes throughout the docment with none of them being picked up. I am at a loss why this is the case.

Has anybody ran into a similar issue or am I trying to access these the wrong way?

Thanks,

Daniel Di Giandomenico



1 Reply

MK Manoj Kumar G M Syncfusion Team December 17, 2013 10:53 AM UTC

Hi Daniel,

Thank you for using Syncfusion products.

We are unable to reproduce the reported issue at our end. We request you to send us the excel template that causes the issue to investigate further on this and get back to you with a prompt solution. Kindly create a new incident from the below direct track link and update us the template in the incident. We can look into the issue and update you with further details.

Direct Track Link: http://www.syncfusion.com/support/directtrac/dtnewpost

Please let us know if you need any clarification.

Thanks,
Manojkumar.


Loader.
Live Chat Icon For mobile
Up arrow icon