| |
| let yourElement = document.getElementById("yourElement"); |
| let wsheet = new websheet('HTML', yourElement,0,0,800,400); |
| |
| |
| |
| |
| |
| |
| let workbook = wsheet.Workbook(); |
| |
| |
| |
| |
| 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(); |
| |