Method | Description | |
---|---|---|
SaveAsUnicodeCSV ( bool force, bool newFile ) : void |
This will create a temporary file in Unicode text (*.txt) format, overwrite the current loaded file by replaing all tabs with a comma and reload the file.
|
Method | Description | |
---|---|---|
CreateRibbonExtensibilityObject ( ) : Microsoft.Office.Core.IRibbonExtensibility |
Method | Description | |
---|---|---|
InternalStartup ( ) : void |
Required method for Designer support - do not modify the contents of this method with the code editor.
|
|
ThisAddIn_Shutdown ( object sender, |
||
ThisAddIn_Startup ( object sender, System e ) : void | ||
app_WorkbookBeforeClose ( Microsoft.Office.Interop.Excel Wb, bool &Cancel ) : void | ||
app_WorkbookBeforeSave ( Microsoft.Office.Interop.Excel Wb, bool SaveAsUI, bool &Cancel ) : void | ||
app_WorkbookOpen ( Microsoft.Office.Interop.Excel Wb ) : void | ||
isFileUnicode ( string filename ) : bool |
This method will try and read the first few bytes to see if it contains a Unicode BOM
|
|
isInCellEditingMode ( ) : bool |
This method check whether Excel is in Cell Editing mode or not There are few ways to check this (eg. check to see if a standard menu item is disabled etc.) I know in cell editing mode app.DisplayAlerts throws an Exception, so here I'm relying on that behaviour
|
protected CreateRibbonExtensibilityObject ( ) : Microsoft.Office.Core.IRibbonExtensibility | ||
return | Microsoft.Office.Core.IRibbonExtensibility |
public SaveAsUnicodeCSV ( bool force, bool newFile ) : void | ||
force | bool | To force save the current file as a Unicode CSV. /// When called from the Ribbon items Save/SaveAs, force will be true /// If this parameter is true and the file name extention is not .csv, then a SaveAs dialog will be displayed to choose a .csv file |
newFile | bool | To show a SaveAs dialog box to select a new file name /// This will be set to true when called from the Ribbon item SaveAs |
return | void |