Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Comment read single Excel cell value

ayi

I have excel file with sheet1 that has a value I need to read on row 2 and column 10. 
Here is my code.
<pre><code class="lang-auto">Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
Excel.Sheets excelSheets = excelWorkbook.Worksheets;
string currentSheet = "Sheet1";
Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);
var cell = (Excel.Range)excelWorksheet.Cells[10, 2];

</code></pre>
After getting cell object which is Excel.Range, I do not know how to read the content of that cell. I tried converting it into array and looping over it and I tried converting to string array etc. I am sure it is very simple. Is there a direct way to get just one cell value that is string?

ayi_2

You need to cast it to a string (not an array of string) since it’s a single value.
<pre><code class="lang-auto">var cellValue = (string)(excelWorksheet.Cells[10, 2] as Excel.Range).Value;

</code></pre>