Параметры SaveToDB для использования в VBA
Интерфейс IAddInOptions определяет свойства надстройки SaveToDB.
Вы можете использовать эти свойства из макросов VBA и надстроек VSTO.
<ComVisible(True), Guid("CF0170F1-310E-421F-87DF-C177753EEDD9")> Public Interface IAddInOptions ' Common Options 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 Options 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 Options Removed in SaveToDB 9 Property AutoActivateTableRelatedWindows As Boolean Property AutoArrangeWindows As Boolean Property AutoHideTaskbarMdiWindows As Boolean Property AutoCleanBadNamedCells As Boolean ' Ribbon Options Property HideAdvancedMenuItems As Boolean Property ParameterHistoryLimit As Int32 ' Options Menu Property ShowRowEditor As Boolean Property ShowCellEditor As Boolean Property ShowListEditor As Boolean ' Special Options Property TemplatePath As String Property FrameworkPath As String Property ApplicationPath As String Property ShowToolsMenu As Boolean? ' TaskPanes Property TaskPaneDockPosition As Int32 ' Row Editor 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 ' Cell Editor 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 ' List Editor 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 ' Logs Property LogPath As String Property TraceSQL As Boolean Property TraceLoader As Boolean End Interface