Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2012
Office Development in Visual Studio
Create Add-ins and Customizations for Office by using Visual Studio
Managed Reference (Office Development in Visual Studio)
Microsoft.Office.Tools.Excel
WorkbookBase Class
WorkbookBase Properties
_CodeName Property
_ReadOnlyRecommended Property
AcceptLabelsInFormulas Property
AccuracyVersion Property
ActiveChart Property
ActiveSheet Property
ActiveSlicer Property
Application Property
Author Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
Base Property
BindingContext Property
BuiltinDocumentProperties Property
CalculationVersion Property
ChangeHistoryDuration Property
Charts Property
CheckCompatibility Property
CodeName Property
Colors Property
CommandBars Property
Comments Property
ConflictResolution Property
Connections Property
ConnectionsDisabled Property
Container Property
ContentTypeProperties Property
CreateBackup Property
Creator Property
CustomDocumentProperties Property
CustomViews Property
CustomXMLParts Property
DataBindings Property
DataHost Property
Date1904 Property
DefaultPivotTableStyle Property
DefaultSlicerStyle Property
DefaultTableStyle Property
DialogSheets Property
DisplayDrawingObjects Property
DisplayInkComments Property
DocumentInspectors Property
DocumentLibraryVersions Property
DoNotPromptForConvert Property
EnableAutoRecover Property
EncryptionProvider Property
EnvelopeVisible Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
Excel8CompatibilityMode Property
IExtension.ExtensionBase Property
FileFormat Property
Final Property
ForceFullCalculation Property
FullName Property
FullNameURLEncoded Property
HasMailer Property
HasPassword Property
HasRoutingSlip Property
HasVBProject Property
HighlightChangesOnScreen Property
HostContext Property
HTMLProject Property
IconSets Property
InactiveListBorderVisible Property
InnerObject Property
IsAddin Property
IsInplace Property
ItemProvider Property
KeepChangeHistory Property
Keywords Property
ListChangesOnNewSheet Property
Mailer Property
Modules Property
MultiUserEditing Property
Name Property
Names Property
OnSave Property
OnSheetActivate Property
OnSheetDeactivate Property
Parent Property
Password Property
PasswordEncryptionAlgorithm Property
PasswordEncryptionFileProperties Property
PasswordEncryptionKeyLength Property
PasswordEncryptionProvider Property
Path Property
Permission Property
PersonalViewListSettings Property
PersonalViewPrintSettings Property
PrecisionAsDisplayed Property
ProtectStructure Property
ProtectWindows Property
PublishObjects Property
ReadOnly Property
ReadOnlyRecommended Property
RemovePersonalInformation Property
Research Property
RevisionNumber Property
Routed Property
RoutingSlip Property
Saved Property
SaveLinkValues Property
ServerPolicy Property
ServerViewableItems Property
SharedWorkspace Property
Sheets Property
ShowConflictHistory Property
ShowPivotChartActiveFields Property
ShowPivotTableFieldList Property
Signatures Property
Site Property
SlicerCaches Property
SmartDocument Property
SmartTagOptions Property
Styles Property
Subject Property
Sync Property
TableStyles Property
Tag Property
TemplateRemoveExtData Property
Theme Property
Title Property
UpdateLinks Property
UpdateRemoteReferences Property
UserControl Property
UserStatus Property
VBASigned Property
VBProject Property
VstoSmartTags Property
WebOptions Property
Windows Property
Worksheets Property
WritePassword Property
WriteReserved Property
WriteReservedBy Property
XmlMaps Property
XmlNamespaces Property
Expand Minimize
This topic has not yet been rated - Rate this topic

WorkbookBase.DefaultTableStyle Property

Visual Studio 2012

Gets or sets the table style from the TableStyles property that is used as the default style for tables in the workbook.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
C#
VB
Copy 
public Object DefaultTableStyle { get; set; }

Property Value

Type: Object
The table style from the TableStyles property that is used as the default style for tables in the workbook.

The following code example sets the default style of tables to Table Style Dark 11, which is a style that is available in Excel on the Design tab in the Table Styles group when a table is selected. The example then adds a table to verify the new table style.

This example is for a document-level customization.

C#
VB
Copy 
private void SetTableStyle()
{
    this.DefaultTableStyle = this.TableStyles["TableStyleDark11"];

    // Add a table to verify the new default table style
    Microsoft.Office.Tools.Excel.ListObject myTable =
    Globals.Sheet1.Controls.AddListObject(
        Globals.Sheet1.Range["A1", "B3"], "myTable");
}
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.