用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);
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];
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));
{
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;