How to read single Excel cell value
Try this alternative key :
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();
The above example is used in the Microsoft Excel 15.0 Object Library, but consistent with previous versions of Interop and alternative libraries.
Use this solution to read single Excel cell value :
//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;
Create a cell reference on the same worksheet
1.Click the cell in which you want to enter the formula.
2.In the Formula Bar, type = (equal sign).
3.Do one of the following:
Reference one or more cells : To create a reference, select a cell or range of cells on the same worksheet. Cell references and the borders around the corresponding cells are color-coded to make it easier to work with them.
You can drag the border of the cell selection to move the selection, or drag the corner of the border to expand the selection.
Reference a defined name: To create a reference to a defined name, do one of the following:
Type the name.
Press F3, select the name in the Paste name box, and then click OK.
4.Do one of the following:
If you are creating a reference in a single cell, press Enter.
If you are creating a reference in an array formula (such A1:G4), press Ctrl+Shift+Enter.
The reference can be a single cell or a range of cells, and the array formula can be one that calculates single or multiple results.