Параметры SaveToDB для использования в VBA

Интерфейс IAddInOptions определяет свойства надстройки SaveToDB, которые можно использовать в макросах VBA и надстройках VSTO.

<ComVisible(True), Guid("CF0170F1-310E-421F-87DF-C177753EEDD9")>
Public Interface IAddInOptions

    ' Общие параметры

    Property DisplayLanguage As String

    Property DefaultDataLanguage As String

    Property WorkbookDataLanguage(Optional Workbook As Workbook = Nothing) As String

    Property EncryptPasswordsByDefault As Boolean

    Property EncryptWorkbookPasswords(Optional Workbook As Workbook = Nothing) As Boolean?

    Property ConnectionTimeout As Int32

    Property CommandTimeout As Int32

    Property MaxMemoryLines As Int32

    Property MaxLoadedRows As Int32

    Property UpdateChangedCellsOnly As Boolean

    ' Параметры Excel

    Property ShowUrlMenu As Boolean

    Property ShowContextMenu As Boolean

    Property ShowDoubleClickCalendar As Boolean

    Property ShowDoubleClickPivot As Boolean

    Property AutoFilterRow As Boolean

    Property AutoOpenLastFile As Boolean

    Property KeepFormulas As Boolean

    Property AutoFormatNotNullColumns As Boolean

    ' Параметры Excel, удаленные в SaveToDB 9

    Property AutoActivateTableRelatedWindows As Boolean

    Property AutoArrangeWindows As Boolean

    Property AutoHideTaskbarMdiWindows As Boolean

    Property AutoCleanBadNamedCells As Boolean

    ' Параметры Ribbon

    Property HideAdvancedMenuItems As Boolean

    Property ParameterHistoryLimit As Int32

    ' Параметры меню

    Property ShowRowEditor As Boolean

    Property ShowCellEditor As Boolean

    Property ShowListEditor As Boolean

    ' Специальные параметры

    Property TemplatePath As String

    Property FrameworkPath As String

    Property ApplicationPath As String

    Property ShowToolsMenu As Boolean?

    ' Панели задач

    Property TaskPaneDockPosition As Int32

    ' Редактор строк

    Property RowEditorDockPosition As Int32

    Property RowEditorTop As Int32

    Property RowEditorLeft As Int32

    Property RowEditorHeight As Int32

    Property RowEditorWidth As Int32

    Property RowEditorDockHeight As Int32

    Property RowEditorDockWidth As Int32

    Property RowEditorFontSize As Single

    Property RowEditorFontName As String

    ' Редактор ячеек

    Property CellEditorDockPosition As Int32

    Property CellEditorTop As Int32

    Property CellEditorLeft As Int32

    Property CellEditorHeight As Int32

    Property CellEditorWidth As Int32

    Property CellEditorDockHeight As Int32

    Property CellEditorDockWidth As Int32

    Property CellEditorFontSize As Single

    Property CellEditorFontName As String

    ' Редактор списков

    Property ListEditorDockPosition As Int32

    Property ListEditorTop As Int32

    Property ListEditorLeft As Int32

    Property ListEditorHeight As Int32

    Property ListEditorWidth As Int32

    Property ListEditorDockHeight As Int32

    Property ListEditorDockWidth As Int32

    Property ListEditorFontSize As Single

    Property ListEditorFontName As String

    ' Логи

    Property LogPath As String

    Property TraceSQL As Boolean

    Property TraceLoader As Boolean

End Interface