Syncfusion.XlsIO.Base
Properties  Methods  Events

Syncfusion.XlsIO Namespace : IWorksheet Interface

IWorksheet Interface Members

The following tables list the members exposed by IWorksheet.

Public Properties
 NameDescription
 Property Gets or sets index of the active pane.  
 Property Gets the application object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Gets the auto filters collection in the worksheet. Read-only.  
 PropertyGets or sets the a CalcEngine object associated with Syncfusion.Calculate.ICalcData implementation.  
 Property Gets the used cells in the worksheet. Read-only.  
 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.  
 PropertyGets the IComboBoxes collection with all IComboBoxShape inside the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 PropertyGets the IComments collection in the worksheet.  
 Property Gets a collection of custom properties of the worksheet. Read-only.  
 Property Gets the DataSorter.  
 Property Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed.  
 Property Gets or sets the first visible column index.  
 Property Gets or sets the first visible row index.  
 Property Gets or sets the color of the Grid line in the worksheet.  
 Property Gets whether the OLE object is present in the worksheet. Read-only.  
 Property Gets or sets the position of horizontal split in the worksheet.  
 PropertyGets a Syncfusion.XlsIO.Implementation.Collections.HPageBreaksCollection that represents the horizontal page breaks in the worksheet. Read-only.  
 Property Gets a hyperlink collections in the worksheet. Read-only.  
 Property Gets the index number of the worksheet within the collection of worksheet. Read-only.  
 Property True if zero values to be displayed. otherwise, False.  
 Property Defines whether freezed panes are applied.  
 Property True if grid lines are visible. otherwise, False.  
 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.  
 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.  
 PropertyOverloaded.  Gets or sets cell range by row and column index. Row and column indexes are one-based.  
 Property Gets or sets the left visible column of the worksheet.  
 Property Gets a collection of list objects in the worksheet. Read-only.  
 Property Gets all the merged ranges in the worksheet. Read-only.  
 Property  
 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.  
 PropertyGets IOleObjects collection in the worksheet.  
 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.  
 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.  
 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.  
 Property Gets a Range object that represents the rows in the specified worksheet. Read-only.  
 PropertyGets the IShapes collection in the sheet. Read-only. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Property Gets the sparkline groups.  
 Property Gets split cell range.  
 Property Gets or sets the standard (default) height of all the rows in the worksheet, in points.  
 Property Gets or sets the standard (default) height option flag.  
 Property Gets or sets the standard (default) width of all the columns in the worksheet.  
 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.  
 Property Gets the worksheet type. Read-only ExcelSheetType.  
 Property Gets all not empty or accessed cells. Read-only.  
 Property Gets a Range object that represents the used range on the specified worksheet. Read-only.  
 Property Gets or sets whether used range should include cells with formatting.  
 Property Indicates whether all created range objects should be cached or not.  
 Property Gets or sets the position of vertical split in the worksheet.  
 Property Gets or sets the view setting of the worksheet.  
 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.  
 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.  
Top
Public Methods
 NameDescription
 Method Activates the sheet which is equivalent to clicking the sheet's tab. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Method Filters or copies data from a list based on a criteria range..  
 Method Changes the width of the specified column to achieve the best fit.  
 Method Changes the height of the specified row to achieve the best fit.  
 Method Calculate all the formulas in worksheet.  
 Method Clears the worksheet data, formats and merged cells.  
 Method Clears the worksheet data.  
 Method Converts the specified column width from points to pixels.  
 Method Checks whether the specified cell is initialized or accessed.  
 MethodOverloaded.  Converts the specified range into image. Default image type is Bitmap.  
 Method Copies worksheet data to the clipboard.  
 Method Creates a named ranges with the specified named range's value as a name for the specified range.  
 MethodCreates a new instance of the IRanges.  
 MethodCreate an instance of ITemplateMarkersProcessor that can be used for template markers processing.  
 MethodOverloaded.  Removes the specified column.  
 MethodOverloaded.  Removes the specified row.  
 MethodDisables the calculation support in this workbook and disposes of the associative CalcEngine objects.  
 Method Enables the calculation support.  
 MethodExports worksheet data into the List of CLR Objects.  
 MethodOverloaded. Exports worksheet data in the specified row and column into a System.Data.DataTable.  
 MethodOverloaded. Returns the cells of the specified string value with the specified ExcelFindType.  
 MethodOverloaded. Returns the first occurrence of the specified string value with the specified ExcelFindType.  
 MethodOverloaded.  Returns the first occurrence that ends with the specified string value.  
 MethodOverloaded.  Returns the first occurrence that starts with the specified string value.  
 MethodOverloaded.  Frees range object.  
 Method Returns bool value from the specified row and column.  
 Method Returns the width of the specified column.  
 Method Returns the width of the specified column in pixels.  
 Method Returns the default column style for the specified column.  
 Method Returns default row style for the specified row.  
 Method Returns error value from the specified row and column.  
 Method Returns formula value from specified row and column.  
 Method Returns formula bool value from the specified row and column.  
 Method Returns formula error value from the specified row and column.  
 Method Returns formula number value from the specified row and column.  
 Method Returns formula string value from the specified row and column.  
 Method Returns number value from the specified row and column.  
 Method Returns the height of the specified row.  
 Method Returns the height of the specified row in pixels.  
 Method Returns string value from the specified row and column.  
 Method Hides the specified column.  
 Method Hides the specified row.  
 MethodOverloaded. Imports an array of System.Object into a worksheet with specified alignment.  
 Method Imports data from class objects into a worksheet with specified row and column.  
 MethodImports data from a System.Data.DataColumn into a worksheet.  
 MethodImports data from Microsoft System.Windows.Forms.DataGrid into worksheet.  
 MethodImports data from Microsoft System.Windows.Forms.DataGridView into worksheet.  
 MethodOverloaded. Imports data from System.Data.IDataReader into worksheet from the specified row and column.  
 MethodOverloaded. Imports data from a System.Data.DataTable into a worksheet with specified row and column.  
 MethodOverloaded. Imports data from a System.Data.DataView into a worksheet with specified row, column and preserve type.  
 MethodImports data from Microsoft System.Web.UI.WebControls.GridView into worksheet.  
 MethodOverloaded.  Inserts an empty column for the specified column index.  
 MethodOverloaded.  Inserts an empty row in the specified row index.  
 Method Intersects two ranges.  
 Method Returns True if the specified column is visible to end user.  
 Method Returns True if the specified row is visible to end user.  
 Method Merges two ranges.  
 Method Moves worksheet to the specified index.  
 Method Converts the specified column width from pixels to points.  
 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.  
 Method Removes panes from a worksheet.  
 MethodOverloaded.  Replaces string with the specified string value.  
 MethodOverloaded.  Saves worksheet with specified file name using separator. Used only for CSV files.  
 MethodOverloaded.  Saves worksheet with specified filename.  
 Method Selects the tab sheet. (Inherited from Syncfusion.XlsIO.ITabSheet)
 Method Blanks the specified cell.  
 Method Sets boolean value for the specified cell.  
 Method Sets column width for the specified column.  
 MethodOverloaded.  Sets column width in pixels for the specified column.  
 MethodOverloaded.  Sets the default column style for the specified column.  
 MethodOverloaded.  Sets the default row style for the specified row.  
 Method Sets error for the specified cell.  
 Method Sets formula for the specified cell.  
 Method Sets formula bool value for the specified cell.  
 Method Sets formula error value for the specified cell.  
 Method Sets formula number value for the specified cell.  
 Method Sets formula string value for the specified cell.  
 Method Sets number for the specified cell.  
 Method Sets row height for the specified row.  
 MethodOverloaded.  Sets row height in pixels for the specified row.  
 Method Sets text for the specified cell.  
 Method Sets value for the specified cell.  
 Method Shows the specified column.  
 MethodOverloaded.  Shows or Hides the specified range.  
 Method Shows or Hides the specified row.  
 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
Public Events
 NameDescription
 Event Occurs when the value of a cell changes.  
 Event Event raised when an unknown function is encountered.  
Top
See Also