how to get range of inactive sheets in excel in C# -
in microsoft.office.interop.excel.worksheet, want range of inactive sheet, there way create new object of inactive sheet? can range of active sheet using excel.application.activesheet. thanks
here's simple approach :
var wb = excel.application.activeworkbook; list<worksheet> sheets = new list<worksheet(); foreach(var sheet in wb.sheets) { if(sheet != excel.application.activesheet) { sheets.add(sheet); } }
Comments
Post a Comment