How to read single Excel cell value

Question

I have excel file with sheet1 that has a value I need to read on row 2 and column 10  Here is my code    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     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

User · Answer

It is better to use  Value2   instead of  Value    This is faster and gives the exact value in the cell  For certain type of data  truncation can be observed when  Value   is used

User · Answer

You need to cast it to a string  not an array of string  since it s a single value   var cellValue    string  excelWorksheet Cells 10  2  as Excel Range  Value

User · Answer

THIS IS WORKING CODE                          Microsoft Office Interop Excel Range Range Number r2   Range Number   wsheet UsedRange Find  smth     string f number       r2   wsheet Cells    int n c   Range Number Column   int n r   Range Number Row   var number     Range r2 n r   1  n c   Value    f number    string number

User · Answer

Here s a solution that may work better in the case you are referencing objWorksheet UsedRange   Excel Worksheet mySheet       load a workbook  etc   Excel Range myRange   mySheet UsedRange  var values    myRange Value as Object      int rowNumber   3  columnNumber   5  string cellValue   Convert ToString values rowNumber  columnNumber

User · Answer

Please try this  Maybe this could help you  It works for me   string sValue    range Cells  row   column  as Microsoft Office Interop Excel Range  Value2 ToString       row  column your column  amp  row number    eg  string sValue    sheet Cells i   9  12  as Microsoft Office Interop Excel Range  Value2 ToString      sValue has your value

User · Answer

using Microsoft Office Interop Excel   string path    C   Projects  ExcelSingleValue  Test xlsx     Application excel   new Application    Workbook wb   excel Workbooks Open path   Worksheet excelSheet   wb ActiveSheet     Read the first cell string test   excelSheet Cells 1  1  Value ToString     wb Close      This example used the  Microsoft Excel 15 0 Object Library  but may be compatible with earlier versions of Interop and other libraries

User · Answer

The issue with reading single Excel Cell in  Net comes from the fact  that the empty cell is evaluated to a Null  Thus  one cannot use its  Value or  Value2 properties  because an error shows up   To return an empty string  when the cell is Null the Convert ToString Cell  can be used in the following way   Excel Workbook wkb   Open excel  filePath   Excel Worksheet wk    Excel Worksheet excel Worksheets get Item 1    for  int i   1  i  lt  5  i          string a   Convert ToString wk Cells i  1  Value2       Console WriteLine a

[c#] How to read single Excel cell value

Examples related to c#

Examples related to excel