EXCELファイルのjsコード1/2ページを読み取ることができます

8757 ワード

トップページには中国語の説明例がありますが、次の例では多くの人がテストすることができます.

 
  
<!-- 
  <br>function readExcel() { 
  <br>var excelApp; 
  <br>var excelWorkBook; 
  <br>var excelSheet; 
  <br>try{ 
  <br>excelApp = new ActiveXObject("Excel.Application"); 
  <br>excelWorkBook = excelApp.Workbooks.open("C:\\XXX.xls"); 
  <br>excelSheet = oWB.ActiveSheet; //WorkSheets("sheet1") 
  <br>excelSheet.Cells(6,2).value;//cell  
  <br>excelSheet.usedrange.rows.count;//  
  <br>excelWorkBook.Worksheets.count;// sheet  
  <br>excelSheet=null; 
  <br>excelWorkBook.close(); 
  <br>excelApp.Application.Quit(); 
  <br>excelApp=null; 
  <br>}catch(e){ 
  <br>if(excelSheet !=null || excelSheet!=undefined){ 
  <br>excelSheet =nul; 
  <br>} 
  <br>if(excelWorkBook != null || excelWorkBook!=undefined){ 
  <br>excelWorkBook.close(); 
  <br>} 
  <br>if(excelApp != null || excelApp!=undefined){ 
  <br>excelApp.Application.Quit(); 
  <br>excelApp=null; 
  <br>} 
  <br>} 
  <br> 
  <br>// -->

 
  
 EXCEL  ， ， EXCEL.EXE， ， ！ 
  
 
  <br>function ReadExcel() 
  <br>{ 
  <br>var tempStr = ""; 
  <br>var filePath= document.all.upfile.value; 
  <br>var oXL = new ActiveXObject("Excel.application"); 
  <br>var oWB = oXL.Workbooks.open(filePath); 
  <br>oWB.worksheets(1).select(); 
  <br>var oSheet = oWB.ActiveSheet; 
  <br>try{ 
  <br>for(var i=2;i<46;i++) 
  <br>{ 
  <br>if(oSheet.Cells(i,2).value =="null" || oSheet.Cells(i,3).value =="null" ) 
  <br>break; 
  <br>var a = oSheet.Cells(i,2).value.toString()=="undefined"?"":oSheet.Cells(i,2).value; 
  <br>tempStr+=(" "+oSheet.Cells(i,2).value+ 
  <br>" "+oSheet.Cells(i,3).value+ 
  <br>" "+oSheet.Cells(i,4).value+ 
  <br>" "+oSheet.Cells(i,5).value+ 
  <br>" "+oSheet.Cells(i,6).value+"
"); 
  <br>} 
  <br>}catch(e) 
  <br>{ 
  <br>document.all.txtArea.value = tempStr; 
  <br>} 
  <br>document.all.txtArea.value = tempStr; 
  <br>oXL.Quit(); 
  <br>CollectGarbage(); 
  <br>} 
  <br> 
  
 
  
 
  

 
  
 
  <br/> 
  <br/> 
 </code></pre> 
 <br/> 、 
 <br/>js excel  
 <br/> 
   
 <pre><code> 
  <br/><script> 
  <br>function readThis(){ 
  <br>var tempStr = ""; 
  <br>var filePath= document.all.upfile.value; 
  <br>var oXL = new ActiveXObject("Excel.application"); 
  <br>var oWB = oXL.Workbooks.open(filePath); 
  <br>oWB.worksheets(1).select(); 
  <br>var oSheet = oWB.ActiveSheet; 
  <br>try{ 
  <br>for(var i=2;i<46;i++){ 
  <br>if(oSheet.Cells(i,2).value =="null" || oSheet.Cells(i,3).value =="null" ) 
  <br>break; 
  <br>var a = oSheet.Cells(i,2).value.toString()=="undefined"?"":oSheet.Cells(i,2).value; 
  <br>tempStr+=(" "+oSheet.Cells(i,2).value+" "+oSheet.Cells(i,3).value+" "+oSheet.Cells(i,4).value+" "+oSheet.Cells(i,5).value+" "+oSheet.Cells(i,6).value+"<br>"); 
  <br>} 
  <br>} 
  <br>catch(e){ 
  <br>//alert(e); 
  <br>document.all.txtArea.value = tempStr; 
  <br>} 
  <br>document.all.txtArea.value = tempStr; oXL.Quit(); 
  <br>CollectGarbage(); 
  <br>} 
  <br></script> 
  <br/> 
  <br/><input type="file" id="upfile"/> 
  <br/><input type="button" onclick="readThis();" value=" "/><br/> 
  <br/><textarea id="txtArea" cols="50" rows="10"/> 
  <br/> 
  <br/> 
 </code></pre> 
 <br/> 、 
 <br/> vs2005 ， excel sqlserver2005  
 <br/> ajax ， javascript excel ， excel ， web c# 。 。 
 <br/> ，  
 <br/> javascript ， excel  
 <br/> 
   
 <pre><code> 
  <br/>function readExcel() 
  <br/>{ 
  <br/>try 
  <br/>{ 
  <br/>var ExcelNum=new Array(); 
  <br/>// ，  
  <br/>WebServiceExcel.deleteOldNumber(); 
  <br/>var oXL = new ActiveXObject( "Excel.Application "); 
  <br/>\\r_c_num[5] excel  
  <br/>var path=document.all.excelpath.value+ "\\ "+r_c_num[5] 
  <br/>var oWB = oXL.Workbooks.open(path); 
  <br/>\\ excel sheet sheet  
  <br/>for(var x=1;x <=oWB.worksheets.count;x++) 
  <br/>{ 
  <br/>oWB.worksheets(x).select(); 
  <br/>var oSheet =oWB.ActiveSheet; 
  <br/>\\ excel  
  <br/>for(var i=parseInt(r_c_num[6]);i <=parseInt(r_c_num[7]);i++) 
  <br/>{ 
  <br/>for(var j=parseInt(r_c_num[8]);j <=parseInt(r_c_num[9]);j++) 
  <br/>{ 
  <br/>if(typeof(oSheet.Cells(i,j).value)== "undefined ") 
  <br/>{ 
  <br/>ExcelNum[j-parseInt(r_c_num[8])+6]= " "; 
  <br/>} 
  <br/>else 
  <br/>{ 
  <br/>switch_letter(j); 
  <br/>ExcelNum[j-parseInt(r_c_num[8])+6]=oSheet.Cells(i,j).value； 
  <br/>} 
  <br/>} 
  <br/>//  
  <br/>WebServiceExcel.insert_From_Excel(ExcelNum); 
  <br/>} 
  <br/>} 
  <br/>} 
  <br/>} 
  <br/>catch(err) 
  <br/>{ 
  <br/>alert( " , "+err.message); 
  <br/>} 
  <br/>} 
  <br/> 
 </code></pre> 
 <br/> 。 
 <br/> ， excel ， ， ， ？？？ ， 。 ， ， ！！！ 
 <br/> JavaScript Excel.Application excel  
 <br/> 
   
 <pre><code> 
  <br/> 
  <br/> 
  <br/> 
  <br/><title> New Document </title> 
  <br/><script language="JavaScript"> 
  <br><!-- 
  <br>var excelFileName = "E:/project/eomstools/ShowTaskCodeWorkbook/test.xls"; 
  <br>var oWB; 
  <br>function showExcel(targetDIVID){ 
  <br>//objID ID 
  <br>// ActiveX 
  <br>// Start Excel and get Application object. 
  <br>var oXL=null; 
  <br>try{ 
  <br>oXL = new ActiveXObject("Excel.Application"); 
  <br>}catch(e){ 
  <br>alert(e.message); 
  <br>return ; 
  <br>} 
  <br>if (oXL == null){ 
  <br>alert(" Excel ， Microsoft Office Excel ！"); 
  <br>return; 
  <br>} 
  <br>try{ 
  <br>// Get a new workbook. 
  <br>oWB = oXL.Workbooks.Open(excelFileName); 
  <br>for (i = 1; i <= oWB.Sheets.Count; i++){ 
  <br>if (oWB.Sheets(i).name.lastIndexOf(" ") != -1){ 
  <br>showSheet(i); 
  <br>} 
  <br>} 
  <br>} 
  <br>catch (e){ 
  <br>alert(e.message); 
  <br>} 
  <br>oWB.Close();　　　// close ， 。 
  <br>oWB = null; 
  <br>oXL = null; 
  <br>} 
  <br>function showSheet(sheetNO){ 
  <br>var oSheet = oWB.Sheets(sheetNO); 
  <br>document.write("<table border=1>"); 
  <br>for (i = 1; i < oSheet.UsedRange.Rows.Count; i++){ 
  <br>document.write("<tr>"); 
  <br>for (j = 1; j < oSheet.UsedRange.Columns.Count; j++){ 
  <br>value = oSheet.Cells(i, j).Value; 
  <br>if (value == undefined){ 
  <br>value = " "; 
  <br>} 
  <br>document.write(i == 1 ? "<th nowrap=true><b>" : "<td>"); 
  <br>document.write(value); 
  <br>document.write(i == 1 ? "</b></th>" : "</td>"); 
  <br>} 
  <br>document.write("</tr>"); 
  <br>} 
  <br>document.write("</table>"); 
  <br>oSheet = null; 
  <br>} 
  <br>//--> 
  <br></script> 
  <br/> 
  <br/> 
  <br/> 
  <br/> 
  <br/> 
 </code></pre> 
 <br/> 
 <div class="pagenum tc"> 
  <strong>1</strong> 2     
 </div> 
 <div class="clearfix"> 
  <span id="art_bot" class="jbTestPos"/> 
 </div> 
</div>
                            </div>
                        </div>

pthreadマルチスレッド加速例(大型マトリクス乗算):Blocking,1024スレッド^^;

Zynq_Mp----SSDファイルの読み書き速度をテストする