Message-ID: <1721903104.10001.1711708914853.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10000_1857157686.1711708914853" ------=_Part_10000_1857157686.1711708914853 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Worksheet
class represents a single Excel worksheet.=20
[DefaultMember("Item")] public class Worksheet=20
<DefaultMember("Item")> _ =09Public Class Worksheet=20
//--- Create a new Worksheet ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); Worksheet ws =3D wb.Worksheets.CreateWorksheet("Sheet2"= ); //--- Get an existing Worksheet by index ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); Worksheet ws =3D wb.Worksheets[0]; //--- Get an existing Worksheet by name ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); Worksheet ws =3D wb.Worksheets["Sheet1"];=20
'--- Create a new Worksheet Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim ws As Worksheet =3D wb.Worksheets.CreateWorksheet("Sheet= 2") '--- Get an existing Worksheet by index Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim ws As Worksheet =3D wb.Worksheets(0) '--- Get an existing Worksheet by name Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim ws As Worksheet =3D wb.Worksheets("Sheet2")=20
Name |
Description |
---|---|
Returns a Cells collection that contains all cells in the worksheet. | |
Returns a Chart= s collection containing all the charts contained as objects within this= worksheet. Use this collection to add, access, and remove charts from the = worksheet. | |
Returns a Com= ments collection that contains all comments in the worksheet. | |
Sets or returns the 0-based index of the first c= olumn that is shown in the worksheet. | |
Sets or returns the 0-based index of the first r= ow that is shown in the worksheet. | |
Freezes panes in a worksheet or returns the cell=
at which the panes are split. Set the property to a Cell object. The cell specified in Worksheet.FreezePanes=
is the first unfrozen cell; freeze panes will be applied to all row=
s above the cell and all columns to the left of the cell. |
|
Sets or returns a Color object representing the color of the gridlines in= the worksheet. | |
Returns the collection of hyperlinks in the work= sheet. | |
Returns whether or not the worksheet is write-pr= otected. | |
Returns whether this worksheet is selected. | |
Sets or returns the name of the worksheet. Sheet= names are limited to 255 characters and must not contain the following cha= racters: \ / ? [ ] : ' | |
Returns the named ranges of the Worksheet as an array of NamedObject objects as an IEnumerable collection. Though the named ranges are not re= turned in any particular order, they iterable. | |
Returns a Pa= geSetup object representing page layout properties of a printed workshe= et. | |
Returns a Pic= tures collection containing all pictures in the worksheet. Use this col= lection to add, access, and remove pictures from the worksheet. | |
Returns a rectanglular area of cells from the fi= rst (top, left) populated cell to the last (bottom, right) populated cell i= n the worksheet. The area returned will include cells that contain no data = but have been formatted. | |
Returns the 0-based index of the worksheet in th= e collection of all sheets in the workbook. | |
Sets or returns the password hash that is used t= o write-protect (not encrypt) the worksheet. | |
Returns a Group= s collection containing all shape groups within the worksheet. | |
Returns a Shape= s collection containing all shapes within the worksheet. | |
Returns a SheetProtection object containing all protection properties on= the worksheet. | |
Sets or returns whether formulas or their calcul= ated values will be displayed in the worksheet. Calculated values are displ= ayed by default. | |
Sets or returns whether gridlines should be show= n in the worksheet. Gridlines are shown by default. | |
Sets or returns whether column and row headers w= ill be displayed in the worksheet. The headers are displayed by default. | |
Sets or returns whether zero values in cells wil= l be displayed in the worksheet. Zero values are displayed by default. | |
Sets or returns the default row height in points= (1/72 of an inch). This must be between 0 and 409. | |
Sets or returns the default column width, in poi= nts (1/72 of an inch). | |
Sets or returns the default column width as a nu= mber of character widths in the 'Normal' font. This must be a value between= 0 and 255. | |
When grouping columns, SummaryColumns determines where the summary c= olumns for the groups are located. By default the summary rows are located = to the right of the groupings. | |
When grouping rows, SummaryRows determines where the summary rows for t= he groups are located. By default the summary rows are located below the gr= oupings. | |
Sets or returns the color of the worksheet's she= et name tab. Setting the color to an automatic color will set the = ;color to no color. | |
Returns the Workbook object in which this worksheet resides. | |
Sets or returns the worksheet's viewing mode. | |
Sets or returns the visibility setting of the wo= rksheet. | |
Sets or returns the percentage of standard size = by which the worksheet will be magnified or reduced. Set this property to a= value between 10 and 400. |
Name |
Description |
---|---|
Returns the cell at a specified row and column p= osition. This property is an indexer for the Worksheet class. | |
Returns the cell at the specified Excel-style re= ference. This property is an indexer for the Worksheet class. |
Name |
Description |
---|---|
Copies an area of cells from another Worksheet to cells in this worksheet. | |
Copies an area of cells from another Worksheet to cells in this worksheet. | |
Copies an area of cells from another Worksheet to cells in this worksheet. | |
Copies an area of cells from a Worksheet in either the same workbook or another=
workbook. |
|
Copies an area of cells from another Worksheet to cells in this worksheet. | |
Copies an area of cells from another Worksheet to cells in this worksheet. | |
Creates an anchor at a specified position in the= worksheet. | |
Defines a rectangular Area of cells in the worksheet. | |
Defines a rectangular Area of cells in the worksheet. | |
Returns an Area= a> object representing all the cells in a specified group of columns. An ar= ea is a rectangular collection of cells. | |
Returns an Area= a> object representing all the cells in a specified group of rows. An area = is a rectangular collection of cells. | |
Creates a named range, containing one area. A ra= nge is a collection of areas; an area is a rectangular collection of cells.= | |
Creates a named range from a specified formula. = A range is a collection of areas; an area is a rectangular collection of ce= lls. This method can be used to create a non-rectangular range containing m= ultiple rectangular areas. | |
Creates a range from a specified formula. A rang= e is a collection of areas; an area is a rectangular collection of cells. T= his method can be used to create a non-rectangular range containing multipl= e rectangular areas. | |
Deletes a column and its contents from the works= heet. Columns after the deleted column will be moved to the left. | |
Deletes a number of columns and its contents fro= m the worksheet. Columns after the deleted columns will be moved to the lef= t. | |
Deletes a specified row and its contents from th= e worksheet. Rows below the deleted row will be moved up. | |
Deletes a specified number of rows and its conte= nts from the worksheet. Rows below the deleted rows will be moved up. | |
Returns a ColumnProperties object representing the column specified by index= . | |
Returns the NamedObject object that represents the name of a specified array, num= ber, picture, or range. If the named object does not exist, the method retu= rns null. | |
Returns the named Range object that specified by name. If the named range does not exis= t, the method returns null. | |
Returns a RowProperties object representing the row specified by index. | |
Groups or outlines a contiguous set of columns.<= /td> | |
Groups or outlines a contiguous set of rows. | |
Imports data from a two-dimensional array of obj= ects to cells in the worksheet. | |
ImportData(Object()(), String(), Cell, DataImportProperties) |
Imports data from a two-dimensional array of obj= ects to cells in the worksheet. The new data will overwrite values and formulas in the target works= heet cells, but existing formatting will be preserved. |
Imports data from an ADO.NET DataTable to cells in the worksheet. The new= data will overwrite val= ues and formulas in the target worksheet cells, but existing formatting wil= l be preserved. | |
ImportData(System.Data.DataTable, Cell, DataImportProperties)= p> |
Imports data from an ADO.NET DataTable to cells in the worksheet. The new= data will overwrite val= ues and formulas in the target worksheet cells, but existing formatting wil= l be preserved. |
Imports data from an ADO.NET DataView to cells in the worksheet. The new = data will overwrite valu= es and formulas in the target worksheet cells, but existing formatting will= be preserved. | |
ImportData(System.Data.DataView, Cell, DataImportProperties) |
Imports data from an ADO.NET DataView to cells in the worksheet. The new = data will overwrite valu= es and formulas in the target worksheet cells, but existing formatting will= be preserved. |
Imports data from a rectangular array of objects= to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet= cells, but existing formatting will be preserved. | |
= | Imports data from a rectangular array of objects= to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet= cells, but existing formatting will be preserved. |
Imports data from an IDataReader to cells in the worksheet. The new data = will overwrite values an= d formulas in the target worksheet cells, but existing formatting will be p= reserved. | |
ImportData(System.Data.IDataReader, Cell, DataImportProperties)= |
Imports data from an IDataReader to cells in the worksheet. The new data = will overwrite values an= d formulas in the target worksheet cells, but existing formatting will be p= reserved. |
Inserts a column in the worksheet to the left of= the specified column. | |
Inserts a column in the worksheet to the left of=
the specified column, copying the style based on the copyBehavior parameter. |
|
InsertColumn(Int32, ColumnInsertBehavior, ColumnInsertBehavior)= |
Inserts a column in the worksheet to the left of=
the specified column, copying the style based on the copyBehavior parameter. |
Inserts a block of columns in the worksheet to t= he left of the specified column. | |
Inserts a block of columns in the worksheet to t=
he left of the specified column, copying the style based on the copyB=
ehavior parameter. |
|
InsertColumns(Int32, Int32, ColumnInsertBehavior, ColumnInsertBehav= ior) |
Inserts a block of columns in the worksheet to t=
he left of the specified column, copying the style based on the copyB=
ehavior parameter. |
Inserts a horizontal page break in the worksheet= after the specified cell. | |
Inserts a row in the worksheet above the specifi= ed row. | |
Inserts a row in the worksheet above the specifi= ed row. | |
Inserts a row in the worksheet above the specifi= ed row. | |
Inserts a number of rows in the worksheet above = the specified row. | |
Inserts a number of rows in the worksheet above = the specified row. | |
InsertRows(Int32, Int32, RowInsertBehavior, RowInsertBehavior)<= /p> |
Inserts a number of rows in the worksheet above = the specified row. |
Inserts a vertical page break in the worksheet t= o right of the specified cell. | |
Write-protects the worksheet. A user will not be= able to modify the worksheet in Excel without entering the specified passw= ord. This method does not encrypt the worksheet. | |
Selects the current worksheet and deselects all = others. To select multiple worksheets, use Worksheets.Select(). | |
Ungroups a contiguous set of columns. | |
Ungroups a contiguous set of rows. | |
Removes the write-protection from the worksheet.= |
Overload |
Description |
---|---|
ImportData(Cell, Microsoft.SharePoint.SPList, DataImportProperties)= |
Imports data from a SharePoint List to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved. |
Imports data from a SharePoint List to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved. | |
ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.= SPList, DataImportProperties) |
Imports data from a SharePoint View to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved. |
ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.= SPList) |
Imports data from a SharePoint View to cells in = the worksheet. The new data will overwrite values and formulas in the targe= t worksheet cells, but existing formatting will be preserved. |
Name |
Description |
---|---|
Defines a set of constants related to worksheets= . | |
A SheetViewState value specifies the view state of a worksheet in Ex= cel. | |
A SheetVisibility value specifies the visibility level of a workshe= et. | |
A SummaryColumnsLocation value specifies the location of the= summary column for a set of grouped columns. | |
A SummaryColumnsLocation value specifies the location of the= summary row for a set of grouped rows. |