- Excel._Application excelApp = new Excel.Application();
- object objOpt = System.Reflection.Missing.Value;
- Excel.Workbook workbook = excelApp.Workbooks.Open(dlg.FileName, objOpt, false, objOpt, objOpt, objOpt,
- true, objOpt, objOpt, true, objOpt, objOpt, objOpt, objOpt, objOpt);
- Excel.Worksheet memberSheet = workbook.Sheets[1];
- Excel.Worksheet jointSheet = workbook.Sheets[2];
- int nCollum = jointSheet.UsedRange.Columns.Count;
- int nRow = jointSheet.UsedRange.Rows.Count;
- Excel.Range cells = jointSheet.Cells;
- for (int ii = 1; ii < nRow; ++ii)
- {
- Excel.Range range = cells[ii, 1];
- String strName = range.Text;
- if (strName.Length == 0)
- break;
- }
- //该片段来自于http://www.codesnippet.cn/detail/1311201513986.html
来源: http://www.codesnippet.cn/detail/1311201513986.html