使用Yeoman创建的Outlook Office Add-in能否在桌面版Outlook部署并获取日历数据？

Absolutely, you can use the Yeoman generator to build and deploy your Outlook add-in for the desktop client—this is actually a go-to approach for cross-platform Office add-ins (since it works seamlessly across desktop, web, and mobile Outlook). Let’s walk through your questions with practical, hands-on details:

1. Can I build and deploy this add-in with Yeoman? #

Yes, 100% feasible. Here’s how to approach it:

• Build: The Yeoman generator for Office Add-ins (generator-office) spits out a web-based project stack (HTML/JS/CSS + manifest XML) that’s fully compatible with desktop Outlook. Desktop Outlook runs add-ins in a sandboxed Chromium-based browser control, so your web code works just like it does in the web client. I’ve used this setup for multiple desktop-focused Outlook plugins, and it’s reliable.
• Testing (Sideloading): For local testing on desktop Outlook:
  1. Enable sideloading: Go to File > Options > Trust Center > Trust Center Settings > Add-ins, check "Allow unsigned Office add-ins", and select "My computer" as a trusted location.
  2. Run your Yeoman project with npm start—this will auto-register the add-in with your desktop Outlook (if you picked the "Outlook Calendar" template during setup). Alternatively, manually import the manifest XML via Get Add-ins > My Add-ins > Manage My Add-ins > Upload My Add-in.
• Deployment: Beyond the Microsoft 365 App Store, you have flexible options:
  • Admin Center Deployment: For enterprise teams, your Office 365 admin can push the add-in to all desktop Outlook users via the Microsoft 365 Admin Center.
  • Click-to-Run: Host your add-in files on a secure server, share the manifest XML link, and users can install it directly in desktop Outlook without going through the store.

2. How to access desktop Outlook calendar data? #

The best part: you don’t need a separate API for desktop Outlook. Both desktop and web clients use the same Office JavaScript API (Office.js) to interact with Outlook data. For your use case (accessing team calendars and free/busy data), here’s what you need to do:

Step 1: Configure Permissions in Manifest #

First, update your manifest.xml to request the necessary access. For calendar operations, use:

<Permissions>ReadWriteMailbox</Permissions>
<!-- Or use ReadCalendar if you only need read-only access -->

If you plan to use Microsoft Graph to access team members’ calendars (recommended for broader cross-user access), add Graph permissions to the manifest:

<WebApplicationInfo>
  <Id>[Your Azure AD App ID]</Id>
  <Resource>https://graph.microsoft.com</Resource>
  <Scopes>
    <Scope>Calendars.Read</Scope>
    <Scope>User.ReadBasic.All</Scope>
  </Scopes>
</WebApplicationInfo>

Step 2: Access Calendar Data via Office.js or Microsoft Graph #

Option A: Office.js (for current user’s calendar)

Use Office.js to fetch the current user’s calendar events directly in desktop Outlook:

// Get the current user's calendar events for the next 7 days
const startDate = new Date();
const endDate = new Date(startDate.setDate(startDate.getDate() + 7));

Office.context.mailbox.calendar.getAsync(
  { startDate, endDate },
  (result) => {
    if (result.status === Office.AsyncResultStatus.Succeeded) {
      const events = result.value;
      // Process events (filter by availability, etc.)
      console.log('Fetched calendar events:', events);
    } else {
      console.error('Error fetching calendar:', result.error);
    }
  }
);

Option B: Microsoft Graph (for team members’ free/busy data)

For accessing other team members’ calendars and calculating availability, Microsoft Graph is far more powerful. Use the getSchedule endpoint to fetch free/busy status for multiple users at once:

// Example: Fetch free/busy data for a list of team members
async function getTeamAvailability(userEmails, startDate, endDate) {
  const accessToken = await Office.context.auth.getAccessToken({
    allowSignInPrompt: true,
    forMSGraphAccess: true
  });

  const response = await fetch(
    `https://graph.microsoft.com/v1.0/me/calendar/getSchedule`,
    {
      method: 'POST',
      headers: {
        'Authorization': `Bearer ${accessToken}`,
        'Content-Type': 'application/json'
      },
      body: JSON.stringify({
        schedules: userEmails,
        startTime: { dateTime: startDate.toISOString(), timeZone: 'UTC' },
        endTime: { dateTime: endDate.toISOString(), timeZone: 'UTC' },
        availabilityViewInterval: 60
      })
    }
  );

  const data = await response.json();
  return data.value;
}

This will return each user’s availability (free/busy/tentative) for the specified time window, which you can pair with location data to find the closest available employee.

Key Note for Desktop Outlook #

Virtually all Office.js and Graph functionality works in desktop Outlook, but you can verify compatibility for specific APIs using the official compatibility matrix (though calendar-related APIs are fully supported across all modern desktop versions).

Extra Tips for Your Project #

• To calculate distance between the specified work location and employees, integrate a geocoding service (call it from your add-in’s frontend, but handle CORS properly, or proxy the request through a backend if needed).
• Sort employees by distance and availability to prioritize the closest free team member, then display their available time slots directly in your add-in’s UI.

内容的提问来源于stack exchange，提问作者Joann Holland