Excel Worksheet
Declaration Syntax| C# | Visual Basic | Visual C++ |
public class ExcelWorksheet
Public Class ExcelWorksheet
public ref class ExcelWorksheet
Members| All Members | Methods | Properties | |||
| Icon | Member | Description |
|---|---|---|
 | Activate()()() |
Makes this worksheet the active worksheet of the workbook.
|
| AutofitColumn(Int32) |
Changes the width of the specified column to achieve the best fit for the cells content.
|
| AutofitColumns()()() |
Changes the width of the used range columns to achieve the best fit for the cells content.
|
| AutofitRow(Int32) |
Changes the height of the specified row to achieve the best fit for the cells content.
|
| AutofitRows()()() |
Changes the height of the used range rows to achieve the best fit for the cells content.
|
 | Charts |
Gets the charts collection of this worksheet.
|
| Comments |
Gets the comments collection of this worksheet.
|
| DeleteColumn(Int32) |
Removes the column at the specified zero based index from worksheet.
|
| DeleteRow(Int32) |
Removes the row at the specified zero based index from worksheet.
|
| Equals(Object) | (Inherited from Object.) |
 | Finalize()()() |
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.) |
| GetColumnVisibility(Int32) |
Gets the visibility of the column at the specified index.
|
| GetColumnWidthInChars(Int32) |
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.
|
| GetDataTable(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.
|
| GetDataTable(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.
|
| GetHashCode()()() |
Serves as a hash function for a particular type.
(Inherited from Object.) |
| GetRowHeightInPoints(Int32) |
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.
|
| GetRowVisibility(Int32) |
Gets the visibility of the row at the specified index.
|
| GetType()()() |
Gets the Type of the current instance.
(Inherited from Object.) |
| HorizontalPageBreaks |
Gets the collection of horizontal page breaks of this worksheet.
|
| Hyperlinks |
Gets the collection of hyperlinks of this worksheet
|
| InsertColumn(Int32) |
Inserts a column at the specified one based index in worksheet. The new column will have the default style of the worksheet.
|
| InsertColumn(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.
|
| InsertRow(Int32) |
Inserts a row at the specified one based in worksheet. The new row will have the default style of the worksheet.
|
| InsertRow(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.
|
| Item[([(Int32, Int32])]) |
Gets the specified cell in the worksheet.
|
| Item[([(Int32, Int32, Int32, Int32])]) |
Gets cells range specified the the higher left and lower right coordinates.
|
| Item[([(String])]) |
Gets range referenced by the range name or range reference string in A1 notation.
|
| LoadDataTable(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.
|
| LoadDataTable(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.
|
| LoadDataView(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.
|
| LoadDataView(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.
|
| MemberwiseClone()()() |
Creates a shallow copy of the current Object.
(Inherited from Object.) |
| MoveTo(Int32) |
Moves the worksheet in the worksheets collection of the workbook.
|
| Name |
Gets or sets the worksheet name.
|
| NamedRanges |
Gets the named ranges collection of this worksheet (Worksheet scope named ranges).
|
| PageSetup |
Gets the worksheet page setup options (paper size, page orientation, etc.).
|
| ParseValueString |
Gets or sets a flag indicating if the values of String type assigned to the Value property of a Range in the worksheet are
parsed to determine the data type or they are simply considered texts. The default value is true.
|
| Pictures |
Gets the pictures collection of this worksheet.
|
| SerializeDefaultColumnWidth |
A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xls_2007.
|
| SerializeDefaultRowHeight |
A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xlsx_2007.
|
| SetColumnAutoStyle(Int32, ExcelCellStyle) |
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.
|
| SetColumnVisibility(Int32, Boolean) |
Sets the visibility of the column at the specified index.
|
| SetColumnWidthInChars(Int32, Double) |
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.
|
| SetDefaultColumnWidthInChars(Double) |
Sets the default column width in characters for the columns in this worksheet.
|
| SetDefaultRowHeightInPoints(Double) |
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.
|
| SetRowAutoStyle(Int32, ExcelCellStyle) |
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.
|
| SetRowHeightInPoints(Int32, Double) |
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.
|
| SetRowVisibility(Int32, Boolean) |
Sets the visibility of the row at the specified index.
|
| SheetIndex |
Gets the index of this worksheet in the workbook sheets collection.
|
| ShowGridLines |
Gets or sets a flag indicating if the worksheet grid lines are visible or not. Default value is true.
|
| ToString()()() | (Inherited from Object.) |
| UsedRange |
Gets the used range on the specified worksheet.
|
| UsedRangeCells |
Gets the cells in the used range of the worksheet.
|
| UsedRangeColumns |
Gets an arrat of Range objects representing all the columns in the used range of the worksheet.
|
| UsedRangeRows |
Gets a an array of Range objects representing all the rows in the used range of the worksheet.
|
| VerticalPageBreaks |
Gets the collection of vertical page breaks of this worksheet.
|
| Workbook |
Gets the parent workbook of this worksheet.
|
| WorksheetSecurity |
Gets an object used to manage the worksheet security options like password protection.
|
Inheritance Hierarchy| Object | |
 | ExcelWorksheet |