主页 / user-6469472

Humberto's questions

Martin Hope
Humberto
Asked: 2025-04-09 00:25:46 +0800 CST
  • 5

我正在尝试按照官方文档开发内容插件。实现部分指出只需要进行少量更改：

  • 对于 OfficeApp 元素，将 xsi:type 属性设置为“ContentApp”。
  • 在DefaultSettings元素中，添加RequestedHeight和RequestedWidth元素。

在同一部分中，列出了两个适用于 PowerPoint 和 Excel 的基于内容的入门插件，但遗憾的是它们针对的是 Visual Studio，而我没有 Windows 电脑。此外，还提到了一个已有 9 年历史的示例Excel-Content-Add-in-Humongous-Insurance，其清单看起来相当过时。

我决定尝试使用 Yeoman 和 VScode。由于yo officeOffice 不提供基于内容的插件入门，我选择使用：

? Choose a project type: Office Add-in Task Pane project using React framework
? Choose a script type: TypeScript
? What do you want to name your add-in? my-content-addin
? Which Office client application would you like to support? Powerpoint

按照上面列出的文档，我将元素xsi:type的更改OfficeApp为，并将和元素ContentApp添加到元素。RequestedHeightRequestedWidthDefaultSettings

此外，我注意到Excel-Content-Add-in-Humongous-Insurance清单在 OfficeApp 中没有以下模式：

xmlns:ov="http://schemas.microsoft.com/office/taskpaneappversionoverrides"

我检查了 office-addin-manifest 存储库，但找不到内容插件的替代方案，例如，.../contentappversionoverrides我只找到了一个额外的.../mailappversionoverrides。

我还注意到Excel-Content-Add-in-Humongous-Insurance清单中没有该VersionOverrides元素，因此我从生成的清单中删除了该元素manifest.xml。因此，我最终得到了：

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<OfficeApp 
  xmlns="http://schemas.microsoft.com/office/appforoffice/1.1" 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  xmlns:bt="http://schemas.microsoft.com/office/officeappbasictypes/1.0" 
  xsi:type="ContentApp">
  <Id>9e2e38ec-67af-43e6-8aeb-c8c3e22b86bd</Id>
  <Version>1.0.0.0</Version>
  <ProviderName>Contoso</ProviderName>
  <DefaultLocale>en-US</DefaultLocale>
  <DisplayName DefaultValue="my-content-addin"/>
  <Description DefaultValue="A template to get started."/>
  <IconUrl DefaultValue="https://localhost:3000/assets/icon-32.png"/>
  <HighResolutionIconUrl DefaultValue="https://localhost:3000/assets/icon-64.png"/>
  <SupportUrl DefaultValue="https://www.contoso.com/help"/>
  <AppDomains>
    <AppDomain>https://www.contoso.com</AppDomain>
  </AppDomains>
  <Hosts>
    <Host Name="Presentation"/>
  </Hosts>
  <DefaultSettings>
    <SourceLocation DefaultValue="https://localhost:3000/taskpane.html"/>
    <RequestedHeight>400</RequestedHeight>
    <RequestedWidth>400</RequestedWidth>
  </DefaultSettings>
  <Permissions>ReadWriteDocument</Permissions>
</OfficeApp>

之后我尝试验证清单并收到以下错误：

Error #1: 
XML Schema Validation Error: Error found during XML Schema validation.
  - Details: The element 'DefaultSettings' in namespace 'http://schemas.microsoft.com/office/appforoffice/1.1' has invalid child element 'RequestedWidth' in namespace 'http://schemas.microsoft.com/office/appforoffice/1.1'.
  - Line: 25
  - Column: 6

Error #2: 
XML Schema Violation: Your manifest does not adhere to the current set of XML schema definitions for Office Add-in manifests.

我删除了它，尽管它似乎被模块RequestedWidth识别，然后重试。这次清单是有效的。因此，我运行了，我的插件自动添加到了当前幻灯片中。manifestHandlerXml.tsoffice-addin-manifestnpm start

这是我的最终 manifest.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<OfficeApp 
  xmlns="http://schemas.microsoft.com/office/appforoffice/1.1" 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  xmlns:bt="http://schemas.microsoft.com/office/officeappbasictypes/1.0" 
  xsi:type="ContentApp">
  <Id>9e2e38ec-67af-43e6-8aeb-c8c3e22b86bd</Id>
  <Version>1.0.0.0</Version>
  <ProviderName>Contoso</ProviderName>
  <DefaultLocale>en-US</DefaultLocale>
  <DisplayName DefaultValue="my-content-addin"/>
  <Description DefaultValue="A template to get started."/>
  <IconUrl DefaultValue="https://localhost:3000/assets/icon-32.png"/>
  <HighResolutionIconUrl DefaultValue="https://localhost:3000/assets/icon-64.png"/>
  <SupportUrl DefaultValue="https://www.contoso.com/help"/>
  <AppDomains>
    <AppDomain>https://www.contoso.com</AppDomain>
  </AppDomains>
  <Hosts>
    <Host Name="Presentation"/>
  </Hosts>
  <DefaultSettings>
    <SourceLocation DefaultValue="https://localhost:3000/taskpane.html"/>
    <RequestedHeight>400</RequestedHeight>
  </DefaultSettings>
  <Permissions>ReadWriteDocument</Permissions>

</OfficeApp>

如何为我的内容插件指定默认宽度？

如何仅当我单击功能区命令（如默认 TaskPane 演示打开任务窗格）时插入我的插件？

在 Yeoman Taskpane Demo 中，VersionOverrides需要一个 schema xmlns="http://schemas.microsoft.com/office/taskpaneappversionoverrides"。 action 元素的替代方案是什么Control？<Action xsi:type="ShowTaskpane">是在基于内容的插件中吗？

在此处输入图片描述

office-js
Martin Hope
Humberto
Asked: 2024-08-29 21:43:50 +0800 CST
  • 6

我正在尝试为通用方法的参数添加一些自动完成支持

 subscribeToTelemetry<T extends keyof TypeMap>(name: T): Stream<TypeMap[T]>;
 subscribeToTelemetry<T extends NonNullable<{}>>(name: EntityName<T>): Stream<T>;

简而言之，如果没有提供类型，subscribeToTelemetry则应根据名称和一些可用的注入/自动生成类型推断返回类型。此外，应使用可用的注入/自动生成类型提出可能的名称建议。例如，使用以下类型：

type TypeMap = {
    ranger1: RangerTelemetry,
    ranger2: RangerTelemetry,
    mavic2: DroneTelemetry
};

以及以下代码

// should suggest: ['mavic2' | 'ranger2' | 'ranger1'] since no type T is provided 
const myStream1 = r.subscribeToTelemetry('ranger1'); // myStream1: Stream<RangerTelemetry

建议值应为 ['mavic2' | 'ranger2' | 'ranger1']，因为未提供类型 T，并且 myStream1 类型将是Stream<RangerTelemetry>

相反，如果我们提供一个类型subscribeToTelemetry ，并考虑可用的注入/自动生成类型

const entityNames = {
    RangerTelemetry: ['ranger1', 'ranger2', 'ranger3'],
    DroneTelemetry: ['mavic1', 'mavic2', 'mavic3'],
} as const;

和其他一些类型的技巧（参见操场链接），使用以下代码

// should suggest only: ['mavic1' | 'mavic2' | 'mavic3'] since type T is provided as DroneTelemetry,
const myStream3 = r.subscribeToTelemetry<DroneTelemetry>('mavic1');

我们应该建议：['mavic1' | 'mavic2' | 'mavic3']，因为提供了类型DroneTelemetry，但显示的却是 ['mavic1' | 'mavic2' | 'mavic3', 'ranger1', 'ranger2', 'ranger3']。的类型myStream3将是Stream<DroneTelemetry>

我有多个重载方法的签名实现变体，但 subscribeToTelemetry在提供类型时无法提供正确的建议，即使我指定 DroneTelemetry为类型，我总是会得到游骑兵的建议。

class Registry {
    subscribeToTelemetry<T extends keyof TypeMap>(name: T): Stream<TypeMap[T]>;
    subscribeToTelemetry<T extends NonNullable<{}>>(name: EntityName<T>): Stream<T>;
    subscribeToTelemetry<T extends NonNullable<{}>>(name: EntityName<T>): Stream<T> {
        return new Stream<T>(name); 
    }
}

如果有人有任何建议，我将不胜感激

温贝托

完整代码如下：

type DroneTelemetry = { kind: 'DroneTelemetry', batteryLevel: number, velocity: number, location: {latitude: number, longitude: number}}
type RangerTelemetry = { kind: 'RangerTelemetry', velocity: number, location: {latitude: number, longitude: number}}


////// the entity names and type mapping will be autogenerated
const entityNames = {
    RangerTelemetry: ['ranger1', 'ranger2', 'ranger3'],
    DroneTelemetry: ['mavic1', 'mavic2', 'mavic3'],
} as const;

type TypeMap = {
    ranger1: RangerTelemetry,
    ranger2: RangerTelemetry,
    mavic2: DroneTelemetry
};
////////

// Define the types for the keys and values of the mapping
type EntityNames = typeof entityNames;
type EntityKeys = keyof EntityNames;
type EntityValues<T extends EntityKeys> = EntityNames[T][number];

// Define a mapping from type aliases to their corresponding keys
type TypeToKey<T> = T extends { kind: infer K } ? K : never;

type ExtractEntitiesNames<T> = TypeToKey<T> extends keyof EntityNames ? EntityValues<TypeToKey<T>> : never;
type EntityName<T> = ExtractEntitiesNames<T> |  (string  & {});

/////////////////////////////////////////////////////////////////////

class Stream<T> {
    name: string
    constructor(name: string){
        this.name = name
    }
    getLastValue() {
        return {} as T // dummy impl
    }
}

class Registry {
    subscribeToTelemetry<T extends keyof TypeMap>(name: T): Stream<TypeMap[T]>;
    subscribeToTelemetry<T extends NonNullable<{}>>(name: EntityName<T>): Stream<T>;
    subscribeToTelemetry<T extends NonNullable<{}>>(name: EntityName<T>): Stream<T> {
        return new Stream<T>(name); 
    }
}

const r = new Registry();
// should suggest: ['mavic2' | 'ranger2' | 'ranger1'] since no type T is provided // OK
const myStream1 = r.subscribeToTelemetry('ranger1'); // myStream1 type will be Stream<RangerTelemetry>

// should suggest: ['mavic2' | 'ranger2' | 'ranger1'] since no type T is provided // OK
const myStream2 = r.subscribeToTelemetry('ranger2'); // myStream2 type will be Stream<RangerTelemetry>

 // should suggest only: ['mavic1' | 'mavic2' | 'mavic3'] since type T is provided as DroneTelemetry,
 // but ['mavic1' | 'mavic2' | 'mavic3', 'ranger1', 'ranger2', 'ranger3'] is shown instead.                // WRONG
const myStream3 = r.subscribeToTelemetry<DroneTelemetry>('mavic1'); // myStream3 type will be Stream<RangerTelemetry>

这是一个包含完整代码的ts-playground

typescript