如何设置下拉列表选中某个值

收藏

我如果通过代码，设置下拉列表选中某个值

qsban · qsban

var combo = new spreadNS.ComboBoxCellType();
combo.items([{ text: "Oranges", value: "11k" }, { text: "Apples", value: "15k" }, { text: "Grape", value: "100k" }]);
combo.editorValueType(spreadNS.EditorValueType.Text);
sheet.getCell(3, 2, spreadNS.SheetArea.viewport).cellType(combo).value("Grape");
sheet.setValue(3, 1, "ComboBoxCellType");

查看http://demo.gcpowertools.com.cn/ ... mples/basicCellType