Message-ID: <1804461346.10515.1711726899077.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10514_2116031038.1711726899077" ------=_Part_10514_2116031038.1711726899077 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The 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 | =20
Description | =20
---|---|
=20 | Returns a Cells collection that contains all cells in the worksheet. | =20
=20 | 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. | =20
=20 | Returns a Com= ments collection that contains all comments in the worksheet. | =20
=20 | Sets or returns the 0-based index of the first = column that is shown in the worksheet. | =20
=20 | Sets or returns the 0-based index of the first = row that is shown in the worksheet. | =20
=20 | Freezes panes in a worksheet or returns the cel=
l 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. | =20
=20 | Sets or returns a Color object representing the color of the gridlines i= n the worksheet. | =20
=20 | Returns the collection of hyperlinks in the wor= ksheet. | =20
=20 | Returns whether or not the worksheet is write-p= rotected. | =20
=20 | Returns whether this worksheet is selected. =20 |
=20 | Sets or returns the name of the worksheet. Shee= t names are limited to 255 characters and must not contain the following ch= aracters: \ / ? [ ] : ' | =20
=20 | Returns the named ranges of the Worksheet as an array of NamedObject objects as an IEnumerable collection. Though the named ranges are not ret= urned in any particular order, they iterable. | =20
=20 | Returns a Pa= geSetup object representing page layout properties of a printed workshe= et. | =20
=20 | Returns a Pic= tures collection containing all pictures in the worksheet. Use this col= lection to add, access, and remove pictures from the worksheet. | =20
=20 | Returns a rectanglular area of cells from the f= irst (top, left) populated cell to the last (bottom, right) populated cell = in the worksheet. The area returned will include cells that contain no data= but have been formatted. | =20
=20 | Returns the 0-based index of the worksheet in t= he collection of all sheets in the workbook. | =20
=20 | Sets or returns the password hash that is used = to write-protect (not encrypt) the worksheet. | =20
=20 | Returns a Group= s collection containing all shape groups within the worksheet. | =20
=20 | Returns a Shape= s collection containing all shapes within the worksheet. | =20
=20 | Returns a SheetProtection object containing all protection properties on= the worksheet. | =20
=20 | Sets or returns whether formulas or their calcu= lated values will be displayed in the worksheet. Calculated values are disp= layed by default. | =20
=20 | Sets or returns whether gridlines should be sho= wn in the worksheet. Gridlines are shown by default. | =20
=20 | Sets or returns whether column and row headers = will be displayed in the worksheet. The headers are displayed by default. <= /td>=20 |
=20 | Sets or returns whether zero values in cells wi= ll be displayed in the worksheet. Zero values are displayed by default. =20 |
=20 | Sets or returns the default row height in point= s (1/72 of an inch). This must be between 0 and 409. | =20
=20 | Sets or returns the default column width, in po= ints (1/72 of an inch). | =20
=20 | Sets or returns the default column width as a n= umber of character widths in the 'Normal' font. This must be a value betwee= n 0 and 255. | =20
=20 | 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. | =20
=20 | 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. | =20
=20 | Sets or returns the color of the worksheet's sh= eet name tab. Setting the color to an automatic color will set the&nbs= p;color to no color. | =20
=20 | Returns the Workbook object in which this worksheet resides. | =20
=20 | Sets or returns the worksheet's viewing mode. <= /td>=20 |
=20 | Sets or returns the visibility setting of the w= orksheet. | =20
=20 | 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. | =20
Name | =20
Description | =20
---|---|
=20 | Returns the cell at a specified row and column = position. This property is an indexer for the Worksheet class. | =20
=20 | Returns the cell at the specified Excel-style r= eference. This property is an indexer for the Worksheet class. | =20
Name | =20
Description | =20
---|---|
=20 | Copies an area of cells from another Worksheet to cells in this worksheet. | =20
=20 | Copies an area of cells from another Worksheet to cells in this worksheet. | =20
=20 | Copies an area of cells from another Worksheet to cells in this worksheet. | =20
=20 | Copies an area of cells from a Worksheet in either the same workbook or another =
workbook. | =20
=20 | Copies an area of cells from another Worksheet to cells in this worksheet. | =20
=20 | Copies an area of cells from another Worksheet to cells in this worksheet. | =20
=20 | Creates an anchor at a specified position in th= e worksheet. | =20
=20 | Defines a rectangular Area of cells in the worksheet. | =20
=20 | Defines a rectangular Area of cells in the worksheet. | =20
=20 | Returns an Area= a> object representing all the cells in a specified group of columns. An ar= ea is a rectangular collection of cells. | =20
=20 | Returns an Area= a> object representing all the cells in a specified group of rows. An area = is a rectangular collection of cells. | =20
= =20 | Creates a named range, containing one area. A r= ange is a collection of areas; an area is a rectangular collection of cells= . | =20
=20 | Creates a named range from a specified formula.= A range is a collection of areas; an area is a rectangular collection of c= ells. This method can be used to create a non-rectangular range containing = multiple rectangular areas. | =20
=20 | Creates a range from a specified formula. A ran= ge is a collection of areas; an area is a rectangular collection of cells. = This method can be used to create a non-rectangular range containing multip= le rectangular areas. | =20
=20 | Deletes a column and its contents from the work= sheet. Columns after the deleted column will be moved to the left. | =20
=20 | Deletes a number of columns and its contents fr= om the worksheet. Columns after the deleted columns will be moved to the le= ft. | =20
=20 | Deletes a specified row and its contents from t= he worksheet. Rows below the deleted row will be moved up. | =20
=20 | Deletes a specified number of rows and its cont= ents from the worksheet. Rows below the deleted rows will be moved up. | =20
=20 | Returns a ColumnProperties object representing the column specified by index= . | =20
=20 | 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. | =20
=20 | Returns the named Range object that specified by name. If the named range does not exis= t, the method returns null. | =20
=20 | Returns a RowProperties object representing the row specified by index. | = =20
=20 | Groups or outlines a contiguous set of columns.= | =20
=20 | Groups or outlines a contiguous set of rows. = td>=20 |
=20 | Imports data from a two-dimensional array of ob= jects to cells in the worksheet. | =20
ImportData(Object()(), String(), Cell, DataImportProperties) = p> | =20
Imports data from a two-dimensional array of ob= jects to cells in the worksheet. The new data will overwrite values and formulas in the target work= sheet cells, but existing formatting will be preserved. | =20
=20 | Imports data from an ADO.NET DataTable to cells in the worksheet. The ne= w data will overwrite va= lues and formulas in the target worksheet cells, but existing formatting wi= ll be preserved. | =20
ImportData(System.Data.DataTable, Cell, DataImportProperties) <= /p> | =20
Imports data from an ADO.NET DataTable to cells in the worksheet. The ne= w data will overwrite va= lues and formulas in the target worksheet cells, but existing formatting wi= ll be preserved. | =20
=20 | Imports data from an ADO.NET DataView 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. | =20
ImportData(System.Data.DataView, Cell, DataImportProperties) = p> | =20
Imports data from an ADO.NET DataView 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. | =20
=20 | Imports data from a rectangular array of object= s to cells in the worksheet. The new data will overwrite values and formulas in the target workshee= t cells, but existing formatting will be preserved. | =20
=20 | Imports data from a rectangular array of object= s to cells in the worksheet. The new data will overwrite values and formulas in the target workshee= t cells, but existing formatting will be preserved. | =20
=20 | Imports data from an IDataReader to cells in the worksheet. The new data= will overwrite values a= nd formulas in the target worksheet cells, but existing formatting will be = preserved. | =20
ImportData(System.Data.IDataReader, Cell, DataImportProperties)= | =20
Imports data from an IDataReader to cells in the worksheet. The new data= will overwrite values a= nd formulas in the target worksheet cells, but existing formatting will be = preserved. | =20
=20 | Inserts a column in the worksheet to the left o= f the specified column. | =20
=20 | Inserts a column in the worksheet to the left o=
f the specified column, copying the style based on the copyBehavior=
code> parameter. | =20
InsertColumn(Int32, ColumnInsertBehavior, ColumnInsertBehavior)= | =20
Inserts a column in the worksheet to the left o=
f the specified column, copying the style based on the copyBehavior=
code> parameter. | =20
=20 | Inserts a block of columns in the worksheet to = the left of the specified column. | =20
=20 | Inserts a block of columns in the worksheet to =
the left of the specified column, copying the style based on the copy=
Behavior parameter. | =20
InsertColumns(Int32, Int32, ColumnInsertBehavior, ColumnInsertBehav= ior) | =20
Inserts a block of columns in the worksheet to =
the left of the specified column, copying the style based on the copy=
Behavior parameter. | =20
=20 | Inserts a horizontal page break in the workshee= t after the specified cell. | =20
=20 | Inserts a row in the worksheet above the specif= ied row. | =20
=20 | Inserts a row in the worksheet above the specif= ied row. | =20
=20 | Inserts a row in the worksheet above the specif= ied row. | =20
=20 | Inserts a number of rows in the worksheet above= the specified row. | =20
=20 | Inserts a number of rows in the worksheet above= the specified row. | =20
InsertRows(Int32, Int32, RowInsertBehavior, RowInsertBehavior) = | =20
Inserts a number of rows in the worksheet above= the specified row. | =20
=20 | Inserts a vertical page break in the worksheet = to right of the specified cell. | =20
=20 | Write-protects the worksheet. A user will not b= e able to modify the worksheet in Excel without entering the specified pass= word. This method does not encrypt the worksheet. | =20
=20 | Selects the current worksheet and deselects all= others. To select multiple worksheets, use Worksheets.Select(). | =20
=20 | Ungroups a contiguous set of columns. | =20
=20 | Ungroups a contiguous set of rows. | =20
=20 | Removes the write-protection from the worksheet= . | =20
Overload | =20
Description | =20
---|---|
ImportData(Cell, Microsoft.SharePoint.SPList, DataImportProperties)= | =20
Imports data from a SharePoint List to cells in= the worksheet. The new data will overwrite values and formulas in the targ= et worksheet cells, but existing formatting will be preserved. | =20
=20 | Imports data from a SharePoint List to cells in= the worksheet. The new data will overwrite values and formulas in the targ= et worksheet cells, but existing formatting will be preserved. | =20
ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.= SPList, DataImportProperties) | =20
Imports data from a SharePoint View to cells in= the worksheet. The new data will overwrite values and formulas in the targ= et worksheet cells, but existing formatting will be preserved. | =20
ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.= SPList) | =20
Imports data from a SharePoint View to cells in= the worksheet. The new data will overwrite values and formulas in the targ= et worksheet cells, but existing formatting will be preserved. | =20
Name | =20
Description | =20
---|---|
=20 | Defines a set of constants related to worksheet= s. | =20
=20 | A SheetViewState value specifies the view state of a worksheet in Ex= cel. | =20
=20 | A SheetVisibility value specifies the visibility level of a workshe= et. | =20
=20 | A SummaryColumnsLocation value specifies the location of the= summary column for a set of grouped columns. | =20
=20 | A SummaryColumnsLocation value specifies the location of the= summary row for a set of grouped rows. | =20