WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel

The following article introduces you to the WEBSERVICE function - one of the functions in the Web function group is very popular in Excel.

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 1

Description: The function returns data from a web service on the Internet or Intranet. Support functions from Excel 2013 onwards.

Syntax: WEBSERVICE (url)

Inside:

- url: The URL of the web service, is a required parameter.

Attention:

- If arguments cannot return data -> the function returns the #VALUE! Error value

- If arguments are invalid or contain more than 32676 characters -> the function returns the #VALUE! Error value

- If url is a string containing more than 2048 characters allowed by the Get request -> the function returns the #VALUE! Error value

- With unsupported protocols such as ftp: //, file: // -> the function returns the #VALUE! Error value

For example:

Determining the return value from the web service in the URL string is described in the table below:

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 2

- In the cell to calculate enter the formula: = WEBSERVICE (C6)

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 3

- Press Enter -> return value is:

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 5

- Where url is in ftp: // format or file: // -> the function returns the #VALUE! Error value

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 6

Above are instructions and some specific examples when using WEBSERVICE function in Excel.

Good luck!

4.3 ★ | 4 Vote

May be interested

  • How to create notes for documents in ExcelPhoto of How to create notes for documents in Excel
    instructions on how to create notes for documents in excel. you can customize the comment to a formula or to a data cell in a spreadsheet by doing the following steps: step 1: select the cell to insert a comment - go to review - new comment tab.
  • Use the search and replace function in ExcelPhoto of Use the search and replace function in Excel
    instructions on how to use the search and replace function in excel. you can customize the addition of a comment to a formula or to a data cell in a worksheet by performing the following steps: 1. find data search feature. step 1: open the find and rep dialog box
  • Set the AutoCorrect function in ExcelPhoto of Set the AutoCorrect function in Excel
    instructions on how to set up the autocorrect function in excel. to set up the autocorrect function in excel, do the following: step 1: go to the file - option tab: step 2: the excel option dialog box appears - choose proofing - autocorrrect options
  • How to protect spreadsheets in ExcelPhoto of How to protect spreadsheets in Excel
    instructions on how to protect spreadsheets in excel. protecting spreadsheets is an essential need of many users, thanks to this feature who makes spreadsheets can secure their data. to protect a spreadsheet, follow these steps: step 1: right-click v
  • How to insert and delete worksheets in ExcelPhoto of How to insert and delete worksheets in Excel
    instructions on how to insert and delete worksheets in excel. 1. insert a sheet (sheet) in excel. step 1: right-click on any sheet (or you can choose a new sheet location) - insert: step 2: the insert dialog box appears - click worksh
  • How to choose images as a background for a spreadsheet in ExcelPhoto of How to choose images as a background for a spreadsheet in Excel
    detailed instructions to you how to choose images to make up the worksheet in excel. to create wallpaper you follow these steps: 1. create a wallpaper for spreadsheets from images available on the computer. step 1: go to pagelayout - background: step 2: insert p dialog box