ExcelJS: how to get active Sheet


exceljs

How to get active Sheet

Get position of active Sheet:
var active =workbook.Workbook.WBView[0]? workbook.Workbook.WBView[0].activeTab : 0

Get Sheet name of active Sheet:
var activeSheetName = workbook.SheetNames[active]

Get Active Sheet:
var activeSheet = workbook.Sheets[activeSheetName]

Leave a Reply