Code Block |
---|
|
//--- Create a new Worksheet
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
Worksheet ws = wb.Worksheets.CreateWorksheet("Sheet2");
//--- Get an existing Worksheet by index
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
Worksheet ws = wb.Worksheets[0];
//--- Get an existing Worksheet by name
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
Worksheet ws = wb.Worksheets["Sheet1"];
| {code}
{code:|title=} |
'--- Create a new Worksheet
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim ws As Worksheet = wb.Worksheets.CreateWorksheet("Sheet2")
'--- Get an existing Worksheet by index
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim ws As Worksheet = wb.Worksheets(0)
'--- Get an existing Worksheet by name
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim ws As Worksheet = wb.Worksheets("Sheet2")
| {code}
{example}
{properties}
|| Name || Description ||
| [Cells|Worksheet.Cells] | {excerpt-include:Worksheet.Cells|nopanel=true} |
| [Charts|Worksheet.Charts] | {excerpt-include:Worksheet.Charts|nopanel=true} |
| [Comments|Worksheet.Comments] | {excerpt-include:Worksheet.Comments|nopanel=true} |
| [FirstShownColumn|Worksheet.FirstShownColumn] | {excerpt-include:Worksheet.FirstShownColumn|nopanel=true} |
| [FirstShownRow|Worksheet.FirstShownRow] | {excerpt-include:Worksheet.FirstShownRow|nopanel=true} |
| [FreezePanes|Worksheet.FreezePanes] | {excerpt-include:Worksheet.FreezePanes|nopanel=true} |
| [GridlinesColor|Worksheet.GridlinesColor] | {excerpt-include:Worksheet.GridlinesColor|nopanel=true} |
| [Hyperlinks|Worksheet.Hyperlinks] | {excerpt-include:Worksheet.Hyperlinks|nopanel=true} |
| [IsProtected|Worksheet.IsProtected] | {excerpt-include:Worksheet.IsProtected|nopanel=true} |
| [IsSelected|Worksheet.IsSelected] | {excerpt-include:Worksheet.IsSelected|nopanel=true} |
| [Name|Worksheet.Name] | {excerpt-include:Worksheet.Name|nopanel=true} |
| [NamedRanges|Worksheet.NamedRanges] | {excerpt-include:Worksheet.NamedRanges|nopanel=true} |
| [PageSetup|Worksheet.PageSetup] | {excerpt-include:Worksheet.PageSetup|nopanel=true} |
| [Pictures|Worksheet.Pictures] | {excerpt-include:Worksheet.Pictures|nopanel=true} |
| [PopulatedCells|Worksheet.PopulatedCells] | {excerpt-include:Worksheet.PopulatedCells|nopanel=true} |
| [Position|Worksheet.Position] | {excerpt-include:Worksheet.Position|nopanel=true} |
| [ProtectPasswordHash|Worksheet.ProtectPasswordHash] | {excerpt-include:Worksheet.ProtectPasswordHash|nopanel=true} |
| [ShapeGroups|Worksheet.ShapeGroups] | {excerpt-include:Worksheet.ShapeGroups|nopanel=true} |
| [Shapes|Worksheet.Shapes] | {excerpt-include:Worksheet.Shapes|nopanel=true} |
| [SheetProtection|Worksheet.SheetProtection] | {excerpt-include:Worksheet.SheetProtection|nopanel=true} |
| [ShowFormulas|Worksheet.ShowFormulas] | {excerpt-include:Worksheet.ShowFormulas|nopanel=true} |
| [ShowGridlines|Worksheet.ShowGridlines] | {excerpt-include:Worksheet.ShowGridlines|nopanel=true} |
| [ShowRowColHeaders|Worksheet.ShowRowColHeaders] | {excerpt-include:Worksheet.ShowRowColHeaders|nopanel=true} |
| [ShowZeroValues|Worksheet.ShowZeroValues] | {excerpt-include:Worksheet.ShowZeroValues|nopanel=true} |
| [StandardHeight|Worksheet.StandardHeight] | {excerpt-include:Worksheet.StandardHeight|nopanel=true} |
| [StandardWidth|Worksheet.StandardWidth] | {excerpt-include:Worksheet.StandardWidth|nopanel=true} |
| [StandardWidthInChars|Worksheet.StandardWidthInChars] | {excerpt-include:Worksheet.StandardWidthInChars|nopanel=true} |
| [SummaryColumns|Worksheet.SummaryColumns] | {excerpt-include:Worksheet.SummaryColumns|nopanel=true} |
| [SummaryRows|Worksheet.SummaryRows] | {excerpt-include:Worksheet.SummaryRows|nopanel=true} |
| [TabColor|Worksheet.TabColor] | {excerpt-include:Worksheet.TabColor|nopanel=true} |
| [Workbook|Worksheet.Workbook] | {excerpt-include:Worksheet.Workbook|nopanel=true} |
| [ViewState|Worksheet.ViewState] | {excerpt-include:Worksheet.ViewState|nopanel=true} |
| [Visibility|Worksheet.Visibility] | {excerpt-include:Worksheet.Visibility|nopanel=true} |
| [ZoomPercentage|Worksheet.ZoomPercentage] | {excerpt-include:Worksheet.ZoomPercentage|nopanel=true} |
{indexers}
|| Name || Description ||
| [Item(Int32, Int32)|Worksheet.Item(Int32, Int32)] | {excerpt-include:Worksheet.Item(Int32, Int32)|nopanel=true} |
| [Item(String)|Worksheet.Item(String)] | {excerpt-include:Worksheet.Item(String)|nopanel=true} |
{methods}
|| Name || Description ||
| [CopyPaste(Cell, Area)|Worksheet.CopyPaste(Cell, Area)] | {excerpt-include:Worksheet.CopyPaste(Cell, Area)|nopanel=true} |
| [CopyPaste(Cell, Area, CopyPasteProperties)|Worksheet.CopyPaste(Cell, Area, CopyPasteProperties)] | {excerpt-include:Worksheet.CopyPaste(Cell, Area, CopyPasteProperties)|nopanel=true} |
| [CopyPaste(Int32, Int32, Area)|Worksheet.CopyPaste(Int32, Int32, Area)] | {excerpt-include:Worksheet.CopyPaste(Int32, Int32, Area)|nopanel=true} |
| [CopyPaste(Int32, Int32, Area, CopyPasteProperties)|Worksheet.CopyPaste(Int32, Int32, Area, CopyPasteProperties)] | {excerpt-include:Worksheet.CopyPaste(Int32, Int32, Area, CopyPasteProperties)|nopanel=true} |
| [CopyPaste(String, Area, CopyPasteProperties)|Worksheet.CopyPaste(String, Area, CopyPasteProperties)] | {excerpt-include:Worksheet.CopyPaste(String, Area, CopyPasteProperties)|nopanel=true} |
| [CopyPaste(String, Area)|Worksheet.CopyPaste(String, Area)] | {excerpt-include:Worksheet.CopyPaste(String, Area)|nopanel=true} |
| [CreateAnchor(Int32, Int32, Double, Double)|Worksheet.CreateAnchor(Int32, Int32, Double, Double)] | {excerpt-include:Worksheet.CreateAnchor(Int32, Int32, Double, Double)|nopanel=true} |
| [CreateArea(Int32, Int32, Int32, Int32)|Worksheet.CreateArea(Int32, Int32, Int32, Int32)] | {excerpt-include:Worksheet.CreateArea(Int32, Int32, Int32, Int32)|nopanel=true} |
| [CreateArea(String)|Worksheet.CreateArea(String)] | {excerpt-include:Worksheet.CreateArea(String)|nopanel=true} |
| [CreateAreaOfColumns(Int32, Int32)|Worksheet.CreateAreaOfColumns(Int32, Int32)] | {excerpt-include:Worksheet.CreateAreaOfColumns(Int32, Int32)|nopanel=true} |
| [CreateAreaOfRows(Int32, Int32)|Worksheet.CreateAreaOfRows(Int32, Int32)] | {excerpt-include:Worksheet.CreateAreaOfRows(Int32, Int32)|nopanel=true} |
| [CreateNamedRange(Int32, Int32, Int32, Int32, String)|Worksheet.CreateNamedRange(Int32, Int32, Int32, Int32, String)] | {excerpt-include:Worksheet.CreateNamedRange(Int32, Int32, Int32, Int32, String)|nopanel=true} |
| [CreateNamedRange(String, String)|Worksheet.CreateNamedRange(String, String)] | {excerpt-include:Worksheet.CreateNamedRange(String, String)|nopanel=true} |
| [CreateRange(String)|Worksheet.CreateRange(String)] | {excerpt-include:Worksheet.CreateRange(String)|nopanel=true} |
| [DeleteColumn(Int32)|Worksheet.DeleteColumn(Int32)] | {excerpt-include:Worksheet.DeleteColumn(Int32)|nopanel=true} |
| [DeleteColumns(Int32, Int32)|Worksheet.DeleteColumns(Int32, Int32)] | {excerpt-include:Worksheet.DeleteColumns(Int32, Int32)|nopanel=true} |
| [DeleteRow(Int32)|Worksheet.DeleteRow(Int32)] | {excerpt-include:Worksheet.DeleteRow(Int32)|nopanel=true} |
| [DeleteRows(Int32, Int32)|Worksheet.DeleteRows(Int32, Int32)] | {excerpt-include:Worksheet.DeleteRows(Int32, Int32)|nopanel=true} |
| [GetColumnProperties(Int32)|Worksheet.GetColumnProperties(Int32)] | {excerpt-include:Worksheet.GetColumnProperties(Int32)|nopanel=true} |
| [GetNamedObject(String)|Worksheet.GetNamedObject(String)] | {excerpt-include:Worksheet.GetNamedObject(String)|nopanel=true} |
| [GetNamedRange(String)|Worksheet.GetNamedRange(String)] | {excerpt-include:Worksheet.GetNamedRange(String)|nopanel=true} |
| [GetRowProperties(Int32)|Worksheet.GetRowProperties(Int32)] | {excerpt-include:Worksheet.GetRowProperties(Int32)|nopanel=true} |
| [GroupColumns(Int32, Int32, Boolean)|Worksheet.GroupColumns(Int32, Int32, Boolean)] | {excerpt-include:Worksheet.GroupColumns(Int32, Int32, Boolean)|nopanel=true} |
| [GroupRows(Int32, Int32, Boolean)|Worksheet.GroupRows(Int32, Int32, Boolean)] | {excerpt-include:Worksheet.GroupRows(Int32, Int32, Boolean)|nopanel=true} |
| [ImportData(Object()(), Cell)| |