How does one select an entire worksheet with Spreadsheet gear (.NET)

Question

I am using the Spreadsheet gear component and need to select all cells in a worksheet so I can apply a consistent font setting across. How do you create an IRange that represents an entire worksheet?

score 2 · Accepted Answer · answered May 09 '13 at 19:58

2

IWorksheet.Cells represents all cells in a worksheet:

workbook.Worksheets["Sheet1"].Cells.Font.Color = SpreadsheetGear.Colors.Yellow;

answered May 09 '13 at 19:58

Tim Andersen

3,014
1
15
11

Right, duh. Should have realized Cells is an IRange as well. – John Livermore May 10 '13 at 17:37

How does one select an entire worksheet with Spreadsheet gear (.NET)

1 Answers1