C#和互操作性的一个问题 [英] C# and interop one problem

问题描述

大家好，
我有datagridview(dgvProducts)，我想使用此代码将其插入到xls文件网格数据中，每个范围都可以正常工作，但是当我单击此按钮时，rangeProductsName没有任何作用
有人可以帮我吗?

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]);
    }

即时通讯使用C#
谢谢

im using c#
Thanks

推荐答案

您好
在这里看看
http://www.codeproject.com/KB/grid/ExportDatagridviewToExcel.aspx [ ^ ]

http://www.sourcecodester.com/visual-basic-net/export-datagridview- excel.htm [ ^ ]

http://csharp.net-informations.com/excel/csharp-excel-datagridview [ ^ ]

Hi
Have a look here
http://www.codeproject.com/KB/grid/ExportDatagridviewToExcel.aspx[^]

http://www.sourcecodester.com/visual-basic-net/export-datagridview-excel.htm[^]

http://csharp.net-informations.com/excel/csharp-excel-datagridview[^]

这篇关于C#和互操作性的一个问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！