复制

    let yourElement = document.getElementById("yourElement");
    let wsheet = new websheet('HTML', yourElement,0,0,800,400);

  
    /**
    * 第一步 获取激活sheet
    */
 
 
    let activeSheet = wsheet.ActiveSheet();
  
  activeSheet.SetCellValue('A3','默认日期');
  activeSheet.SetCellValue('A4','日期多选');
  activeSheet.SetCellValue('A5','时间选择'); 
  activeSheet.SetCellValue('A6','日期时间');  
  activeSheet.SetCellValue('A7','月份');  
  
 /**
  * 第二步 一个下自定义币种下拉控件，并注册
  */
 
  activeSheet.SetCellValue('B3','2025-02-28');
 
  activeSheet.setCellEditor('B3', websheet.Model.DatePickCell);
 
 
  /**
  * 多日期选择
  */
  activeSheet.setCellEditor('B4', websheet.Model.DatePickCell, {
   mode: "multiple",
   dateFormat: "Y-m-d"
 });
 
 
 /**
 * 24小时
 */
 activeSheet.setCellEditor('B5', websheet.Model.DatePickCell, {
   enableTime: true,
   noCalendar: true,
   dateFormat: "H:i",
   time_24hr: true
 });
 
 /**
 * 24小时
 */
 activeSheet.setCellEditor('B6', websheet.Model.DatePickCell, {
   enableTime: true,
   dateFormat: "Y-m-d H:i"
 });
 
 
 /**
 * 月份
 */
 activeSheet.setCellEditor('B7', websheet.Model.DatePickCell, {
   dateFormat: "Y-m", // 仅显示月份
   locale: websheet.Model.Mandarin,
   //defaultDate: '2024-01' //  
 });
 
 
 /**
   * 第三步   重新绘制表格
   */
 activeSheet.setColWidth(1, 160);
 activeSheet.setColWidth(2, 260);
 activeSheet.setColWidth(3, 160);
 activeSheet.setColWidth(4, 160);
 activeSheet.setColWidth(5, 160);
 activeSheet.WorkFormula(); //重建公式
 activeSheet.cacl();//公式计算
 
 wsheet.BuildSheet();
 wsheet.Draw();