Hello,
I am currently using Infragistics4.WebUI.Documents.Excel (Version 12.2.20122.2202) to load an Excel workbook/spreadsheet in my ASP.NET page and modify certain cells and re-save the spreadsheet. I have been able to accomplish everything I need to so far except for one thing:
The spreadsheet has a list of 4 Option Buttons (Excel > Developer > Insert > Form Controls > Option Button) grouped together. I was wondering if there was a way to programatically set which option is selected/checked before saving the Workbook.
Thank you,
Brian Wortman
Hi Brian,
When you say load the worksheet/workbook into your aspx page, what do you mean? Are you creating the workbook in code? Are you exporting a worksheet from a grid on the page, and upon exporting trying to manipulate and save the page upon exporting? Some other scenario?
Thank you Brian.
I haven't heard from you since my earlier post. Let me know if you need any additional assistance.
I am loading a workbook object in my c# code from a premade file that has a group of Option Buttons already in there and I want to be able to check/select one and then save the workbook back out to the outputstream.
This is an update to let you know that I am researching this issue and will follow-up with you regarding this shortly.
Thanks!
Hi Brian,Currently the Excel Engine does not support manipulating form controls, such as the Options Buttons (Radio Box) in excel. This requires the ability to manipulate forms controls.
This will be a new product idea suggestion. For this we invite you to suggest this as a new product idea.To suggest a new product idea you can do so by navigating to http://ideas.infragistics.com The steps are easy to do:
1. Create a new UserVoice account and log in to the Infragistics Product Ideas site at http://ideas.infragistics.com.
2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)
3. Review the feature suggestions already posted by the community.
4. Vote for the features you’d like to see added to the product.
5. If the feature you’re looking for has not been posted, you can add your own product idea. Make sure to be specific and provide as much detail as possible. Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!
With this system, you are in the driver’s seat by submitting your product ideas. You can even track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Please let me know if you need any additional assistance regarding
Let me know if you needed any additional assistance regarding this inquiry.