SpreadsheetGear 2023
Workbooks, Worksheets and Ranges
SpreadsheetGear 2023 > Tutorials > Key Concepts > Workbooks, Worksheets and Ranges

SpreadsheetGear 2023 workbooks consist of a set of worksheets, and sometimes chart sheets or other special sheets. Use the IRange Interface to access and modify worksheet cells including values, formulas, number formats, fonts, borders, background colorscell comments, autofilters, sorting, data validation, conditional formats, hyperlinks and much more.

Open existing workbooks with GetWorkbook, Open, OpenFromMemory or OpenFromStream.

Create new empty workbooks with GetWorkbook or Add.

Save workbooks to a file, memory or stream with SaveAs, SaveToMemory or SaveToStream.

Copy ranges of cells with IRange.Copy and copy entire worksheets with ISheet.CopyAfter or ISheet.CopyBefore.

Remove workbooks from a workbook set with Close.