Js 读 Execl

       <script language=javascript>

              function readexcel()

              {

                     var tabvalues="";

                     var tflg=true;

                     var i=2;

                     var endnum

                     var patrnN=/^[a-z]://.*/.xls$/i

 

                     if(!patrnN.exec(f1.filepath.value))

                     {

                            alert("请输入正确的文件路径！");

                            f1.filepath.focus();

                            return false;

                     }

                    

                     var oXL = new ActiveXObject("Excel.Application");

 

                     try

                     {

                            oXL.Workbooks.open(f1.filepath.value);

                     }

                     catch(e)

                     {

                            alert("文件不存在");

                            return false;

                     }

                    

                     var oSheet = oXL.Workbooks.open(f1.filepath.value).ActiveSheet;

                    

                     if(f1.scoretype.value==1)

                     {

                            endnum=9;

                     }

                     else

                     {

                            endnum=6;

                     }

                    

                     while (tflg==true)

                     {

                            if (oSheet.Cells(i,1)>="")

                            {

                                   if(i>2)

                                   {

                                          tabvalues=tabvalues +";";

                                   }

                                   for(j=1;j<=endnum;j++)

                                   {

                                          if(oSheet.Cells(i,j)>="")

                                          {

                                                 strtmp=oSheet.Cells(i,j)

                                          }

                                          else

                                          {

                                                 strtmp=""

                                          }

                                          if(j==1)

                                          {

                                                 tabvalues=tabvalues + strtmp

                                          }

                                          else

                                          {

                                                 tabvalues=tabvalues + "," +strtmp

                                          }

                                   }

                            }

                            else

                                   {

                                          tflg=false;

                                   }

                                  

                            i=i+1;

                     }

                     f1.tabvalue.value=tabvalues;

                     oXL.quit();

                     return true;

                    

              }

       </script>