1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
Microsoft.Office.Interop.Excel.Application excelApplication = null;
Microsoft.Office.Interop.Excel.Workbook workbook = null;
Microsoft.Office.Interop.Excel.Worksheet worksheet = null;
excelApplication = new Microsoft.Office.Interop.Excel.Application();
excelApplication.Visible = false;
workbook = excelApplication.Workbooks.Open(@"D:\Après\mailing_RA_20090219.xls", 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[2];
excelApplication.Quit();
excelApplication = null;
string cellValue = "";
object cellObject = null;
Microsoft.Office.Interop.Excel.Range range = null;
range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[3,2];
cellObject = range.get_Value(null);
cellValue = (cellObject == null ? "" : cellObject.ToString().Trim());
Console.WriteLine(cellValue); |
Partager