////DocName: 템플릿 데이터 가져오기 기능--Fxjc_ExcelDatasIntoSqlDatas.js
////Author:lify
////Company:Wavenet
////날짜: 2010-03-12
////EditDate:2010-03-12
////MainContent:발견 사항, Ajax 등
/////////// ///////////////////////////////////////////////// /// /////////////////////////////////////
var excelFileName="" ; //로컬 EXCEL 주소
var oWB;
var idTmr="";
function AutomateExcel3()
{
//PT 테이블의 처음 2행을 제외한 모든 행 삭제
DeleteTablePT();//alert(pic_path document.getElementById("ImgUrl").value);//테스트
var xls=null;
var newBook; >xls = new ActiveXObject(" Excel.Application");
}catch(e){openBg(0);openTS(0);
alert("ActiveX 컨트롤을 여세요. 특정 작업: "도구"를 클릭하세요. " IE "인터넷 옵션"에서 "보안", "사용자 정의 수준", "ActiveX 컨트롤 및 플러그인"을 클릭하고 활성화할 세 번째 항목을 선택하세요.자세한 오류: " e.message);
return ;
}
if (xls == null){openBg(0);openTS(0);
alert("Excel 파일을 생성하지 못했습니다. , Microsoft Office Excel 소프트웨어가 컴퓨터에 올바르게 설치되지 않았거나 브라우저의 보안 수준이 너무 높게 설정되어 있을 수 있습니다!");
return;
}
try{
newBook = xls.Workbooks.Open (excelFileName);//여기서 Add 메서드의 매개 변수는 템플릿
}catch(e){openBg(0);openTS(0)
alert( "로드된 Excel 파일의 경로가 잘못되었습니다. 세부 정보: " e.message);
return ;
}
var oSheet=newBook.ActiveSheet
/////// /////////// //////////////////////////템플릿은 웹 페이지에 데이터를 씁니다.///// ////////////// /////////////////////////////////// ///////
var xhnum=0;
//alert("oSheet.Cells(3,18).value=" oSheet.Cells(3,18).value "|" ( oSheet.Cells(3,5).value=="for(var i=3;i{
if(oSheet.Cells(i,1).value)
{
xhnum
var newRow = document.getElementById(" PT").insertRow(-1);
var newCell;
newRow.align = "center";
newRow.height = "35px";
for(var j=0;j{
if(j== 4)
{
//아무 것도 하지 않음
}
else if(j{
newCell = newRow.insertCell(j);
if( j==0) newCell.innerHTML = (xhnum).toString();//일련번호
else if(j==1)
{
if(!oSheet.Cells(i,1).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,1).value=="——"| |oSheet.Cells(i,1).value=="- -")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,1).value ==""?" ":oSheet.Cells(i,1 ).value);
}
else if(j==2)
{
if(!oSheet.Cells(i ,2).value)
newCell.innerHTML = " " ;
else if(oSheet.Cells(i,2).value=="——"||oSheet.Cells(i,2).value =="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,2).value==""?" ":oSheet.Cells (i,2).value);
//newCell .innerHTML = (oSheet.Cells(i,2).value==""?" ":oSheet.Cells(i,2).value)
}
else if(j==3)
{
if(!oSheet.Cells(i,4).value)
newCell.innerHTML = "
else if; (oSheet.Cells(i,4).value=="— —"||oSheet.Cells(i,4).value=="--")
newCell.innerHTML = " "
else;
newCell.innerHTML = (oSheet.Cells(i,4 ).value==""?" ":oSheet.Cells(i,4).value)
//newCell.innerHTML = (oSheet. Cells(i,4).value==""?" " :oSheet.Cells(i,4).value)
}
else if(j==9)
{
if(!oSheet.Cells(i,j 1).value)
newCell.innerHTML = " "
else if(oSheet.Cells(i,j 1).value=="newCell.innerHTML = "30";
else if(oSheet.Cells(i,j 1).value=="——"||oSheet.Cells(i,j 1).value==" --")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,j 1).value==""?" ":oSheet.Cells(i ,j 1).value);
}
else
{
if(!oSheet.Cells(i,j 1).value)
newCell.innerHTML = " "; >else if(oSheet.Cells(i,j 1).value == "newCell.innerHTML = "30";
else if(oSheet.Cells(i,j 1). value=="
newCell.innerHTML = " "
else if(oSheet.Cells(i,j 1).value=="——"||oSheet.Cells(i, j 1).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,j 1).value==""? " ":oSheet.Cells(i,j 1).value) ;
}
}
else
{
newCell = newRow.insertCell(j-1);//한 개만 적은 것만으로도 충분하며, 더 적은 샘플 번호가 삽입됩니다.
if(j= =0) newCell.innerHTML = (xhnum).toString();//일련 번호
else if(j==1)
{
if(!oSheet.Cells(i,1).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,1).value=="——"| |oSheet.Cells(i,1).value=="--" )
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,1).value ==""?" ":oSheet.Cells(i,1).value);
}
else if(j==2)
{
if(!oSheet.Cells(i ,2).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,2).value=="——"||oSheet.Cells(i,2).value =="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,2).value==""?" ":oSheet.Cells (i,2).value);
//newCell.innerHTML = (oSheet.Cells(i,2).value==""?" ":oSheet.Cells(i,2).value)
}
else if(j==3)
{
if(!oSheet.Cells(i,4).value)
newCell.innerHTML = "
else if; (oSheet.Cells(i,4).value=="——" ||oSheet.Cells(i,4).value=="--")
newCell.innerHTML = " "
else;
newCell.innerHTML = (oSheet.Cells(i,4).value==""?" ":oSheet.Cells(i,4).value)
//newCell.innerHTML = (oSheet. Cells(i,4).value==""?" ":oSheet .Cells(i,4).value)
}
else if(j==9)
{
if(!oSheet.Cells(i,j 1).value)
newCell.innerHTML = " "
else if(oSheet.Cells(i,j 1).value=="newCell.innerHTML = "30";
else if( oSheet.Cells(i,j 1).value=="——"||oSheet.Cells(i,j 1).value==" --")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,j 1).value==""?" ":oSheet.Cells(i ,j 1).값)
}
else
{
if(!oSheet.Cells(i,j 1).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,j 1).value=="newCell.innerHTML = "30";
else if(oSheet.Cells(i,j 1).value=="newCell.innerHTML = " ";
else if(oSheet.Cells(i,j 1).value=="——"||oSheet.Cells(i,j 1).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,j 1).value==""?" ":oSheet.Cells(i,j 1).value);
}
}
}
}
}
////////////////////////// ///////////////////////////////////////////////// /////////////////////////////////////////////////
newBook.Close();
newBook=null;
xls = null;
openBg(0);openTS(0);
/////////////////////////////开启编辑和保存按钮功能////////// ////////////////////////
OnOrOffBtn(1);
///////////////////////////////////////////// //////////////////////////////////////
idTmr = window.setInterval( "정리();",1);
/////////////////////////////////////////////////////////////////////////////// ///////////////////////////
TableIntoDatas();////表格数字字符转化
/// ///////////////////////////////////////////////// ////////////////////////////////
}