XL97: ????? ????? ????? ????????? (.iqy) ???

?????? ????????? ?????? ?????????
???? ???????: 157482 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ?????? ????? ????? ??????? ??? ????? (.iqy) ????????? ?? Microsoft Excel 97.

??????? ????

?? Microsoft Excel 97 ????????? ??? ???? ?????????? ?? ???????? ?? ??? ????? ?? ?????? ?? ???? ??????? ???????? ????????? ?????? ?? ???? ??? Microsoft Excel. ????? Microsoft Excel 97 ??? ????????? ??? ????.

????? ??? ??????? ???

??? ??????? ??? ?? ??? ??? ????? ??? ???? ??? ????? ???? ?? ???? ??? ??? ??? ?? ??? ?? ???? ?????? ??? ?????. ???? ????? ????? ??????? ??? ?? ?? ???? ?? ??? ???????, ?? ??? ????? ??????? .iqy.

????? ??? ??????? ???

?????? ??? ??????? ??? ???? ??????? ???????:
  1. ??? ????? ???? ?? ??? ???????.
  2. ???? ????? ???? ?? ???? ?? ???? ?? ???????? ????????? ???????:
    ????? ?????: ??? ?????????
    ????? ????? ?? ??? ??????? ??? ?????? Microsoft Excel ?? ?? ??? ????? ???? ????? ??? ?????????. ?? ??? ????? ???? ??? ????? ??????? ???? ???:

    WEB < ??? ??? >

    ??? ???? ???? ??? ?? ???? ???????.
    ???? ??????: ????? ?????????
    ????? ?????? ?? ??? ??????? ??? ?????? Microsoft Excel ??????? ????????? ???? ??? ?????. ?? ??? ????? ???? ??? ????????? ???? ???:

    ??? ?? 1 < >

    ??????: ??? ???? ??? ????????? ?? ????? ????? ??? ???? ????? ????? ?? ????? ??????. ??? ???? ????? ??? ????? ??? ???????.
    ???? ??????: ???? ???? ?????? (URL)
    ???? ????? ?????? ?? ??? ??????? ??? ????? ??? ???? ????? ?????????. ??? ??? ??? ????? ??? POST ???? (???? ????? "??????? ????: POST ??????") ? ??? ????????? ?? ?????? ???????? ??? ?? ??? ??????? ???.

    ???? URL ?? ??? ????????? ???????.
              File location                     URL format
          -------------------------------------------------------------------
          Web document                    http://<server>/<file>
          File stored locally             <drive>:\<directory>\<file>
          File stored on a network        \\<server>\<share>\<directory>\<file>
    						
    ??? <server>?? ??? ?????? ???? ????? ??? ????? ??? ?? ??? ??? ???? ????? ?????? <file>?? ??? ???????, <drive>?? ???? ??????? ???? ????? ??? ????? ??????, <directory>?? ??? ?????? ???? ????? ??? ??? ???? ? <share>?? ??? ???????? ??? ??????.
    ???? ??????: ?????? POST
    ????? ????? ?????? ?? ??? ??????? ??? ?????? POST. ?????? ??? ????? ???????? ? ??? ????? ??? ??? ??? ??? ??????? (URL) ?????? ????? ????? ????? ?????? 200 ???.

    ??? ????????? ????? ??? ?????? ??? ??????? ?? ????? ?????? ????? ????? ??? ????? ???????: GET ?? POST.

    ??? ??????? ??????? GET ??? ????? ??? ???????? ?? ??? ????? ??? ???? ???? ?????????. ???? ?????? ?????? ????? ????? ???
          http://<server>/<file>parameters>
    						
    ??? <server>?? ??? ?????? ???? ????? ??? ????? ??? ? <file>?? ??? ???????.

    ??? ??????? ??????? POST ??? ????? ??? ???????? ?? ??? ?????. ???? ?????? ?????? ????? ????? ???
          http://<server>/<file>
          parameters
    						
    ??? <server>?? ??? ?????? ???? ????? ??? ????? ??? ? <file>?? ??? ???????.
  3. ??? ????? ???? ?????? ???????? ??? ????? ?????? ???? ??? ??????? .iqy (??? ???? ??????? ???? ????? ?? Myquery.iqy).
  4. ?? ?????? ???? ??????.

???????? "????" ? "???? ?????? ?? ??????? ???

???? ??????? ?????? ????? ?/?? ????????? ?? ????????? ???. ????? ?????? ????? ????????? ?? ???????? ??? ???????? ??? ?? ???. ?????? ?????? ??????? ???? ???? ????? ?? ???? ??? ????? ??????? ???.

?? ???? ???? ?????? ??? ???:
<parameter>= < ???? ????? >
??? <parameter>?? ??? ????? (??? ???? ??????? ??????) ? < ???? ????? > ??????.

???? ?? ???? ???? ????? ????? ?? ????? ???????.
   Parameter type   Value string
   -----------------------------------------------------------
   Static           value1
   Dynamic          ["value1","Please enter the first value:"]
				
?? ????? ????????? ???? ??????? ?????? (value1) ?? ??? ?????? ?????? ???????. ??????? ??????? ?? ??????? ???? ???? ??? ????? ??????? ???.

??? ???? ?????? ?????? ??????? ?????? ?????? ????? ?? (&). ???? ?????? ?????? ???? ??????:
quote1 = stock1 & quote2 = stock2
??? ????? ??? ?????? ?????? ????? ?????? ?????? ????? (+). ???? ?????? ?????? ???? ??????:
quote1 = stock1 + stock2 & quote2 = stock3 + stock4
????? ?? ?????? ???? ????? ??? ????? ????? ?????. ???? ?????? ?????? ???? ??????:
quote1 = stock1 & quote2 = ["stock2" "?????? ????? ???? ??????:"]

????? ??? ??? Query Files

?? ????? ??????? ??????? ?? ??? ???? ???? ????????? ?? ??? ????? ??????? ??? ?? Microsoft Excel 97.

??????: ??????? ??????? ??? ????????? ??? ????????.

???? ????:

??? ?????? ?????? ???? "wyut" ??? Client.exe ????? ???????? ????. ?? ??? ??????? ?????? ?? ???. ??? ????? ??????? ???????? ??????? GET.
   WEB
   1
   http://www.weylandyutani.com/cgi-bin/client.exe?quote=wyut
				
??? ??? ???? ????? ????? ?????? ?????? ???????? ?????????? ????? ??????:
     http://www.weylandyutani.com/cgi-bin/client.exe?quote=wyut
				
??? ?????? ???? ??????? ??????? ??? ????? ????? ???? ?? ?????? .iqy. ?????? ??? ????? ????? ??????? ?? ??? ???????.

??? ???? ?????? ??????:

???? ??? "wyut" ? "hypd" ??? Client2.exe ??? ?????? ?? ???? ???????? ???. ?? ??? ??????? ?????? ?? ???. ???????? ??????? ???????? ???????POST.

   WEB
   1
   http://www.weylandyutani.com/cgi-bin/client2.exe
   quote1=wyut&quote2=hypd
				
??? ???? ?????? ????:

??? ?????? ?????? ?????? ??? ???? ???? ??? ????? ??? Client.exe ????? ???????? ????. ??? ????? ???????? ???????? ??????? GET.

??????: ??? ????? ??? ???? ?????? ??????? ?? ??? ?????? ??? ??? ???? ?? ??? ???.
    WEB
   1
   http://www.weylandyutani.com/cgi-bin/client.exe?quote1=
      ["stock1","Please enter a stock symbol:"]
				

?????? ?????

???? ??? ?????? ???? "wyut" ????? ????? ??? ????? Client2.exe ??? ?? ???? ???????? ?????. ???????? ??????? ???????? ???????POST.
   WEB
   1
   http://www.weylandyutani.com/cgi-bin/client2.exe
   quote1=wyut&quote2=["stock2","Please enter a stock symbol:"]
				

?????

4-6 ????? "Microsoft Excel ??? Resource Kit ?? Microsoft Excel 97"

???????

???? ???????: 157482 - ????? ??? ??????: 12/?????/1424 - ??????: 2.0
????? ???
  • Microsoft Excel 97 Standard Edition
????? ??????: 
kbmt kbfaq kbofficeupdate kbprb kbweb KB157482 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????157482
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com