Web扩展 Office插件
Web扩展扩展了Office应用程序,并与Office文档中的内容交互。Web扩展为Office客户端添加了额外功能,以提高用户体验和提高工作效率。
Aspose.Cells还提供了与Web扩展配合使用的功能。
添加Web扩展
你可以通过点击插入选项卡,然后点击商店/获取附加组件链接来在Excel中添加Web扩展(Office Add-ins)。在附加组件框中,浏览你想要的附加组件并添加它。
Aspose.Cells还提供了通过使用WebExtension和WebExtensionTaskPane类添加Web扩展的功能。以下代码示例演示了如何使用WebExtension和WebExtensionTaskPane类向Excel文件添加网页扩展。 请参考由代码生成的输出Excel文件。
示例代码
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
//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"); |
访问Web扩展信息
Aspose.Cells提供了访问Excel文件中Web扩展信息的功能。以下代码示例演示了如何通过加载示例Excel文件来访问Web扩展信息。 请参考由代码生成的控制台输出。
示例代码
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
//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); | |
} |
控制台输出
Width: 350
IsVisible: True
IsLocked: False
DockState: right
StoreName: en-US
StoreType: OMEX
WebExtension.Id: 95D7ECE8-1355-492B-B6BF-27D25D0B0EEF