通过后端服务器实现JS Office Add-in与VSTO Add-in通信

function sendDataToBackend(data) {
  fetch('https://your-backend-server/api/processData', {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json'
    },
    body: JSON.stringify(data)
  })
  .then(response => response.json())
  .then(result => {
    console.log('Backend response:', result);
    // 处理后端服务器的响应
  })
  .catch(error => {
    console.error('Error:', error);
  });
}

// 假设后端服务器通过消息队列或其他机制将数据传递给VSTO Add-in
// 这部分代码需要根据实际的后端服务器实现进行调整

public void ProcessData(string data)
{
    // 解析数据
    dynamic parsedData = Newtonsoft.Json.JsonConvert.DeserializeObject(data);

    // 执行操作，例如访问Shape对象
    Excel.Shape shape = Globals.ThisAddIn.Application.ActiveSheet.Shapes.AddShape(MsoAutoShapeType.msoShapeRectangle, 100, 100, 200, 100);
    shape.Name = parsedData.shapeName;

    // ... 其他操作

    // 可选：将结果发送回后端服务器
}

Office.context.mailbox.item.loadCustomPropertiesAsync(function(asyncResult) {
  if (asyncResult.status == Office.AsyncResultStatus.Succeeded) {
    var customProps = asyncResult.value;
    customProps.set("MyCustomProperty", "SomeValue");
    customProps.saveAsync(function(asyncResult) {
      if (asyncResult.status == Office.AsyncResultStatus.Succeeded) {
        console.log("Custom property saved successfully.");
      } else {
        console.error("Error saving custom property:", asyncResult.error);
      }
    });
  } else {
    console.error("Error loading custom properties:", asyncResult.error);
  }
});

Outlook.MailItem mailItem = (Outlook.MailItem)Globals.ThisAddIn.Application.ActiveInspector().CurrentItem;
string customPropertyValue = mailItem.PropertyAccessor.GetProperty("http://schemas.microsoft.com/mapi/string/{GUID}/MyCustomProperty");

// {GUID} 需要替换为唯一的GUID

if (!string.IsNullOrEmpty(customPropertyValue))
{
    // 使用 customPropertyValue
    Console.WriteLine("Custom Property Value: " + customPropertyValue);
}