How to read single Excel cell value

by

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;

More Related Contents:

  1. How to convert a column number (e.g. 127) into an Excel column (e.g. AA)
  2. How to read data of an Excel file using C#?
  3. A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?
  4. Fastest method to remove Empty rows and Columns From Excel Files using Interop
  5. Closing Excel Application Process in C# after Data Access
  6. unable to cast COM object of type ‘microsoft.Office.Interop.Excel.ApplicationClass’ to ‘microsoft.Office.Interop.Excel.Application'”
  7. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  8. What is the algorithm to convert an Excel Column Letter into its Number?
  9. How to use use late binding to get excel instance?
  10. Cell color changing in Excel using C#
  11. Export DataTable to Excel File
  12. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  13. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  14. How to make correct date format when writing data to Excel
  15. C# – How to copy a single Excel worksheet from one workbook to another?
  16. Importing Excel into a DataTable Quickly
  17. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  18. Accessing Excel Custom Document Properties programmatically
  19. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  20. Query excel sheet in c#
  21. Open XML SDK 2.0 – how to update a cell in a spreadsheet?
  22. Get the Column Index of a Cell in Excel using OpenXML C#
  23. openxml spreadsheat save-as
  24. Printing Excel using Interop
  25. How to import all the Excel sheets to DataSet in C#
  26. Scientific notation when importing from Excel in .Net
  27. Accessing an open Excel Workbook in C#
  28. As of today, what is the right way to work with COM objects? [duplicate]
  29. Import Excel to Datagridview
  30. How to create Excel file using OpenXML without creating a local file?

Leave a Comment