Programmatically set Excel row properties using the Excel Interop
Posted on 2013-02-06
We have an Excel spreadsheet that is populated from data in a database using a program we developed in C# .
Everything works fine but now we need to be able to store a key identifier (that we format and create) for each row.
Is there a way to apply this key "value" to a property at the row level so the users do not see our key value anywhere in the spreadsheet? or via some other method?
We want to avoid using a hidden column since there is a chance the user could make the column visible, thus potentially changing this key value.