Embed Excel Online File to Acumatica User Interface

Hi All

Have you ever use Google docs or Office 365? It is new way of working, when all your documents are somewhere in the cloud. Many employees can view and edit documents simultaneously.

Today I want to share with you one trick how you can include Excel file  (and other office documents as well) right to Acumatica user interface.

Acumatica Excel Embeded

If you interesting in this, welcome in this article.

Configurations Steps:

  1. First of all you need to create excel file. I will use InvoicedItems,xlsx file that is attached to InvoicedItems generic inquiry page in Sales Demo data.
  2. Login to your Office 365 aтв open One Drive
  3. Upload your excel file to one drive.
    Share Excel File
  4. Using “Share” button, share this file and copy an online link. You can choose any link (with any suggested access rights) you want.
    Share Excel File
  5. Copy the link. It will be something like this: https://acumatica-my.sharepoint.com/personal/smarenich_acumatica_com/_layouts/15/guestaccess.aspx?guestaccesstoken=<token>&docid=<id>
  6. Add 2 additional parameters to this link – action=embedview and wdbipreview=true. So the result URL will be like this: https://acumatica-my.sharepoint.com/personal/smarenich_acumatica_com/_layouts/15/guestaccess.aspx?guestaccesstoken=<token>&docid=<id>&action=embedview&wdbipreview=true
  7. Copy the result link and past it into the browser url. Browser will show you a preview of excel file.
    Excel File Online
  8. If you check, than browser has automatically change the url. And actually that is the url that we need. Copy new url form address bar – you will have something like this: https://acumatica-my.sharepoint.com/personal/smarenich_acumatica_com/_layouts/15/WopiFrame.aspx?sourcedoc=<DOCID>&action=embedview
  9. Now we need to include it into the Acumatica sitemap. Create a new node in any place you line and past the URL into appropriate column.
    Acumatica Register new Screen though Sitemap
  10. Use new node on the left tree to open excel file inside Acumatica.

And now you can see a good result.
This way can be quite good opportunity on demo – show it and prove that future is for the cloud solutions. Having everything in one environment is very good selling point.

Have a nice demo!

3 Replies to “Embed Excel Online File to Acumatica User Interface”

  1. This is amazing and I was able to get it to work with a google drive document. But, when I try it with our companies SharePoint system I run into permissions issues. Do you know of a way to get around that, i.e. login to preview the document? Maybe using Acumatica’s SSO service with the Microsoft account?

Leave a Reply

Your email address will not be published. Required fields are marked *