I want to get all the name collections from a particular sheet name say “test”, all though the workbook has many worksheets. I know the below code will get all the name collection from the workbook. Need only names from single worksheet.
Workbook _SourceWorkbook = new Workbook(path);
NameCollection names= _SourceWorkbook.Worksheets.Names;
Thanks in Advance