Is there a way to retrieve the codename of an Excel sheet in C#?

Asked Jul 24 '22 at 23:20

Active Jul 25 '22 at 18:12

Viewed 51 times

I'm working with a template where sheet names might change, but codenames will not. Is there a way to retrieve the codename of an Excel sheet in C#?

shCodeName = SH_parent.CodeName; does not seem to work, although shName = SH_parent.Name; works just fine

//Definition of SH_parent Excel.Worksheet SH_parent;

//Loading SH_parent

            foreach (Excel.Name N in WB.Names)
            {
                if (!N.Name.Contains("!"))
                {
                    //GLOBAL
                    string SH_Name = N.RefersTo.ToString().Split('!')[0].Replace("=", "").Replace("'", "");
                    SH_parent= WB.Worksheets[SH_Name];
                }
                else
                {
                    //SHEET
                    SH_parent = N.Parent;
                }

edited Jul 25 '22 at 18:12

Eugene Astafiev

47,483
3
24
45

asked Jul 24 '22 at 23:20

Dumitru Daniel

msdn seems to say yes - https://learn.microsoft.com/en-us/office/vba/api/excel.worksheet.codename – Rand Random Jul 24 '22 at 23:28
Is SH_parent a worksheet object? are you getting an error? – Rand Random Jul 24 '22 at 23:29
or here seems to work aswell https://stackoverflow.com/questions/41477794/refer-to-sheet-using-codename – Rand Random Jul 24 '22 at 23:30
for VB it does work, but i'm looking for a C# alternative. SH_parent is an Excel.Worksheet object. I will update how I load it in the main question. – Dumitru Daniel Jul 25 '22 at 09:31

Is there a way to retrieve the codename of an Excel sheet in C#?

0 Answers0