How do I get an Excel range using row and column numbers in VSTO / C#?

by

Where the range is multiple cells:

Excel.Worksheet sheet = workbook.ActiveSheet;
Excel.Range rng = (Excel.Range) sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[3,3]);

Where range is one cell:

Excel.Worksheet sheet = workbook.ActiveSheet;
Excel.Range rng = (Excel.Range) sheet.Cells[1, 1];

More Related Contents:

  1. Excel Interop – Efficiency and performance
  2. Fastest way to interface between live (unsaved) Excel data and C# objects
  3. How to open an Excel file in C#?
  4. How to reference Microsoft.Office.Interop.Excel dll?
  5. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  6. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  7. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  8. How to know if a cell has an error in the formula in C#
  9. Excel CustomTaskPane with WebBrowser control – keyboard/focus issues
  10. Reading Excel files from C#
  11. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  12. Write Array to Excel Range
  13. How to read data of an Excel file using C#?
  14. Using Excel OleDb to get sheet names IN SHEET ORDER
  15. export to Excel from a list with EPPLUS
  16. Import and Export Excel – What is the best library? [closed]
  17. Exception from HRESULT: 0x800A03EC Error
  18. Fastest method to remove Empty rows and Columns From Excel Files using Interop
  19. unable to cast COM object of type ‘microsoft.Office.Interop.Excel.ApplicationClass’ to ‘microsoft.Office.Interop.Excel.Application'”
  20. How to export a JQgrid data to Excel using c#?
  21. How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
  22. Is there any simple way to convert .xls file to .csv file? (Excel)
  23. Export DataTable to Excel with Open Xml SDK in c#
  24. Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’
  25. Microsoft.Office.Interop.Excel really slow
  26. The quest for the Excel custom function tooltip
  27. How to save workbook without showing save dialog with Excel interop?
  28. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  29. Cell styles in OpenXML spreadsheet (SpreadsheetML)
  30. Exception (HRESULT: 0x800AC472) when using Excel.Worksheet.Select after calling Excel.Workbook.SaveAs

Leave a Comment