在VSTO中的Excel状态栏中显示"更新工作流状态"进度条,可以通过以下步骤实现:
using Microsoft.Office.Core;
using System.Windows.Forms;
namespace YourNamespace
{
public partial class ThisAddIn
{
private ProgressBar progressBar;
protected override Office.IRibbonExtensibility CreateRibbonExtensibilityObject()
{
progressBar = new ProgressBar();
Globals.ThisAddIn.Application.StatusBar = (progressBar as IStatusBar).StatusBar as string;
return new Ribbon1();
}
private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
}
private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
{
}
}
public interface IStatusBar
{
object StatusBar { get; set; }
}
public class ProgressBar : IStatusBar
{
public object StatusBar
{
get
{
return CreateProgressBar();
}
set
{
// Do nothing
}
}
private object CreateProgressBar()
{
var progressBar = new ProgressBarControl();
progressBar.Location = ProgressBarLocation.None;
progressBar.Caption = "Updating Workflow Status...";
progressBar.Visible = true;
return progressBar;
}
}
}
此方法通过自定义实现一个继承自IStatusBar的ProgressBar类,并在CreateRibbonExtensibilityObject方法中将其设置为Excel的状态栏,从而在状态栏中显示进度条。通过控制progressBar控件的属性,可以实现更多自定义的效果。
请注意,这里并未提及任何特定的云计算品牌商的产品。
领取专属 10元无门槛券
手把手带您无忧上云