Cov txheej txheem:

Excel puas tuaj yeem hu rau Web Services?
Excel puas tuaj yeem hu rau Web Services?

Video: Excel puas tuaj yeem hu rau Web Services?

Video: Excel puas tuaj yeem hu rau Web Services?
Video: Mathematics with Python! Sequences 2024, Hlis ntuj nqeg
Anonim

Nyob zoo, Raws li koj cov lus piav qhia, koj xav tau hu a Web Service los ntawm Excel . Qhov tseeb, hu a Web Service los ntawm Excel yog muaj feem xyuam rau cov yam ntxwv ntawm VBA hom lus es tsis txhob Excel Yam khoom Model. Ces koj ua tau resort rau Excel Object Model sau cov txiaj ntsig rau hauv daim ntawv ua haujlwm raws li koj xav tau.

Ib yam li ntawd, tib neeg nug, Excel tuaj yeem hu rau REST API?

Tam sim no koj muaj ib REST API hu uas tsim cov ntaub ntawv hauv ib lub web browser, Excel los yog lwm yam kev siv uas ua tau ua web queries.

Ib yam li ntawd, koj hu li API hauv Excel li cas? Hu tus API los ntawm Excel Mus rau cov ntaub ntawv tab nyob rau hauv kab thiab xaiv Los ntawm Web nyob rau hauv lub Get & Hloov cov ntaub ntawv seem. Qhov no kuj tuaj yeem pom nyob rau hauv Tau Cov Ntaub Ntawv hauv Cov Ntawv Qhia Los Ntawm Lwm Qhov Chaw. Peb tsuas yog yuav tsum siv cov lus nug yooj yim kom koj tuaj yeem pop koj qhov URL rau hauv daim teb thiab nias lub pob OK.

Ua raws li qhov xav tau, Kuv yuav siv cov kev pabcuam Web hauv Excel li cas?

Nov yog yuav ua li cas teeb nws:

  1. Hauv cell B1, muab tshuaj txhuam koj tus lej API. Hauv Lub Npe Lub Npe, ntaus APIkey rau lub npe ntawm tes.
  2. Hauv cell B2, sau tus zip code. Hauv Lub Npe Lub Npe, ntaus ZipCode rau lub npe ntawm tes.
  3. Luam thiab muab tag nrho cov mis rau hauv cell B5.
  4. Hloov kho koj tus lej zip thiab tom qab ntawd koj yuav pom qhov hloov tshiab rau koj qhov WEBSERVICE Function URL.

Filterxml yog dab tsi?

Cov FILTERXML muaj nuj nqi yog lub Web qauv uas tuaj yeem xa cov ntaub ntawv tshwj xeeb los ntawm XML cov ntsiab lus, siv XPath muab. Qhov peev xwm no ua rau txoj haujlwm tsim nyog rau kev siv ua ke nrog WEBSERVICE muaj nuj nqi. Cov FILTERXML muaj nuj nqi yog muaj rau 2013 thiab tom qab versions ntawm Excel ntawm lub qhov rais platform.

Pom zoo: