C# and interop one problem

See more:

C#

WinForms

MS-Excel

DataGridView

, +

Hi guys,
I have datagridview (dgvProducts) I want to insert into xls file grid data with this code every range works fine but when i click this button rangeProductsName does not make anything
can anybody help me ?

private void btnExportInExcel_Click(object sender, EventArgs e)
{
     nudZednadebNumber.Value++;
    //string address = txtFileAddress.Text;
    string address = txtFileAddress.Text;
    OpenExcelWorkbook(address);
    _sheet = (Excel.Worksheet)_sheets[1];
    _sheet.Select(Type.Missing);

    Excel.Range rangeCompanyName = _sheet.get_Range("U9", Type.Missing);
    Excel.Range rangeAddress = _sheet.get_Range("U12", Type.Missing);
    Excel.Range rangeSCode = _sheet.get_Range("Z7, AJ7", Type.Missing);
    Excel.Range rangeCash = _sheet.get_Range("X51, Y51", Type.Missing);
    Excel.Range rangeBankTransfare = _sheet.get_Range("Z51, AA51", Type.Missing);
    Excel.Range rangeConsignation = _sheet.get_Range("AB51, AC51", Type.Missing);
    Excel.Range rangeDateTimeDay = _sheet.get_Range("O4, P4", Type.Missing);
    Excel.Range rangeDateTimeYear = _sheet.get_Range("V4, W4", Type.Missing);
    Excel.Range rangeZednadebNumber = _sheet.get_Range("W2, Y2", Type.Missing);
    Excel.Range rangeProductNames = _sheet.get_Range("A27, A45", Type.Missing);


    string[] proNames = new string[18];


    for (int i = 0; i < dgvProducts.Rows.Count; i++)
    {
        proNames[i] = dgvProducts.Rows[i].Cells["cProductName"].Value.ToString();
        rangeProductNames.set_Value(Type.Missing, proNames[i]);
    }

im using c#
Thanks