Click or drag to resize

ExcelWorksheet Class

Excel Worksheet
Inheritance Hierarchy
SystemObject
  ExpertXls.ExcelLibExcelWorksheet

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
public class ExcelWorksheet

The ExcelWorksheet type exposes the following members.

Properties
  NameDescription
Public propertyCharts
Gets the charts collection of this worksheet.
Public propertyComments
Gets the comments collection of this worksheet.
Public propertyHorizontalPageBreaks
Gets the collection of horizontal page breaks of this worksheet.
Public propertyHyperlinks
Gets the collection of hyperlinks of this worksheet
Public propertyItemString
Gets range referenced by the range name or range reference string in A1 notation.
Public propertyItemInt32, Int32
Gets the specified cell in the worksheet.
Public propertyItemInt32, Int32, Int32, Int32
Gets cells range specified the higher left and lower right coordinates.
Public propertyName
Gets or sets the worksheet name.
Public propertyNamedRanges
Gets the named ranges collection of this worksheet (Worksheet scope named ranges).
Public propertyPageSetup
Gets the worksheet page setup options (paper size, page orientation, etc.).
Public propertyPictures
Gets the pictures collection of this worksheet.
Public propertySheetIndex
Gets the index of this worksheet in the workbook sheets collection.
Public propertyShowGridLines
Gets or sets a flag indicating if the worksheet grid lines are visible or not. Default value is true.
Public propertyUsedRange
Gets the used range on the specified worksheet.
Public propertyUsedRangeCells
Gets the cells in the used range of the worksheet.
Public propertyUsedRangeColumns
Gets an arrat of Range objects representing all the columns in the used range of the worksheet.
Public propertyUsedRangeRows
Gets a an array of Range objects representing all the rows in the used range of the worksheet.
Public propertyVerticalPageBreaks
Gets the collection of vertical page breaks of this worksheet.
Public propertyWorkbook
Gets the parent workbook of this worksheet.
Public propertyWorksheetSecurity
Gets an object used to manage the worksheet security options like password protection.
Top
Methods
  NameDescription
Public methodActivate
Makes this worksheet the active worksheet of the workbook.
Public methodAutofitColumn
Changes the width of the specified column to achieve the best fit for the cells content.
Public methodAutofitColumns
Changes the width of the used range columns to achieve the best fit for the cells content.
Public methodAutofitRow
Changes the height of the specified row to achieve the best fit for the cells content.
Public methodAutofitRows
Changes the height of the used range rows to achieve the best fit for the cells content.
Public methodDeleteColumn
Removes the column at the specified zero based index from worksheet.
Public methodDeleteRow
Removes the row at the specified zero based index from worksheet.
Public methodGetColumnVisibility
Gets the visibility of the column at the specified index.
Public methodGetColumnWidthInChars
Gets the specified column width in characters. On a worksheet, you can specify a column width of 0 to 255. This value represents the number of characters that can be displayed in a cell that is formatted with the standard font (standard font: The default text font for worksheets. The standard font determines the default font for the Normal cell style.). The default column width is 8.43 characters.
Public methodGetDataTable(ExcelRange, Boolean)
Gets a System.Data.DataTable object from the specified source range. If the getColumnNames parameter is true the first row of the range will be used to obtain names for the DataTable columns.
Public methodGetDataTable(ExcelRange, Boolean, Boolean, Boolean)
Gets a System.Data.DataTable object from the specified source range. If the getColumnNames parameter is true the first row of the range will be used to obtain names for the DataTable columns. If the getFormulaResult parameter is true the result values of the formulas evaluation will be exported If the getColumnDataTypes is true the data type of the first value of the range column will give the data type of the corresponding column in the resulted DataTable.
Public methodGetRowHeightInPoints
Gets the specified row height in points. You can specify a row height of 0 to 409. This value represents the height measurement in points (1 point equals 1/72 inch). The default row height is 12.75 points.
Public methodGetRowVisibility
Gets the visibility of the row at the specified index.
Public methodInsertColumn(Int32)
Inserts a column at the specified one based index in worksheet. The new column will have the default style of the worksheet.
Public methodInsertColumn(Int32, Boolean, Boolean)
Inserts a column with style at the specified one based index in worksheet. If inheritStyle parameter is false the new column will have the default style of the worksheet. If inheritStyle is true the new column will inherit the style from the previous column if fromPrevious parameter is true or from the next column if the fromPrevious parameter is false.
Public methodInsertRow(Int32)
Inserts a row at the specified one based in worksheet. The new row will have the default style of the worksheet.
Public methodInsertRow(Int32, Boolean, Boolean)
Inserts a row with style at the specified one based in worksheet. If inheritStyle parameter is false the new row will have the default style of the worksheet. If inheritStyle is true the new row will inherit the style from the previous row if fromPrevious parameter is true or from the next row if the fromPrevious parameter is false.
Public methodLoadDataTable(DataTable, Int32, Int32, Boolean)
Loads the values from the specified System.Data.DataTable object into the worksheet at the location given by the top row and left column indexes.
Public methodLoadDataTable(DataTable, Int32, Int32, Int32, Int32, Boolean)
Loads the values from the specified System.Data.DataTable object into the worksheet at the location given by the top row and left column indexes.
Public methodLoadDataView(DataView, Int32, Int32, Boolean)
Loads the values from the specified System.Data.DataView object into the worksheet at the location given by the top row and left column indexes.
Public methodLoadDataView(DataView, Int32, Int32, Int32, Int32, Boolean)
Loads the values from the specified System.Data.DataView object into the worksheet at the location given by the top row and left column indexes.
Public methodMoveTo
Moves the worksheet in the worksheets collection of the workbook.
Public methodSetColumnAutoStyle
Sets the auto style of a column. If this method is called before a cell in the specified column becomes part of the used range (a value is set in cell), the cell will automatically be assigned with the specified column style.
Public methodSetColumnVisibility
Sets the visibility of the column at the specified index.
Public methodSetColumnWidthInChars
Sets the column width in characters for the specified column. On a worksheet, you can specify a column width of 0 to 255. This value represents the number of characters that can be displayed in a cell that is formatted with the standard font (standard font: The default text font for worksheets. The standard font determines the default font for the Normal cell style.). The default column width is 8.43 characters. If the column width is set to 0, the column is hidden.
Public methodSetDefaultColumnWidthInChars
Sets the default column width in characters for the columns in this worksheet.
Public methodSetDefaultRowHeightInPoints
Sets the default row height in points. You can specify a row height of 0 to 409. This value represents the height measurement in points (1 point equals 1/72 inch). The default row height is 12.75 points.
Public methodSetRowAutoStyle
Set the auto style of a row. If this method is called before a cell in the specified row becomes part of the used range (a value is set in cell), the cell will automatically be assigned with the specified row style.
Public methodSetRowHeightInPoints
Sets the row height in points for the specified row. You can specify a row height of 0 to 409. This value represents the height measurement in points (1 point equals 1/72 inch). The default row height is 12.75 points. If the row height is set to 0, the row is hidden.
Public methodSetRowVisibility
Sets the visibility of the row at the specified index.
Top
See Also