Excel Internet Explorer Excel Internet Explorer Excel Internet Explorer 1 Excel Excel 1.1 Excel Excel 2 1
1.1.1 Ctrl-C ( Sheet2) 2
OK 3
1.1.2 ( Sheet3) A1 =Sheet1!A1 Sheet1 A1 Sheet1 A1 Sheet3 A1 4
A1 Ctrl-C Ctrl-V A2 =Sheet1!A2 A3 =Sheet1!A3 C11 =Sheet1!C11 Sheet3 Sheet1 Sheet1 A1 Sheet2 A1 Sheet3 A1 1.2 Excel ON 5
1.2.1 6
1.2.2 785 805 ( ) 7
805 ( ) 785 785 805 8
1.3 example2.xls Sheet1 A1 C75 9
example1.xls D2 =MATCH(B2,[example2.xls]Sheet1!$B$1:$B$75,1) MATCH example2.xls Sheet1 B1 B75 B2 4 D2 ctrl-c D2 D11 ctrl-v D3 =MATCH(B3,[example2.xls]Sheet1!$B$1:$B$75,1) D4 10
=MATCH(B4,[example2.xls]Sheet1!$B$1:$B$75,1) D11 =MATCH( B11,[example2.xls]Sheet1!$B$1:$B$75,1) D2 E2 E2 =INDEX([examp le2.xls]sheet1!$a$1:$a$75,d2,1) 11
INDEX example2.xls Sheet1 A1 A75 D2 1 D2 4 E2 ctrl-c E2 E11 ctrl-v F2 =B2-INDEX([examp le2.xls]sheet1!$b$1:$b$75,d2,1)+1 12
F2 ctrl-c F2 F11 ctrl-v G2 =CONCATENATE(E2,F2) 13
G2 ctrl-c G2 G11 ctrl-v 14
15
ctrl-c 16
( Sheet4) 17
18
19
20
D2 =RIGHT(B2,IF(ISNUMBER(INT(RIGHT(B2,2))),2,1)) E2 =SUBSTITUTE(B2,D2,"") F2 =MATCH(E2,[example2.xls]Sheet1!$A$1:$A$75,0) G2 =INDEX([example2.xls]Sheet1!$B$1:$B$75,F2,1)+D2-1 2 Internet Explorer Excel Unicode example1.txt 2.1 example1.txt example1.html <HTML> <HEAD><TITLE>example1.html</TITLE></HEAD> <BODY> <TABLE DATASRC="#example" BORDER=1> <THEAD> <TR> Microsoft Windows Internet Explorer 21
<TH> </TH> <TH> </TH> <TH> </TH> </TR> </THEAD> <TBODY> <TR> <TD><SPAN DATAFLD=" "></SPAN></TD> <TD><SPAN DATAFLD=" "></SPAN></TD> <TD><SPAN DATAFLD=" "></SPAN></TD> </TR> </TBODY> </TABLE> <OBJECT ID="example" CLASSID="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83"> <PARAM NAME="DataURL" VALUE="example1.txt"> <PARAM NAME="UseHeader" VALUE="true"> <PARAM NAME="FieldDelim" VALUE=" "> </OBJECT> </BODY> </HTML> example1.html Internet Explorer example1.txt example1.html <TABLE> ( <TBODY> ) 22
2.2 example2.html <HTML> <HEAD><TITLE>example2.html</TITLE></HEAD> <BODY> <TABLE DATASRC="#example" BORDER=1> <THEAD> <TR> <TH> </TH> <TH onclick="example.sort= + ; example.reset()"> </TH> <TH onclick="example.sort= + ; example.reset()"> </TH> </TR> </THEAD> <TBODY> <TR> <TD><SPAN DATAFLD=" "></SPAN></TD> <TD><SPAN DATAFLD=" "></SPAN></TD> <TD><SPAN DATAFLD=" "></SPAN></TD> </TR> </TBODY> </TABLE> <OBJECT ID="example" CLASSID="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83"> <PARAM NAME="DataURL" VALUE="example1.txt"> <PARAM NAME="UseHeader" VALUE="true"> <PARAM NAME="FieldDelim" VALUE=" "> </OBJECT> </BODY> </HTML> 23
example2.html Internet Explorer example.sort= + ; example.reset() 24
2.3 example3.html <HTML> <HEAD><TITLE>example3.html</TITLE></HEAD> <BODY> <TABLE DATASRC="#example" BORDER=1> <THEAD> <TR> <TH> </TH> <TH onclick="example.filter= = +prompt(?, ); example.reset()"> </TH> <TH> </TH> </TR> </THEAD> <TBODY> <TR> <TD><SPAN DATAFLD=" "></SPAN></TD> <TD><SPAN DATAFLD=" "></SPAN></TD> <TD><SPAN DATAFLD=" "></SPAN></TD> </TR> </TBODY> </TABLE> <OBJECT ID="example" CLASSID="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83"> <PARAM NAME="DataURL" VALUE="example1.txt"> <PARAM NAME="UseHeader" VALUE="true"> <PARAM NAME="FieldDelim" VALUE=" "> </OBJECT> </BODY> </HTML> 25
example3.html Internet Explorer prompt(?, ) 742 example.filter =742 example.reset() 26
JavaScript example4.html <HTML> <HEAD> <TITLE>example4.html</TITLE> <SCRIPT LANGUAGE="JavaScript"> function mysearch(){ var t= ; if(parseint(document.myform.from.value)>0) t= >= +parseint(document.myform.from.value); if(parseint(document.myform.to.value)>0){ if(t!= ) t+= & ; t+= <= +parseint(document.myform.to.value); } example.filter=t; example.reset(); } </SCRIPT> </HEAD> <BODY> <TABLE DATASRC="#example" BORDER=1> <THEAD> <TR> <TH> </TH> <TH> </TH> <TH> </TH> </TR> </THEAD> <TBODY> <TR> <TD><SPAN DATAFLD=" "></SPAN></TD> <TD><SPAN DATAFLD=" "></SPAN></TD> <TD><SPAN DATAFLD=" "></SPAN></TD> </TR> </TBODY> </TABLE> <FORM NAME="myForm"> <INPUT NAME="from" TYPE="text" SIZE=3> - <INPUT NAME="to" TYPE="text" SIZE=3> <INPUT TYPE="button" VALUE=" " onclick="mysearch()"> </FORM> <OBJECT ID="example" CLASSID="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83"> <PARAM NAME="DataURL" VALUE="example1.txt"> <PARAM NAME="UseHeader" VALUE="true"> <PARAM NAME="FieldDelim" VALUE=" "> </OBJECT> </BODY> </HTML> 27
785 805 example.filter >=785& <=805 example.reset() 28