1. Excel Install Microsoft Winhttp Services Version
2. Excel Install Microsoft Winhttp Services

Released:

When you said, 'WinHttp is a different stack that best works with services', i think you were talking about Windows Services, correct? MSXML2.DOMDocument60 abstracts the difference between the two, e.g. The open method calls WinInet or WinHttp. Get Foreign Exchange Rate in Excel (VBA) Yahoo Finance is designed in the way to facilitate you to get data. This time we establish a connection to Yahoo and directly get the exchange rate using User Defined Function. Press ALT+F11 Tools References enable “Microsoft WinHTTP Services” Insert a Module and then insert the below code. Make sure Microsoft WinHTTP Services are enable. To do so, open Visual Basic Editor of your xlsm file. Click Tools References. And select Microsoft WinHTTP Services. Development Process – Step 1. Range A2 to be taken the head cell. Type “GOOG” in range A3, “FB” in A4 and “MSFT” in range A5.

A python Jupyter extensions to make notebooks web api for Excel to call using UDF forumla or Ribbon Callback. Jupyter Excel, Python Excel

Project description

jupyterexcel Package

This is a python package to make Jupyter.ipynb file a web api with json result. You can call Jupyter from Excel Formula or Ribbon CallBack FunctionsSourceCode in JupyterExcel

Before install, please download JupyterExcelTesting.xlsm to try its formula function and excel ribbon. If you think it works, you can modify the url in the sheet to your jupyter page and save it as 'Addin' file.

This Jupyter Excel web api can be connected with Excel addin which call this web api. Excel formula will generate a web api url and through winhttp to get json result. It now works Mac Excel by using VBA-Web.

Installation

then run

Server setting

Please follow config jupyter server or use command

and change following values:

Example

The following screenshot shows the sample notebook file with a function sum. You can download TestingJupyter.ipynb or create your own. The following is an instance I hosted in google cloud platform, you can open and add a function of yours.
http://www.jupyterexcel.com:8888/Excel/TestingJupyter.ipynb?token=ABCD&functionname=sum&1=11&2=8&3=6
http://www.jupyterexcel.com:8888/notebooks/TestingJupyter.ipynb?token=ABCD please change 34.67.24.96 to your computer name or localhost

The following screenshot shows how excel Formula works.

The following screenshot Shows how Ribbon Call Back function works

Future Development Plan

1. Make Excel client side more easier to use, such as generate Excel formula proxy
2. Able to support R, Julia ....
3. It might only support one notebook page

Reference

read some code from appmode

Release historyRelease notifications | RSS feed

0.0.11

0.0.10

0.0.9

0.0.8

0.0.7

0.0.6

0.0.5

0.0.3

0.0.2

0.0.1

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Hashes for jupyterexcel-0.0.11-py3-none-any.whl

Excel Install Microsoft Winhttp Services Version

Hashes for jupyterexcel-0.0.11.tar.gz

In this article, we will create an Excel function to calculate the distance between two addresses using the Google Maps directions API. This will allow you to get the travel time between the two locations. The format of the function will be as follows: =TRAVELTIME(origin, destination, api_key), =TRAVELDISTANCE(origin, destination, apikey). The origin and destination will be strings, and can be either an exact address or the name of a place. In order to use the function, an API key is required. The “Getting Started” page can help you with this: http://bit.ly/googlemapsgettingstarted. Create a new project and make sure the Directions API is added.

Step 1: Create a new macro file and add VBA-JSON

Because the Google Maps Directions API is a JSON API, we will use VBA-JSON to make it easy to use the results from the web request. You can download the latest version from here: https://github.com/VBA-tools/VBA-JSON/releases. Download and extract the zip file. Then, open your macro file. Open the Visual Basic Editor (Alt + F11).

In order to import the VBA-JSON file, go to File > Import File… (Ctrl + M). Select JsonConverter.bas. A JsonConverter module will appear in the sidebar.

Next, make sure the appropriate references are enabled. Go to Tools > References… In addition to the references already selected, check off “Microsoft Scripting Runtime” (for Dictionary support needed by VBA-JSON) and “Microsoft WinHTTP Services, version 5.1” (to make the HTTP request to the API). If you require support for Excel for Mac, you will need to install VBA-Dictionary from the author of VBA-JSON. More details can be found at the bottom of the project homepage: https://github.com/VBA-tools/VBA-JSON.

Step 2: Create the functions

With the references configured, we can now write the code for the function. The code is relatively simple. It is simply takes the three parameters and formats them into a web request. The response of the web request is then parsed by VBA-JSON and the relevant variable returned. Note that the request may return multiple routes, but then function simply returns the time of the first route. The default mode is driving, but refer to the Directions API documentation for information on other modes and adjust the strURL variable accordingly.

To insert the code, create a new module with Insert > Module. Then paste the following code:

Save the file. You should now be able to use the functions from within Excel. Place your API key in cell A1, then try the following: =TRAVELTIME('24 Sussex Drive Ottawa ON', 'Parliament Hill', A1). This returns a travel time of about 435 seconds. If you would like this to be displayed in minutes and seconds, try this function: =FLOOR.MATH(A8/60)&' minutes '&MOD(A8, 60)&' seconds' where A8 is the cell with the travel time in seconds. This prints a helpful “7 minutes 15 seconds” for the 24 Sussex example. We can also find the distance. Try the following: =TRAVELDISTANCE('24 Sussex Drive Ottawa ON', 'Parliament Hill', A1). It returns a distance of 2667 meters. Convert to kilometers with this: =ROUND(A9/1000, 1)&' km'.

Note: The Google Maps Directions API always returns distances in meters. Convert to KM or Miles as you wish. This can be done in Excel or by modifying the functions in VBA.

Excel Install Microsoft Winhttp Services

That’s it! You should now have a working travel time function. All you need now is a list of addresses to use it with. If you would like to pull a list from the web or local JSON file, check out Import JSON Data in Excel 2016 or 2019 or Office 365 using a Get & Transform Query.