为开发人员安装的

在此文中

The steps below walk you through all the setup of the environment required to run the Banana Office Add-ins for Microsoft Office 2016.

Minimum requirements: Microsoft Office 2016 (Word, Excel, PowerPoint, Outlook).

Get Banana Accounting 9

  1. Download Banana Accounting 9 for Windows or Mac.
  2. Install it on your pc.

Activate Banana Accounting web server

  1. Start Banana Accounting 9 Experimental.
  2. On Menu bar click Tools -> Program options… -> select the Interface tab
  3. Check the Start Web Server and Start Web Server with ssl options
  4. Click Ok

Install the Manifest file

Each Office Add-in has its own manifest file. The manifest is an XML file that defines various settings, including description and links to all the add-in files.

Manifest file must be copied to a specific directory.

Manifest directory for Windows

On Windows you need to create a directory to save the manifest of the add-in.

The directory needs to be a shared directory.

  1. Create a folder for the add-ins manifests on a network share:
    1. Create a folder on your local drive (for example, C:\Manifests).
    2. Right click on the folder, select properties.
    3. Click on Sharing tab.
    4. Click on Advanced Sharing...
    5. Check the Share this folder box.
    6. Click Apply and then Ok.
  2. Tell Excel or Word to use the directory as trusted app catalog.
    1. Launch Excel and open a blank spreadsheet.
    2. Choose the File tab, and then choose Options.
    3. Choose Trust Center, and then choose the Trust Center Settings button.
    4. Choose Trusted Add-in Catalogs.
    5. In the Catalog URL box, enter the path to the network share you created, and then choose Add Catalog.
      To see the path: right click on the shared folder -> Properties -> Sharing -> Network Path.
    6. Select the Show in Menu check box, and then choose OK. A message appears to inform you that your settings will be applied the next time you start Office.
    7. Close Excel and restart it.

Manifest directory for macOS

On Mac you need to create a folder to save the manifest of the add-in.

Go to one of the following folders where you'll save your add-in's manifest file. If the wef folder doesn't exist on your computer, create it.

  • For Excel: /Users/<username>/Library/Containers/com.microsoft.Excel/Data/Documents/wef
  • For Word: /Users/<username>/Library/Containers/com.microsoft.Word/Data/Documents/wef
  • For PowerPoint: /Users/<username>/Library/Containers/com.microsoft.Powerpoint/Data/Documents/wef

where <username> is your name on the device.

Get the Office Add-in manifest

You can now download the manifest of the add-in you want to use.

Load the Add-ins in Excel

Once all the setup and installations are done, it is possible to run and use the add-in.

  1. Open Microsoft Excel 2016
  2. Click on Insert tab
  3. Click on the Add-ins button
  4. Click on the Shared folder
  5. Select the Banana Accounting Add-in
  6. Click Add

 

Other Resources

For more and detailed information about the developing of the Office Add-ins, please visit https://github.com/BananaAccounting/General/tree/master/OfficeAddIns.

Introduction to Excel 2016 Add-ins

Office 2016 Add-ins are extentions of Word, Excel, PowerPoint, and Outlook.
Add-ins are composed of:

  • Manifest file
    An XML file that defines various settings, including description and links to all the add-in files.
    It is used by Word, Excel, PowerPoint, and Outlook to locate the Add-in resources.
    The manifest file can reside on a local directory or is published on the Office Store.
  • Webpage files
    Files that compose the web app (HTML pages, JavaScript code and images).
    All the files need to reside on a web server.

Add-in Examples

These examples have been made available for programmers that want to create specialized add-ins to retrieve information from Banana Accounting.
You need to insall the add-ins on a web server.

 

 

This documentation is outdated

The most complete and up-to-date documentation is the one of Banana Accounting Plus: Try it now

分享这篇文章: Twitter | Facebook | LinkedIn | Email