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

Question

I believe the query captures it. How do I acquire a range object for that range given two integers for row and column or four integers for row and column for the two corners of a range?

Answer 1

Use:

int countRows = xlWorkSheetData.UsedRange.Rows.Count;
int countColumns = xlWorkSheetData.UsedRange.Columns.Count;
object[,] data = xlWorkSheetData.Range[xlWorkSheetData.Cells[1, 1], xlWorkSheetData.Cells[countRows, countColumns]].Cells.Value2;