用C＃逐个读取EXCEL单元格内容

来源：互联网发布：淘宝永久封号怎么解封编辑：程序博客网时间：2024/05/20 16:10

用C＃逐个读取EXCEL单元格内容

Microsoft.Office.Interop.Excel.Application xApp = new Microsoft.Office.Interop.Excel.ApplicationClass();

            Microsoft.Office.Interop.Excel.Workbook xBook1 = xApp.Workbooks._Open(this.textBox1.Text,
                Missing.Value, Missing.Value, Missing.Value, Missing.Value
                , Missing.Value, Missing.Value, Missing.Value, Missing.Value
                , Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            Microsoft.Office.Interop.Excel.Worksheet xSheet1;
            Microsoft.Office.Interop.Excel.Range xRange1;
            xSheet1 = (Microsoft.Office.Interop.Excel.Worksheet)xBook1.Sheets[1];

            for (int row = 1; row <= 300; row++)
            {
                xRange1 = xSheet1.get_Range(string.For
                xRange1 = xSheet1.get_Range(string.Format("A{0}", row), string.Format("G{0}", row));

}

            xSheet1 = null;
            xBook1 = null;
            xApp.Quit();
            xApp = null;