If you want to interact directly with an Excel based application or use Excel to store test data and results, it's useful to be able to find cells by name rather than by cell coordinates. 


function SetCellValueInExcel
    (TestWorkbook, TestSheet, TestField, TestValue)
{
    var MSexcel;
    MSexcel = Sys.OleObject("excel.application");
    MSexcel.Visible = true;
    MSexcel.Workbooks.Open(TestWorkbook);
    MSexcel.Workbooks(TestWorkbook).Activate();
    MSexcel.Worksheets(TestSheet).Activate();
    //For ActiveX objects in the sheet, check for CheckBox
    //and ComboBox names (use Design mode
    //in Excel to see the names)
    if (TestField.indexOf("CheckBox") > -1)
    {
        MSexcel["ActiveSheet"][TestField]["Object"]["Value"]
            = true;
        MSexcel["ActiveSheet"][TestField]["Value"]
            = TestValue;
    }
    else
    {
        if (TestField.indexOf("ComboBox") > -1)
        {
            MSexcel["ActiveSheet"][TestField]["Value"]
                = TestValue;
        }
        else 
        //Named cell
        {
            MSexcel.Names(TestField).RefersToRange.Value2
                = TestValue;
        }
    }
}

SetCellValueInExcel

sets the named cell "TestField" to "TestValue" in workbook "TestWorkbook", sheet "TestSheet". Yes, you could just use the .Cells(row, col) method but where's the fun in that? Besides, you just know someday someone will move the cell without telling you.

Note the switch from dot notation to brackets to show how either can be used in c#script - using brackets allows you to use variable names to refer to objects. Just remember, when a variable name is in [brackets] it is evaluated as an object and when it's in (braces) it's a parameter - and have fun debugging your scripts!