Syncfusion.XlsIO.Base
Properties  Methods 

Syncfusion.XlsIO Namespace : IWorksheetGroup Interface

IWorksheetGroup Interface Members

The following tables list the members exposed by IWorksheetGroup.

Public Properties
 NameDescription
 Property Gets or sets index of the active pane. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets the application object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Gets the auto filters collection in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 PropertyGets or sets the a CalcEngine object associated with Syncfusion.Calculate.ICalcData implementation. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets the used cells in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets a charts collection in the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 PropertyGets the ICheckBoxes collection with all ICheckBoxShape inside the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets the name used by macros to access workbook items. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets a Range object that represents all the columns in the specified worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 PropertyGets the IComboBoxes collection with all IComboBoxShape inside the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 PropertyGets the IComments collection in the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Number of selected worksheets.  
 Property Gets a collection of custom properties of the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets the DataSorter. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the first visible column index. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the first visible row index. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the color of the Grid line in the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets whether the OLE object is present in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the position of horizontal split in the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 PropertyGets a Syncfusion.XlsIO.Implementation.Collections.HPageBreaksCollection that represents the horizontal page breaks in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets a hyperlink collections in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets the index number of the worksheet within the collection of worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property True if zero values to be displayed. otherwise, False. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Indicates whether collection is empty. Read-only.  
 Property Defines whether freezed panes are applied. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property True if grid lines are visible. otherwise, False. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets a Boolean value indicating whether sheet is protected with a password. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets or sets a Boolean value indicating whether sheet is displayed right to left. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property True if row and column headers are visible. otherwise, False. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets a Boolean value indicating whether tab of the sheet is selected. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property True if all values in the worksheet are preserved as strings. otherwise, False. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Returns single entry from the collection. Read-only.  
 Property Gets or sets the left visible column of the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets a collection of list objects in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets all the merged ranges in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the name of the sheet. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets a Names collection that represents the worksheet-specific names (names defined with the "WorksheetName!" prefix) in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 PropertyGets IOleObjects collection in the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 PropertyGets the IOptionButtons collection with all IOptionButtonShape inside the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 PropertyGets a PageSetup object that contains all the page setup settings for the specified object. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets the parent object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 PropertyGets the IPictures collection in the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets a collection of pivot tables in the worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets a Boolean value indicating whether content in the sheet is protected. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets a Boolean value indicating whether drawing objects in the sheet is protected. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets protected options. Read-only. For sets protection options use "Protect" method. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets a Boolean value indicating whether scenarios in the sheet is protected. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets a Range object that represents a cell or a range of cells in the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets a Range object that represents the rows in the specified worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 PropertyGets the IShapes collection in the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets the sparkline groups. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets split cell range. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the standard (default) height of all the rows in the worksheet, in points. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the standard (default) height option flag. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the standard (default) width of all the columns in the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the tab color of the sheet. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets or sets the tab color RGB of the sheet. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets the index number of the sheet within the tabsheets collection. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 PropertyGets a ITextBoxes collection with all ITextBoxShape inside the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets or sets the top visible row of the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets the worksheet type. Read-only ExcelSheetType. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets all not empty or accessed cells. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets a Range object that represents the used range on the specified worksheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets whether used range should include cells with formatting. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Indicates whether all created range objects should be cached or not. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the position of vertical split in the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the view setting of the worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets or sets the control visibility of sheet to end user. (Inherited from Syncfusion.XlsIO.ITabSheet)
 PropertyGets a Syncfusion.XlsIO.Implementation.Collections.VPageBreaksCollection that represents the vertical page breaks on the sheet. Read-only. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Property Gets the parent workbook of the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets or sets the value that represents zoom factor of document. Value must be in range from 10 till 400. (Inherited from Syncfusion.XlsIO.IWorksheet)
Top
Public Methods
 NameDescription
 Method Activates the sheet which is equivalent to clicking the sheet's tab. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Method Adds new worksheet to the collection.  
 Method Filters or copies data from a list based on a criteria range.. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Changes the width of the specified column to achieve the best fit. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Changes the height of the specified row to achieve the best fit. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Calculate all the formulas in worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Clears the worksheet data, formats and merged cells. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Clears the worksheet data. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Converts the specified column width from points to pixels. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Checks whether the specified cell is initialized or accessed. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Converts the specified range into image. Default image type is Bitmap. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Copies worksheet data to the clipboard. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Creates a named ranges with the specified named range's value as a name for the specified range. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodCreates a new instance of the IRanges. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodCreate an instance of ITemplateMarkersProcessor that can be used for template markers processing. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Removes the specified column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Removes the specified row. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodDisables the calculation support in this workbook and disposes of the associative CalcEngine objects. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Enables the calculation support. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodExports worksheet data into the List of CLR Objects. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodExports worksheet data in the specified row and column into a System.Data.DataTable. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodReturns the cells of the specified string value with the specified ExcelFindType. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodReturns the first occurrence of the specified string value with the specified ExcelFindType. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns the first occurrence that ends with the specified string value. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns the first occurrence that starts with the specified string value. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Frees range object. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns bool value from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns the width of the specified column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns the width of the specified column in pixels. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns the default column style for the specified column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns default row style for the specified row. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns error value from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns formula value from specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns formula bool value from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns formula error value from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns formula number value from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns formula string value from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns number value from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns the height of the specified row. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns the height of the specified row in pixels. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns string value from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Hides the specified column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Hides the specified row. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodImports an array of System.Object into a worksheet with specified alignment. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Imports data from class objects into a worksheet with specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodImports data from a System.Data.DataColumn into a worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodImports data from Microsoft System.Windows.Forms.DataGrid into worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodImports data from Microsoft System.Windows.Forms.DataGridView into worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodImports data from System.Data.IDataReader into worksheet from the specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodImports data from a System.Data.DataTable into a worksheet with specified row and column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodImports data from a System.Data.DataView into a worksheet with specified row, column and preserve type. (Inherited from Syncfusion.XlsIO.IWorksheet)
 MethodImports data from Microsoft System.Web.UI.WebControls.GridView into worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Inserts an empty column for the specified column index. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Inserts an empty row in the specified row index. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Intersects two ranges. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns True if the specified column is visible to end user. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Returns True if the specified row is visible to end user. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Merges two ranges. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Moves worksheet to the specified index. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Converts the specified column width from pixels to points. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Protects a sheet with specified password so that it cannot be modified. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Method Removes worksheet from parent worksheet collection. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Removes panes from a worksheet. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Replaces string with the specified string value. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Saves worksheet with specified file name using separator. Used only for CSV files. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Saves worksheet with specified filename. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Selects the tab sheet. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Method Blanks the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets boolean value for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets column width for the specified column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets column width in pixels for the specified column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets the default column style for the specified column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets the default row style for the specified row. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets error for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets formula for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets formula bool value for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets formula error value for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets formula number value for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets formula string value for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets number for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets row height for the specified row. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets row height in pixels for the specified row. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets text for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Sets value for the specified cell. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Shows the specified column. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Shows or Hides the specified range. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Shows or Hides the specified row. (Inherited from Syncfusion.XlsIO.IWorksheet)
 Method Removes protection from a sheet. This method has no effect if the sheet or workbook isn't protected. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Method Removes the selection from the sheet. (Inherited from Syncfusion.XlsIO.ITabSheet)
Top
See Also