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

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

java - Could not locate OpenAL library -

sorting - opencl Bitonic sort with 64 bits keys -