let yourElement = document.getElementById("yourElement");
let wsheet = new websheet('HTML', yourElement,0,0,800,400);
/**
* 第一步 获取激活sheet
*/
let activeSheet = wsheet.ActiveSheet();
/**
* 第二步 币种下拉控件,并注册
*/
const cny = document.createElement('option');
cny.value = 'CNY';
cny.textContent = 'CNY-人民币';
const usd = document.createElement('option');
usd.value = 'USD';
usd.textContent = 'USD-美元';
const eur = document.createElement('option');
eur.value = 'EUR';
eur.textContent = 'EUR-欧元';
let optionsBZ= [cny, usd, eur];
activeSheet.setCellEditor('C3', websheet.Model.SelectCell, {data:optionsBZ,bextend:true});
//setDefineCellType
activeSheet.setCellEditor('C6', websheet.Model.SelectCell, {data:optionsBZ,bextend:true});
/**
* 第三步 重新绘制表格
*/
activeSheet.setColWidth(1, 160);
activeSheet.setColWidth(2, 160);
activeSheet.setColWidth(3, 160);
activeSheet.setColWidth(4, 160);
activeSheet.setColWidth(5, 160);
activeSheet.WorkFormula(); //重建公式
activeSheet.cacl();//公式计算
wsheet.BuildSheet();
wsheet.Draw();