Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Description

Excerpt

The Worksheet class represents a single Excel worksheet.

...

Name

Description

Cells

Excerpt Include
EW8:Worksheet.CellsEW8:
Worksheet.Cells
nopaneltrue

Charts

Excerpt Include
EW8:Worksheet.ChartsEW8:
Worksheet.Charts
nopaneltrue

Comments

Excerpt Include
EW8:Worksheet.CommentsEW8:
Worksheet.Comments
nopaneltrue

FirstShownColumn

Excerpt Include
EW8:Worksheet.FirstShownColumnEW8:
Worksheet.FirstShownColumn
nopaneltrue

FirstShownRow

Excerpt Include
EW8:Worksheet.FirstShownRowEW8:
Worksheet.FirstShownRow
nopaneltrue

FreezePanes

Excerpt Include
EW8:Worksheet.FreezePanesEW8:
Worksheet.FreezePanes
nopaneltrue

GridlinesColor

Excerpt Include
EW8:Worksheet.GridlinesColorEW8:
Worksheet.GridlinesColor
nopaneltrue

Hyperlinks

Excerpt Include
EW8:Worksheet.HyperlinksEW8:
Worksheet.Hyperlinks
nopaneltrue

IsProtected

Excerpt Include
EW8:Worksheet.IsProtectedEW8:
Worksheet.IsProtected
nopaneltrue

IsSelected

Excerpt Include
EW8:Worksheet.IsSelectedEW8:
Worksheet.IsSelected
nopaneltrue

Name

Excerpt Include
EW8:Worksheet.NameEW8:
Worksheet.Name
nopaneltrue

NamedRanges

Excerpt Include
EW8:Worksheet.NamedRangesEW8:
Worksheet.NamedRanges
nopaneltrue

PageSetup

Excerpt Include
EW8:Worksheet.PageSetupEW8:
Worksheet.PageSetup
nopaneltrue

Pictures

Excerpt Include
EW8:Worksheet.PicturesEW8:
Worksheet.Pictures
nopaneltrue

PopulatedCells

Excerpt Include
EW8:Worksheet.PopulatedCellsEW8:
Worksheet.PopulatedCells
nopaneltrue

Position

Excerpt Include
EW8:Worksheet.PositionEW8:
Worksheet.Position
nopaneltrue

ProtectPasswordHash

Excerpt Include
EW8:Worksheet.ProtectPasswordHashEW8:
Worksheet.ProtectPasswordHash
nopaneltrue

ShapeGroups

Excerpt Include
EW8:Worksheet.ShapeGroupsEW8:
Worksheet.ShapeGroups
nopaneltrue

Shapes

Excerpt Include
EW8:Worksheet.ShapesEW8:
Worksheet.Shapes
nopaneltrue

SheetProtection

Excerpt Include
EW8:Worksheet.SheetProtectionEW8:
Worksheet.SheetProtection
nopaneltrue

ShowFormulas

Excerpt Include
EW8:Worksheet.ShowFormulasEW8:
Worksheet.ShowFormulas
nopaneltrue

ShowGridlines

Excerpt Include
EW8:Worksheet.ShowGridlinesEW8:
Worksheet.ShowGridlines
nopaneltrue

ShowRowColHeaders

Excerpt Include
EW8:Worksheet.ShowRowColHeadersEW8:
Worksheet.ShowRowColHeaders
nopaneltrue

ShowZeroValues

Excerpt Include
EW8:Worksheet.ShowZeroValuesEW8:
Worksheet.ShowZeroValues
nopaneltrue

StandardHeight

Excerpt Include
EW8:Worksheet.StandardHeightEW8:
Worksheet.StandardHeight
nopaneltrue

StandardWidth

Excerpt Include
EW8:Worksheet.StandardWidthEW8:
Worksheet.StandardWidth
nopaneltrue

StandardWidthInChars

Excerpt Include
EW8:Worksheet.StandardWidthInCharsEW8:
Worksheet.StandardWidthInChars
nopaneltrue

SummaryColumns

Excerpt Include
EW8:Worksheet.SummaryColumnsEW8:
Worksheet.SummaryColumns
nopaneltrue

SummaryRows

Excerpt Include
EW8:Worksheet.SummaryRowsEW8:
Worksheet.SummaryRows
nopaneltrue

TabColor

Excerpt Include
EW8:Worksheet.TabColorEW8:
Worksheet.TabColor
nopaneltrue

Workbook

Excerpt Include
EW8:Worksheet.WorkbookEW8:
Worksheet.Workbook
nopaneltrue

ViewState

Excerpt Include
EW8:Worksheet.ViewStateEW8:
Worksheet.ViewState
nopaneltrue

Visibility

Excerpt Include
EW8:Worksheet.VisibilityEW8:
Worksheet.Visibility
nopaneltrue

ZoomPercentage

Excerpt Include
EW8:Worksheet.ZoomPercentageEW8:
Worksheet.ZoomPercentage
nopaneltrue

...

Name

Description

Item(Int32, Int32)

Excerpt Include
EW8:Worksheet.Item(Int32, Int32)EW8:
Worksheet.Item(Int32, Int32)
nopaneltrue

Item(String)

Excerpt Include
EW8:Worksheet.Item(String)EW8:
Worksheet.Item(String)
nopaneltrue

...

Name

Description

CopyPaste(Cell, Area)

Excerpt Include
EW8:Worksheet.CopyPaste(Cell, Area)EW8:
Worksheet.CopyPaste(Cell, Area)
nopaneltrue

CopyPaste(Cell, Area, CopyPasteProperties)

Excerpt Include
EW8:Worksheet.CopyPaste(Cell, Area, CopyPasteProperties)EW8:
Worksheet.CopyPaste(Cell, Area, CopyPasteProperties)
nopaneltrue

CopyPaste(Int32, Int32, Area)

Excerpt Include
EW8:Worksheet.CopyPaste(Int32, Int32, Area)EW8:
Worksheet.CopyPaste(Int32, Int32, Area)
nopaneltrue

CopyPaste(Int32, Int32, Area, CopyPasteProperties)

Excerpt Include
EW8:Worksheet.CopyPaste(Int32, Int32, Area, CopyPasteProperties)EW8:
Worksheet.CopyPaste(Int32, Int32, Area, CopyPasteProperties)
nopaneltrue

CopyPaste(String, Area, CopyPasteProperties)

Excerpt Include
EW8:Worksheet.CopyPaste(String, Area, CopyPasteProperties)EW8:
Worksheet.CopyPaste(String, Area, CopyPasteProperties)
nopaneltrue

CopyPaste(String, Area)

Excerpt Include
EW8:Worksheet.CopyPaste(String, Area)EW8:
Worksheet.CopyPaste(String, Area)
nopaneltrue

CreateAnchor(Int32, Int32, Double, Double)

Excerpt Include
EW8:Worksheet.CreateAnchor(Int32, Int32, Double, Double)EW8:
Worksheet.CreateAnchor(Int32, Int32, Double, Double)
nopaneltrue

CreateArea(Int32, Int32, Int32, Int32)

Excerpt Include
EW8:Worksheet.CreateArea(Int32, Int32, Int32, Int32)EW8:
Worksheet.CreateArea(Int32, Int32, Int32, Int32)
nopaneltrue

CreateArea(String)

Excerpt Include
EW8:Worksheet.CreateArea(String)EW8:
Worksheet.CreateArea(String)
nopaneltrue

CreateAreaOfColumns(Int32, Int32)

Excerpt Include
EW8:Worksheet.CreateAreaOfColumns(Int32, Int32)EW8:
Worksheet.CreateAreaOfColumns(Int32, Int32)
nopaneltrue

CreateAreaOfRows(Int32, Int32)

Excerpt Include
EW8:Worksheet.CreateAreaOfRows(Int32, Int32)EW8:
Worksheet.CreateAreaOfRows(Int32, Int32)
nopaneltrue

CreateNamedRange(Int32, Int32, Int32, Int32, String)

Excerpt Include
EW8:Worksheet.CreateNamedRange(Int32, Int32, Int32, Int32, String)EW8:
Worksheet.CreateNamedRange(Int32, Int32, Int32, Int32, String)
nopaneltrue

CreateNamedRange(String, String)

Excerpt Include
EW8:Worksheet.CreateNamedRange(String, String)EW8:
Worksheet.CreateNamedRange(String, String)
nopaneltrue

CreateRange(String)

Excerpt Include
EW8:Worksheet.CreateRange(String)EW8:
Worksheet.CreateRange(String)
nopaneltrue

DeleteColumn(Int32)

Excerpt Include
EW8:Worksheet.DeleteColumn(Int32)EW8:
Worksheet.DeleteColumn(Int32)
nopaneltrue

DeleteColumns(Int32, Int32)

Excerpt Include
EW8:Worksheet.DeleteColumns(Int32, Int32)EW8:
Worksheet.DeleteColumns(Int32, Int32)
nopaneltrue

DeleteRow(Int32)

Excerpt Include
EW8:Worksheet.DeleteRow(Int32)EW8:
Worksheet.DeleteRow(Int32)
nopaneltrue

DeleteRows(Int32, Int32)

Excerpt Include
EW8:Worksheet.DeleteRows(Int32, Int32)EW8:
Worksheet.DeleteRows(Int32, Int32)
nopaneltrue

GetColumnProperties(Int32)

Excerpt Include
EW8:Worksheet.GetColumnProperties(Int32)EW8:
Worksheet.GetColumnProperties(Int32)
nopaneltrue

GetNamedObject(String)

Excerpt Include
EW8:Worksheet.GetNamedObject(String)EW8:
Worksheet.GetNamedObject(String)
nopaneltrue

GetNamedRange(String)

Excerpt Include
EW8:Worksheet.GetNamedRange(String)EW8:
Worksheet.GetNamedRange(String)
nopaneltrue

GetRowProperties(Int32)

Excerpt Include
EW8:Worksheet.GetRowProperties(Int32)EW8:
Worksheet.GetRowProperties(Int32)
nopaneltrue

GroupColumns(Int32, Int32, Boolean)

Excerpt Include
EW8:Worksheet.GroupColumns(Int32, Int32, Boolean)EW8:
Worksheet.GroupColumns(Int32, Int32, Boolean)
nopaneltrue

GroupRows(Int32, Int32, Boolean)

Excerpt Include
EW8:Worksheet.GroupRows(Int32, Int32, Boolean)EW8:
Worksheet.GroupRows(Int32, Int32, Boolean)
nopaneltrue

ImportData(Object()(), Cell)

Excerpt Include
EW8:Worksheet.ImportData(Object()(), Cell)EW8:
Worksheet.ImportData(Object()(), Cell)
nopaneltrue

ImportData(Object()(), String(), Cell, DataImportProperties)

Excerpt Include
EW8:Worksheet.ImportData(Object()(), String(), Cell, DataImportProperties)EW8:
Worksheet.ImportData(Object()(), String(), Cell, DataImportProperties)
nopaneltrue

ImportData(System.Data.DataTable, Cell)

Excerpt Include
EW8:Worksheet.ImportData(System.Data.DataTable, Cell)EW8:
Worksheet.ImportData(System.Data.DataTable, Cell)
nopaneltrue

ImportData(System.Data.DataTable, Cell, DataImportProperties)

Excerpt Include
EW8:Worksheet.ImportData(System.Data.DataTable, Cell, DataImportProperties)EW8:
Worksheet.ImportData(System.Data.DataTable, Cell, DataImportProperties)
nopaneltrue

ImportData(System.Data.DataView, Cell)

Excerpt Include
EW8:Worksheet.ImportData(System.Data.DataView, Cell)EW8:
Worksheet.ImportData(System.Data.DataView, Cell)
nopaneltrue

ImportData(System.Data.DataView, Cell, DataImportProperties)

Excerpt Include
EW8:Worksheet.ImportData(System.Data.DataView, Cell, DataImportProperties)EW8:
Worksheet.ImportData(System.Data.DataView, Cell, DataImportProperties)
nopaneltrue

ImportData(Object(,), Cell)

Excerpt Include
EW8:Worksheet.ImportData(Object(,), Cell)EW8:
Worksheet.ImportData(Object(,), Cell)
nopaneltrue

ImportData(Object(,), String(), Cell, DataImportProperties)

Excerpt Include
EW8:Worksheet.ImportData(Object(,), String(), Cell, DataImportProperties)EW8:
Worksheet.ImportData(Object(,), String(), Cell, DataImportProperties)
nopaneltrue

ImportData(System.Data.IDataReader, Cell)

Excerpt Include
EW8:Worksheet.ImportData(System.Data.IDataReader, Cell)EW8:
Worksheet.ImportData(System.Data.IDataReader, Cell)
nopaneltrue

ImportData(System.Data.IDataReader, Cell, DataImportProperties)

Excerpt Include
EW8:Worksheet.ImportData(System.Data.IDataReader, Cell, DataImportProperties)EW8:
Worksheet.ImportData(System.Data.IDataReader, Cell, DataImportProperties)
nopaneltrue

InsertColumn(Int32)

Excerpt Include
EW8:Worksheet.InsertColumn(Int32)EW8:
Worksheet.InsertColumn(Int32)
nopaneltrue

InsertColumn(Int32, ColumnInsertBehavior)

Excerpt Include
EW8:Worksheet.InsertColumn(Int32, Style.ColumnInsertBehavior)EW8:
Worksheet.InsertColumn(Int32, Style.ColumnInsertBehavior)
nopaneltrue

InsertColumn(Int32, ColumnInsertBehavior, ColumnInsertBehavior)

Excerpt Include
EW8:Worksheet.InsertColumn(Int32, Style.ColumnInsertBehavior, Style.ColumnInsertBehavior)EW8:
Worksheet.InsertColumn(Int32, Style.ColumnInsertBehavior, Style.ColumnInsertBehavior)
nopaneltrue

InsertColumns(Int32, Int32)

Excerpt Include
EW8:Worksheet.InsertColumns(Int32, Int32)EW8:
Worksheet.InsertColumns(Int32, Int32)
nopaneltrue

InsertColumns(Int32, Int32, ColumnInsertBehavior)

Excerpt Include
EW8:Worksheet.InsertColumns(Int32, Int32, Style.ColumnInsertBehavior)EW8:
Worksheet.InsertColumns(Int32, Int32, Style.ColumnInsertBehavior)
nopaneltrue

InsertColumns(Int32, Int32, ColumnInsertBehavior, ColumnInsertBehavior)

Excerpt Include
EW8:Worksheet.InsertColumns(Int32, Int32, Style.ColumnInsertBehavior, Style.ColumnInsertBehavior)EW8:
Worksheet.InsertColumns(Int32, Int32, Style.ColumnInsertBehavior, Style.ColumnInsertBehavior)
nopaneltrue

InsertHorizontalPageBreak(Cell)

Excerpt Include
EW8:Worksheet.InsertHorizontalPageBreak(Cell)EW8:
Worksheet.InsertHorizontalPageBreak(Cell)
nopaneltrue

InsertRow(Int32)

Excerpt Include
EW8:Worksheet.InsertRow(Int32)EW8:
Worksheet.InsertRow(Int32)
nopaneltrue

InsertRow(Int32, RowInsertBehavior)

Excerpt Include
EW8:Worksheet.InsertRow(Int32, Style.RowInsertBehavior)EW8:
Worksheet.InsertRow(Int32, Style.RowInsertBehavior)
nopaneltrue

InsertRow(Int32, RowInsertBehavior, RowInsertBehavior)

Excerpt Include
EW8:Worksheet.InsertRow(Int32, Style.RowInsertBehavior, Style.RowInsertBehavior)EW8:
Worksheet.InsertRow(Int32, Style.RowInsertBehavior, Style.RowInsertBehavior)
nopaneltrue

InsertRows(Int32, Int32)

Excerpt Include
EW8:Worksheet.InsertRows(Int32, Int32)EW8:
Worksheet.InsertRows(Int32, Int32)
nopaneltrue

InsertRows(Int32, Int32, RowInsertBehavior)

Excerpt Include
EW8:Worksheet.InsertRows(Int32, Int32, Style.RowInsertBehavior)EW8:
Worksheet.InsertRows(Int32, Int32, Style.RowInsertBehavior)
nopaneltrue

InsertRows(Int32, Int32, RowInsertBehavior, RowInsertBehavior)

Excerpt Include
EW8:Worksheet.InsertRows(Int32, Int32, Style.RowInsertBehavior, Style.RowInsertBehavior)EW8:
Worksheet.InsertRows(Int32, Int32, Style.RowInsertBehavior, Style.RowInsertBehavior)
nopaneltrue

InsertVerticalPageBreak(Cell)

Excerpt Include
EW8:Worksheet.InsertVerticalPageBreak(Cell)EW8:
Worksheet.InsertVerticalPageBreak(Cell)
nopaneltrue

Protect(String)

Excerpt Include
EW8:Worksheet.Protect(String)EW8:
Worksheet.Protect(String)
nopaneltrue

Select()

Excerpt Include
EW8:Worksheet.Select()EW8:
Worksheet.Select()
nopaneltrue

UngroupColumns(Int32, Int32)

Excerpt Include
EW8:Worksheet.UngroupColumns(Int32, Int32)EW8:
Worksheet.UngroupColumns(Int32, Int32)
nopaneltrue

UngroupRows(Int32, Int32)

Excerpt Include
EW8:Worksheet.UngroupRows(Int32, Int32)EW8:
Worksheet.UngroupRows(Int32, Int32)
nopaneltrue

Unprotect()

Excerpt Include
EW8:Worksheet.Unprotect()EW8:
Worksheet.Unprotect()
nopaneltrue

...

Overload

Description

ImportData(Cell, Microsoft.SharePoint.SPList, DataImportProperties)

Excerpt Include
EW8:SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList, DataImportProperties)EW8:
SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList, DataImportProperties)
nopaneltrue

ImportData(Cell, Microsoft.SharePoint.SPList)

Excerpt Include
EW8:SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList)EW8:
SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList)
nopaneltrue

ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)

Excerpt Include
EW8:SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)EW8:
SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)
nopaneltrue

ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)

Excerpt Include
EW8:SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)EW8:
SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)
nopaneltrue

...

Name

Description

Constants

Excerpt Include
EW8:Worksheet.ConstantsEW8:
Worksheet.Constants
nopaneltrue

SheetViewState

Excerpt Include
EW8:Worksheet.SheetViewStateEW8:
Worksheet.SheetViewState
nopaneltrue

SheetVisibility

Excerpt Include
EW8:Worksheet.SheetVisibilityEW8:
Worksheet.SheetVisibility
nopaneltrue

SummaryColumnsLocation

Excerpt Include
EW8:Worksheet.SummaryColumnsLocationEW8:
Worksheet.SummaryColumnsLocation
nopaneltrue

SummaryRowsLocation

Excerpt Include
EW8:Worksheet.SummaryRowsLocationEW8:
Worksheet.SummaryRowsLocation
nopaneltrue