public static void Run() { // ExStart:1 //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Load sample Excel file Workbook workbook = new Workbook(sourceDir + "WebExtensionsSample.xlsx"); WebExtensionTaskPaneCollection taskPanes = workbook.Worksheets.WebExtensionTaskPanes; foreach (WebExtensionTaskPane taskPane in taskPanes) { Console.WriteLine("Width: " + taskPane.Width); Console.WriteLine("IsVisible: " + taskPane.IsVisible); Console.WriteLine("IsLocked: " + taskPane.IsLocked); Console.WriteLine("DockState: " + taskPane.DockState); Console.WriteLine("StoreName: " + taskPane.WebExtension.Reference.StoreName); Console.WriteLine("StoreType: " + taskPane.WebExtension.Reference.StoreType); Console.WriteLine("WebExtension.Id: " + taskPane.WebExtension.Id); } // ExEnd:1 Console.WriteLine("AccessWebExtensionInformation executed successfully."); }
public static void Run() { // ExStart:1 //Source directory string outDir = RunExamples.Get_OutputDirectory(); Workbook workbook = new Workbook(); WebExtensionCollection extensions = workbook.Worksheets.WebExtensions; WebExtensionTaskPaneCollection taskPanes = workbook.Worksheets.WebExtensionTaskPanes; int extensionIndex = extensions.Add(); int taskPaneIndex = taskPanes.Add(); WebExtension extension = extensions[extensionIndex]; extension.Reference.Id = "wa104379955"; extension.Reference.StoreName = "en-US"; extension.Reference.StoreType = WebExtensionStoreType.OMEX; WebExtensionTaskPane taskPane = taskPanes[taskPaneIndex]; taskPane.IsVisible = true; taskPane.DockState = "right"; taskPane.WebExtension = extension; workbook.Save(outDir + "AddWebExtension_Out.xlsx"); // ExEnd:1 Console.WriteLine("AddWebExtension executed successfully."); }