let yourElement = document.getElementById("yourElement");
let wsheet = new websheet('HTML', yourElement,0,0,800,400);
/**
* 第一步 获取workbook
*/
let workbook = wsheet.Workbook();
/**
* 第二步 利用workbook增加sheet对象
*/
let newSheet = workbook.WorkSheetAdd();
let newTestSheet = workbook.WorkSheetAdd('newTestSheet');
if (newTestSheet != null && newSheet != null) {
newTestSheet.SetCellValue(1, 1, 'this is new TestSheet');
newTestSheet.setColWidth(1, 160);
newSheet.SetCellValue(1, 1, 'this is sheet2');;
newSheet.setColWidth(1, 160);
workbook.SetActiveSheet(newSheet.name);
let worksheets = workbook.GetWorkSheet();
for (let n = 0; n < worksheets.length; n++) {
const worksheet = worksheets[n];
console.log(worksheet.name);
}
workbook.DelWorkSheet('sheet1');
worksheets = workbook.GetWorkSheet();
for (let n = 0; n < worksheets.length; n++) {
const worksheet = worksheets[n];
console.log(worksheet.name);
}
}
/**
* 第三步 重新绘制表格
*/
wsheet.BuildSheet();
wsheet.Draw();