Visual Studio


Create a new Excel Web Add-in project.
(File > New Project) Office/SharePoint Add-ins.
These templates are the same in Visual Studio 2017 and 2019.
This template is also compatible with Office 2016 and Office 365.
Open the Manifest project and display the Manifest.xml file.
Change the SourceLocation to point to localhost.

<DefaultSettings> 
  <SourceLocation DefaultValue="http://localhost:8080/index.html" />
</DefaultSettings>

Change the Url location for the taskpane.

<Resources> 
   <bt:Url id="Contoso.Taskpane.Url" DefaultValue="http://localhost:8080/index.html" />
</Resources>

Press F5 to start debugging.
You can make dynamic changes to the html page and the javascript file.
These changes can be seen in Excel by reloading the task pane.




© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext