.
| Description |
|---|
| Excerpt |
|---|
A Workbook object represents an Excel workbook. To return a |
| Signature | C# | C# | |
|---|---|---|---|
| Wiki Markup | |||
{description}
{excerpt}A [Workbook|Workbook] object represents an Excel workbook. To return a {{Workbook}} object: Call [ExcelApplication.Create\(\)|ExcelApplication.Create()] to create a new Excel workbook. Call [ExcelApplication.Open\(\)|ExcelApplication.Open] to open an existing Excel workbook.{excerpt}
{signature:C#}
[DefaultMember("Item")]
public sealed class Workbook : System.Collections.Generic.IEnumerable<Worksheet>
| |||
| Signature | |||
{signature}{signature:vb.net | vb.net | }
<DefaultMember("Item")> _
Public NotInheritable Class Workbook
Implements System.Collections.Generic.IEnumerable(Of Worksheet)
| |
| Example | |||
| Code Block | | csharp | csharp |
| title | C# | ||
| Code Block | vb.net | title |
| Properties |
|---|
...
Name
...
Description
...
...
{code} {example} {properties} ||Name||Description|| |[DisplayTabs|Workbook.DisplayTabs]|{excerpt-include:Workbook.DisplayTabs |
...
|nopanel=true}| |[DocumentProperties|Workbook.DocumentProperties]|{excerpt-include |
...
:Workbook.DocumentProperties |
...
|nopanel=true}| |[EncryptPassword|Workbook.EncryptPassword]|{excerpt-include |
...
:Workbook.EncryptPassword |
...
|nopanel=true}| |[ExcludeMacros|Workbook.ExcludeMacros]|{excerpt-include |
...
:Workbook.ExcludeMacros |
...
|nopanel=true}| |[FirstDisplayedTab|Workbook.FirstDisplayedTab]|{excerpt-include |
...
:Workbook.FirstDisplayedTab |
...
|nopanel=true}| |[Height|Workbook.Height]|{excerpt-include |
...
:Workbook.Height |
...
|nopanel=true}| |[HorizontalPosition|Workbook.HorizontalPosition]|{excerpt-include |
...
:Workbook.HorizontalPosition |
...
|nopanel=true}| |[IsProtected|Workbook.IsProtected]|{excerpt-include |
...
:Workbook.IsProtected |
...
|nopanel=true}| |[NamedRanges|Workbook.NamedRanges]|{excerpt-include |
...
:Workbook.NamedRanges |
...
|nopanel=true}| |[NumberFormat|Workbook.NumberFormat]|{excerpt-include |
...
:Workbook.NumberFormat |
...
|nopanel=true}| |[Palette|Workbook.Palette]|{excerpt-include |
...
:Workbook.Palette |
...
|nopanel=true}| |[PasswordToModify|Workbook.PasswordToModify]|{excerpt-include |
...
:Workbook.PasswordToModify |
...
|nopanel=true}| |[ProtectPasswordHash|Workbook.ProtectPasswordHash]|{excerpt-include |
...
:Workbook.ProtectPasswordHash |
...
|nopanel=true}| |[ReadOnly|Workbook.ReadOnly]|{excerpt-include |
...
:Workbook.ReadOnly |
...
|nopanel=true}| |[ReadOnlyRecommended|Workbook.ReadOnlyRecommended]|{excerpt-include |
...
:Workbook.ReadOnlyRecommended |
...
|nopanel=true}| |[ShowHorizontalScrollBar|Workbook.ShowHorizontalScrollBar]|{excerpt-include |
...
:Workbook.ShowHorizontalScrollBar |
...
|nopanel=true}| |[ShowVerticalScrollBar|Workbook.ShowVerticalScrollBar]|{excerpt-include |
...
:Workbook.ShowVerticalScrollBar |
...
|nopanel=true}| |[TabRatio|Workbook.TabRatio]|{excerpt-include |
...
:Workbook.TabRatio |
...
|nopanel=true}| |[UseRCFormulaNotation|Workbook.UseRCFormulaNotation]|{excerpt-include |
...
:Workbook.UseRCFormulaNotation |
...
|nopanel=true}| |[VerticalPosition|Workbook.VerticalPosition]|{excerpt-include |
...
:Workbook.VerticalPosition |
...
|nopanel=true}| |[Width|Workbook.Width]|{excerpt-include |
...
:Workbook.Width |
...
|nopanel=true}| |[Worksheets|Workbook.Worksheets]|{excerpt-include |
...
:Workbook.Worksheets |
...
| Indexers |
|---|
...
Name
...
Description
|nopanel=true}| {indexers} ||Name||Description|| |[Item(Int32) |
...
|Workbook.Item(Int32) |
...
]|{excerpt-include:Workbook.Item(Int32) |
...
|nopanel |
...
=true}| |[Item(String) |
...
|Workbook.Item(String) |
...
]|{excerpt-include:Workbook.Item(String) |
...
|nopanel |
...
| Methods |
|---|
...
Name
...
Description
...
...
=true}| {methods} ||Name||Description|| |[CreateConditionalFormat()|Workbook.CreateConditionalFormat() |
...
]|{excerpt-include:Workbook.CreateConditionalFormat() |
...
|nopanel |
...
=true}| |[CreateCopyPasteProperties(CopyPasteType) |
...
|Workbook.CreateCopyPasteProperties(CopyPasteProperties.CopyPasteType) |
...
]|{excerpt-include:Workbook.CreateCopyPasteProperties(CopyPasteProperties.CopyPasteType) |
...
|nopanel |
...
=true}| |[CreateDataImportProperties() |
...
|Workbook.CreateDataImportProperties() |
...
]|{excerpt-include:Workbook.CreateDataImportProperties() |
...
|nopanel |
...
=true}| |[CreateDataValidation(ValidationType, ComparisonType, Object) |
...
|Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, Object) |
...
]|{excerpt-include:Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, Object) |
...
|nopanel |
...
=true}| |[CreateDataValidation(ValidationType, ComparisonType, Object, Object) |
...
|Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object) |
...
]|{excerpt-include:Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object) |
...
|nopanel |
...
=true}| |[CreateDataValidation(ValidationType, ComparisonType, String) |
...
|Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, String) |
...
]|{excerpt-include:Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, String) |
...
|nopanel |
...
=true}| |[CreateDataValidation(ValidationType, ComparisonType, String, String) |
...
|Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, String, String) |
...
]|{excerpt-include:Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, String, String) |
...
|nopanel |
...
=true}| |[CreateDataValidation(ValidationType, Object) |
...
|Workbook.CreateDataValidation(DataValidation.ValidationType, Object) |
...
]|{excerpt-include:Workbook.CreateDataValidation(DataValidation.ValidationType, Object) |
...
|nopanel |
...
=true}| |[CreateDataValidation(ValidationType, String) |
...
|Workbook.CreateDataValidation(DataValidation.ValidationType, String) |
...
]|{excerpt-include:Workbook.CreateDataValidation(DataValidation.ValidationType, String) |
...
|nopanel |
...
=true}| |[CreateNamedRange(Area(), String) |
...
|Workbook.CreateNamedRange(Area(), String) |
...
]|{excerpt-include:Workbook.CreateNamedRange(Area(), String) |
...
|nopanel |
...
=true}| |[CreateNamedRange(String, String) |
...
|Workbook.CreateNamedRange(String, String) |
...
]|{excerpt-include:Workbook.CreateNamedRange(String, String) |
...
|nopanel |
...
=true}| |[CreateNamedStyle(String) |
...
|Workbook.CreateNamedStyle(String) |
...
]|{excerpt-include:Workbook.CreateNamedStyle(String) |
...
|nopanel |
...
=true}| |[CreateRange(String) |
...
|Workbook.CreateRange(String) |
...
]|{excerpt-include:Workbook.CreateRange(String) |
...
|nopanel |
...
=true}| |[CreateRange(Area()) |
...
|Workbook.CreateRange(Area()) |
...
]|{excerpt-include:Workbook.CreateRange(Area()) |
...
|nopanel |
...
=true}| |[CreateStyle() |
...
|Workbook.CreateStyle() |
...
]|{excerpt-include:Workbook.CreateStyle() |
...
|nopanel |
...
=true}| |[GetEnumerator() |
...
|Workbook.GetEnumerator() |
...
]|{excerpt-include:Workbook.GetEnumerator() |
...
|nopanel |
...
=true}| |[GetNamedObject(String) |
...
|Workbook.GetNamedObject(String) |
...
]|{excerpt-include:Workbook.GetNamedObject(String) |
...
|nopanel |
...
=true}| |[GetNamedRange(String) |
...
|Workbook.GetNamedRange(String) |
...
]|{excerpt-include:Workbook.GetNamedRange(String) |
...
|nopanel |
...
=true}| |[GetNamedStyle(String) |
...
|Workbook.GetNamedStyle(String) |
...
]|{excerpt-include:Workbook.GetNamedStyle(String) |
...
|nopanel |
...
=true}| |[GetTextHeight(String, Font, Double) |
...
|Workbook.GetTextHeight(String, Font, Double) |
...
]|{excerpt-include:Workbook.GetTextHeight(String, Font, Double) |
...
|nopanel |
...
=true}| |[GetTextWidth(String, Font, Double) |
...
|Workbook.GetTextWidth(String, Font, Double) |
...
]|{excerpt-include:Workbook.GetTextWidth(String, Font, Double) |
...
|nopanel |
...
=true}| |[Protect(String) |
...
|Workbook.Protect(String) |
...
]|{excerpt-include:Workbook.Protect(String) |
...
|nopanel |
...
=true}| |[Unprotect() |
...
|Workbook.Unprotect() |
...
]|{excerpt-include:Workbook.Unprotect() |
...
|nopanel |
...
=true}| |