Thanks for providing us some details.
I think you are mixing the things. First of all, when you do process the code:
Style style = sheet2.Cells[“A1”].GetStyle();
style.Name = “Album Id Number”;
it will instantiate a Style object (which you can only use to apply formattings) and set its name. It won’t create a named cell/range with the heading/title whatsoever. When you import your custom object to the worksheet cells, it won’t do anything or have any links with your style.
We recommend you to kindly go through the following document/ article completely on Named Ranges for your reference:
Using Named Ranges
Hope, this helps a bit.