共享点应用程序，与Access和Excel仪表板融合在一起? [英] Share point app, blend with Access and Excel dashboard ?

问题描述

你好- 

我可以在共享点上创建带有链接的应用程序/UI，该链接发送给用户，然后单击该用户，然后弹出该应用程序.

Can I create an app / UI on share point with a link that sends to the user, they click on it, pops up the app. 

他们单击一个按钮，然后从他们选择的目录中加载一个excel文件，然后该应用程序将检查excel文件的格式正确，一旦将其加载到目标目录中.然后将Excel文件中的内容加载到Access中 然后执行SQL语句，然后填充回Excel文件(保存在目标目录中)，然后将其复制到Power Point，并将Power Point保存为共享点上的链接，或者复制excel仪表板(运行VBA后从目标目录复制) 和SQL)添加到共享点上.

They click on a button and it load an excel file from a directory of their choosing, the app would then check the excel file for the correct format, once it is then it loads it into a destined directory. It then loads what is on that excel file onto Access then do SQL statements then populate back into the Excel file (saved in the destined directory) then copies it to power point and save the power point as a link on the share point or copies the excel dashboard (from the destined directory after running VBA and SQL) onto share point. 

希望我有道理.可以做到吗?谢谢！

Hope I make sense. Can this be done ?  Thanks !

推荐答案

Johnseito，

Hi Johnseito,

此问题是否发生在SharePoint 2010或SharePoint 2013中?

Did the issue occur in SharePoint 2010 or SharePoint 2013?

如果该问题在SharePoint 2010中发生，我们将无法在SharePoint 2010中创建该应用.

If the issue occurs in SharePoint 2010, we cannot create the app in SharePoint 2010.

如果该问题发生在SharePoint 2013中，我们可以创建SharePoint托管的应用程序或提供商托管的应用程序.

If the issue occurs in SharePoint 2013, we can create the SharePoint-hosted Apps or Provider-hosted Apps.

更多参考文献:

分步方法在SharePoint 2013中创建提供者托管的应用程序.

Step by Step approach to create a Provider Hosted Application in SharePoint 2013.

http://www.sharepointpals.com/post/逐步方法来创建提供程序托管的应用程序在SharePoint-2013中

使用Visual Studio创建SharePoint托管应用.

Create a SharePoint Hosted App with Visual Studio.

https://visualstudiomagazine.com/articles/2015/04 /30/sharepoint-hosted-app-visual-studio.aspx

最诚挚的问候，

萨拉范

这篇关于共享点应用程序，与Access和Excel仪表板融合在一起?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！