Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a dropdownlist programmatically to a ASP.NET webpage
Hello and thanks in advance,
I have an issue that I am trying to work around. I have an aspx page that needs to load up a formated XLS spreadsheet into a DIV tag and then allow the user to input data that will be retrieved later on postback and values store in a MS SQL database. I created an excel spreadsheet and formatted it with the formulas and colors. I also added a combobox from the control toolbox. I also added a checkbox from the control toolbox to another cell. I then saved the page using File--Save AS WebPage. I checked the 'Add Interactively' checkbox on the save dialog. I then opened the file in an editor and copied the object tag into my aspx page. Everything was fine except my combobox and checkbox did not appear in the HTML spreadsheet. I am assuming that I have to EITHER programmatically add the controls prior to render or add the combobox as a XML element to the proper node of the XMLData value parameter attribute. the current XML Block for this node is : <Row ss:AutoFitHeight="0" ss:Height="18.75" <Cell ss:StyleID="s23"<Data ss:Type="String"Fund</Data</Cell <Cell ss:StyleID="s23"/ <Cell ss:StyleID="s23"<Data ss:Type="String"Eng</Data</Cell <Cell ss:StyleID="s24" ss:Formula="=SUM(RC[1]:RC[11])"<Data ss:Type="Number"0</Data</Cell <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ <Cell ss:StyleID="s25"/ </Row The second cell, between FUND and ENG is where I need to add the combobox. Does anyone have a clean way of doing this? also how about binding data to this control. This data is coming from SQL DB, and not from a range in the activesheet. Thanks in advance NaderH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmatically adding code to worksheet | Excel Programming | |||
Programmatically Adding Code to a Workbook | Excel Programming | |||
Adding to AutoComplete programmatically | Excel Programming | |||
Adding comment programmatically | Excel Programming | |||
Adding Checkboxes Programmatically | Excel Programming |