DECS Excel Add-Ins
1.3.0.2
Creates custom buttons in Excel to automate DECS tasks.
Loading...
Searching...
No Matches
Here is a list of all documented functions with links to the class documentation for each member:
- a -
AddCleaningRule() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.NotesConfig
AddExtractRule() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.NotesConfig
AllAvailableRows() :
DECS_Excel_Add_Ins.Utilities
AllRows() :
DECS_Excel_Add_Ins.ProcessingRowsSelection
AllRules() :
DECS_Excel_Add_Ins.DefineRulesForm
AssignDelete() :
DECS_Excel_Add_Ins.RuleGui
AssignDisable() :
DECS_Excel_Add_Ins.RuleGui
AssignEnable() :
DECS_Excel_Add_Ins.RuleGui
AssignExternalDelete() :
DECS_Excel_Add_Ins.CleaningRuleGui
,
DECS_Excel_Add_Ins.ExtractRuleGui
AssignExternalRuleChanged() :
DECS_Excel_Add_Ins.CleaningRuleGui
,
DECS_Excel_Add_Ins.ExtractRuleGui
AssignWorksheetChangedCallback() :
DECS_Excel_Add_Ins.NotesParser
- b -
buildListButton_GetImage() :
DECS_Excel_Add_Ins.DecsExcelRibbon
- c -
CenterlineTheMain() :
DECS_Excel_Add_Ins.Formatter
ChangeCleaningRuleDisplayName() :
DECS_Excel_Add_Ins.NotesConfig
ChangeCleaningRulePattern() :
DECS_Excel_Add_Ins.NotesConfig
ChangeCleaningRuleReplace() :
DECS_Excel_Add_Ins.NotesConfig
ChangeExtractRuleDisplayName() :
DECS_Excel_Add_Ins.NotesConfig
ChangeExtractRulenewColumn() :
DECS_Excel_Add_Ins.NotesConfig
ChangeExtractRulePattern() :
DECS_Excel_Add_Ins.NotesConfig
CheckBoxClicked() :
DECS_Excel_Add_Ins.RuleGui
ChooseConfigFile() :
DECS_Excel_Add_Ins.NotesConfig
Clean() :
DECS_Excel_Add_Ins.NotesParser
CleaningRules() :
DECS_Excel_Add_Ins.DefineRulesForm
cleaningRulesAddButton_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
cleaningRulesDisplayNameTextBox_TextChanged() :
DECS_Excel_Add_Ins.CleaningRuleGui
cleaningRulesPatternTextBox_TextChanged() :
DECS_Excel_Add_Ins.CleaningRuleGui
cleaningRulesReplaceTextBox_TextChanged() :
DECS_Excel_Add_Ins.CleaningRuleGui
Clear() :
DECS_Excel_Add_Ins.CleaningRuleGui
,
DECS_Excel_Add_Ins.ExtractRuleGui
,
DECS_Excel_Add_Ins.RuleGui
clearButton_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
ClearRegexInvalid() :
DECS_Excel_Add_Ins.Utilities
Convert() :
DECS_Excel_Add_Ins.DateConverter
,
DECS_Excel_Add_Ins.Geocode
,
DECS_Excel_Add_Ins.ZipCodeConverter
ConvertColumn() :
DECS_Excel_Add_Ins.MumpsDateConverter
ConvertDatesToStandardFormat() :
DECS_Excel_Add_Ins.NotesParser
ConvertExcelDate() :
DECS_Excel_Add_Ins.Utilities
ConvertThisColumn() :
DECS_Excel_Add_Ins.MumpsDateConverter
CreateStatusForm() :
DECS_Excel_Add_Ins.NotesParser
- d -
dateConversionEnabledCheckBox_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
dateConvertButton_GetImage() :
DECS_Excel_Add_Ins.DecsExcelRibbon
dateFormatsListBox_SelectedIndexChanged() :
DECS_Excel_Add_Ins.DefineRulesForm
Delete() :
DECS_Excel_Add_Ins.RuleGui
DeleteAllRules() :
DECS_Excel_Add_Ins.DefineRulesForm
DeleteCleaningRule() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.NotesConfig
DeleteExtractRule() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.NotesConfig
DeleteRule() :
DECS_Excel_Add_Ins.CleaningRuleGui
,
DECS_Excel_Add_Ins.ExtractRuleGui
DetachEvents() :
DECS_Excel_Add_Ins.Utilities
DetermineDataType() :
DECS_Excel_Add_Ins.ListImporter
DisableCleaningRule() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.NotesConfig
DisableExtractRule() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.NotesConfig
discardButton_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
Dispose() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.RulesErrorForm
,
DECS_Excel_Add_Ins.StatusForm
- e -
EnableCleaningRule() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.NotesConfig
EnableExtractRule() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.NotesConfig
Extract() :
DECS_Excel_Add_Ins.NotesParser
ExtractRow() :
DECS_Excel_Add_Ins.ListImporter
ExtractRuleGui() :
DECS_Excel_Add_Ins.ExtractRuleGui
ExtractRules() :
DECS_Excel_Add_Ins.DefineRulesForm
extractRulesAddButton_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
extractRulesDisplayNameTextBox_TextChanged() :
DECS_Excel_Add_Ins.ExtractRuleGui
extractRulesnewColumnTextBox_TextChanged() :
DECS_Excel_Add_Ins.ExtractRuleGui
extractRulesPatternTextBox_TextChanged() :
DECS_Excel_Add_Ins.ExtractRuleGui
- f -
FindLastCol() :
DECS_Excel_Add_Ins.Utilities
FindLastRow() :
DECS_Excel_Add_Ins.Utilities
FindNamedColumn() :
DECS_Excel_Add_Ins.SviProcessor
FindNth() :
DECS_Excel_Add_Ins.RuleGui
FindToolTip() :
DECS_Excel_Add_Ins.Utilities
FIPS() :
DECS_Excel_Add_Ins.CensusData
FitHeader() :
DECS_Excel_Add_Ins.Formatter
Format() :
DECS_Excel_Add_Ins.Formatter
formatButton_GetImage() :
DECS_Excel_Add_Ins.DecsExcelRibbon
FormOutputFilename() :
DECS_Excel_Add_Ins.Utilities
FreezePane() :
DECS_Excel_Add_Ins.Formatter
- g -
GetColumnNames() :
DECS_Excel_Add_Ins.Utilities
GetColumnNamesDictionary() :
DECS_Excel_Add_Ins.Utilities
GetEta() :
DECS_Excel_Add_Ins.StopWatchUtils
GetReason() :
DECS_Excel_Add_Ins.ProcessingRowsSelection
GetRows() :
DECS_Excel_Add_Ins.ProcessingRowsSelection
GetSelectedCol() :
DECS_Excel_Add_Ins.Utilities
GetSelectedCols() :
DECS_Excel_Add_Ins.Utilities
GetSelectedColumns() :
DECS_Excel_Add_Ins.MumpsDateConverter
GetTimestamp() :
DECS_Excel_Add_Ins.Utilities
GrayOutTheNulls() :
DECS_Excel_Add_Ins.Formatter
- h -
HasCleaningRules() :
DECS_Excel_Add_Ins.NotesConfig
HasConfig() :
DECS_Excel_Add_Ins.NotesParser
HasData() :
DECS_Excel_Add_Ins.Utilities
HasDateConversionRule() :
DECS_Excel_Add_Ins.NotesConfig
HasExtractRules() :
DECS_Excel_Add_Ins.NotesConfig
Height() :
DECS_Excel_Add_Ins.RuleGui
- i -
Index() :
DECS_Excel_Add_Ins.RuleGui
InitializeComponent() :
DECS_Excel_Add_Ins.DefineRulesForm
,
DECS_Excel_Add_Ins.RulesErrorForm
,
DECS_Excel_Add_Ins.StatusForm
InsertNewColumn() :
DECS_Excel_Add_Ins.Utilities
InternalStartup() :
DECS_Excel_Add_Ins.ThisAddIn
IsFirstRowSelected() :
DECS_Excel_Add_Ins.Formatter
IsIndexColumn() :
DECS_Excel_Add_Ins.ListImporter
IsRegexValid() :
DECS_Excel_Add_Ins.Utilities
- l -
ListImporter() :
DECS_Excel_Add_Ins.ListImporter
loadToolStripMenuItem_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
- m -
MarkRegexInvalid() :
DECS_Excel_Add_Ins.Utilities
MoveOffFirstRow() :
DECS_Excel_Add_Ins.Formatter
MoveUpInLine() :
DECS_Excel_Add_Ins.RuleGui
- n -
NameToDataType() :
DECS_Excel_Add_Ins.ListImporter
NextRuleGui() :
DECS_Excel_Add_Ins.RuleGui
notesConfigButton_GetImage() :
DECS_Excel_Add_Ins.DecsExcelRibbon
NotesParser() :
DECS_Excel_Add_Ins.NotesParser
notesSearchButton_GetImage() :
DECS_Excel_Add_Ins.DecsExcelRibbon
NumRows() :
DECS_Excel_Add_Ins.ProcessingRowsSelection
NumRulesThisType() :
DECS_Excel_Add_Ins.DefineRulesForm
- o -
OnAddSVI() :
DECS_Excel_Add_Ins.DecsExcelRibbon
OnBuildList() :
DECS_Excel_Add_Ins.DecsExcelRibbon
OnConvertDates() :
DECS_Excel_Add_Ins.DecsExcelRibbon
OnFormat() :
DECS_Excel_Add_Ins.DecsExcelRibbon
OnSearchConfig() :
DECS_Excel_Add_Ins.DecsExcelRibbon
OnSearchNotes() :
DECS_Excel_Add_Ins.DecsExcelRibbon
- p -
Parse() :
DECS_Excel_Add_Ins.NotesParser
Populate() :
DECS_Excel_Add_Ins.CleaningRuleGui
,
DECS_Excel_Add_Ins.ExtractRuleGui
PopulateDateConversionRule() :
DECS_Excel_Add_Ins.DefineRulesForm
PopulateDateFormatsListBox() :
DECS_Excel_Add_Ins.DefineRulesForm
PopulateSourceColumnListBox() :
DECS_Excel_Add_Ins.DefineRulesForm
processingStopButton_Click() :
DECS_Excel_Add_Ins.StatusForm
- r -
rank() :
DECS_Excel_Add_Ins.SviTable
raw() :
DECS_Excel_Add_Ins.SviTable
ReadConfigFile() :
DECS_Excel_Add_Ins.NotesConfig
RearrangeCleaningControls() :
DECS_Excel_Add_Ins.DefineRulesForm
RearrangeControls() :
DECS_Excel_Add_Ins.DefineRulesForm
RearrangeExtractControls() :
DECS_Excel_Add_Ins.DefineRulesForm
RegisterChanges() :
DECS_Excel_Add_Ins.DefineRulesForm
Reset() :
DECS_Excel_Add_Ins.StatusForm
ResetAfterProcessing() :
DECS_Excel_Add_Ins.NotesParser
ResetLocation() :
DECS_Excel_Add_Ins.RuleGui
ResetWorksheet() :
DECS_Excel_Add_Ins.NotesParser
RestoreOriginalColumns() :
DECS_Excel_Add_Ins.NotesParser
RestoreOriginalSourceColumn() :
DECS_Excel_Add_Ins.NotesParser
RuleGui() :
DECS_Excel_Add_Ins.RuleGui
RuleValidationResult() :
DECS_Excel_Add_Ins.RuleValidationResult
runButton_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
- s -
Save() :
DECS_Excel_Add_Ins.DefineRulesForm
SaveAs() :
DECS_Excel_Add_Ins.DefineRulesForm
saveAsToolStripMenuItem_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
saveButton_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
SaveOriginalSourceColumn() :
DECS_Excel_Add_Ins.NotesParser
SaveRevised() :
DECS_Excel_Add_Ins.NotesParser
saveToolStripMenuItem_Click() :
DECS_Excel_Add_Ins.DefineRulesForm
Scan() :
DECS_Excel_Add_Ins.ListImporter
,
DECS_Excel_Add_Ins.SviProcessor
SetBorders() :
DECS_Excel_Add_Ins.Formatter
SetRunButtonStatus() :
DECS_Excel_Add_Ins.DefineRulesForm
SetSourceColumn() :
DECS_Excel_Add_Ins.DefineRulesForm
ShowCleaningResult() :
DECS_Excel_Add_Ins.DefineRulesForm
ShowDateConversionResult() :
DECS_Excel_Add_Ins.DefineRulesForm
ShowExtractResult() :
DECS_Excel_Add_Ins.DefineRulesForm
ShowRow() :
DECS_Excel_Add_Ins.NotesParser
ShowSelectedRows() :
DECS_Excel_Add_Ins.DefineRulesForm
sourceColumnListBox_Selected() :
DECS_Excel_Add_Ins.DefineRulesForm
StatusForm() :
DECS_Excel_Add_Ins.StatusForm
StopProcessing() :
DECS_Excel_Add_Ins.NotesParser
SupportedDateFormats() :
DECS_Excel_Add_Ins.DateConverter
sviButton_GetImage() :
DECS_Excel_Add_Ins.DecsExcelRibbon
- t -
TopOfNamedColumn() :
DECS_Excel_Add_Ins.Utilities
ToString() :
DECS_Excel_Add_Ins.RuleValidationResult
- u -
UpdateConfig() :
DECS_Excel_Add_Ins.NotesParser
UpdateCount() :
DECS_Excel_Add_Ins.StatusForm
UpdatePredictedCompletion() :
DECS_Excel_Add_Ins.StatusForm
UpdateProgressBar() :
DECS_Excel_Add_Ins.StatusForm
UpdateProgressBarLabel() :
DECS_Excel_Add_Ins.StatusForm
UpdateStatusLabel() :
DECS_Excel_Add_Ins.StatusForm
- v -
Valid() :
DECS_Excel_Add_Ins.RuleValidationResult
ValidateAndWarn() :
DECS_Excel_Add_Ins.NotesParser
ValidateRules() :
DECS_Excel_Add_Ins.NotesConfig
ValidCleaningRules() :
DECS_Excel_Add_Ins.NotesConfig
ValidExtractRules() :
DECS_Excel_Add_Ins.NotesConfig
- w -
WarnColumnNotFound() :
DECS_Excel_Add_Ins.Utilities
WhichRowsToProcess() :
DECS_Excel_Add_Ins.NotesParser
WorksheetSelectionChanged() :
DECS_Excel_Add_Ins.NotesParser
WrapText() :
DECS_Excel_Add_Ins.Formatter
WriteMainHeader() :
DECS_Excel_Add_Ins.ListImporter
- z -
ZipCodeConverter() :
DECS_Excel_Add_Ins.ZipCodeConverter
Generated by
1.10.0