SpreadsheetGear 2009 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 colors, cell comments, 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.