게시판 내용을 엑셀폼으로 하고 싶어요. 정보
게시판 내용을 엑셀폼으로 하고 싶어요.본문
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 :
안녕하세요.
야자바에서 무료로 되어 있는겁니다.
<html>
<head>
<style type="text/css">
/* link */
img{border:0px}
.menubody {background-color:Menu; margins:0px; padding:1px; border:2px outset; font-size:9pt; line-height:120%}
.menuitem {cursor:default; font:11px Tahoma; color:MenuText; width:100%; padding: 2px 2px 2px 2px;}
.itemover {cursor:hand; background-color:highlight; font:11px Tahoma; width:100%; padding:2px 2px 2px 2px; color:highlighttext;}
.imgitem {cursor:hand; padding:2px 10px 2px 10px; border:0px; background-color:Menu; vertical-align:middle;}
.line {font-size:0pt;border:1px inset;height:2px;overflow:hidden;margin:3px 1px 3px 1px;}
INPUT {cursor:url(sheet.cur); border:1pt solid #999999; border:none; font-size:9pt;}
TD {font:menu; color:MenuText; text-align:center;}
.t {cursor:default; background-color:#EEEEEE; font-size:9pt; text-align:center;}
.sC {background-color:black; color:white;}
.sT {background-color:black;}
.cu {border:1px solid blue; background-color:blue;}
.ed {border:1px solid red; background-color:red;}
</style>
<title>자바스크립트 엑셀 - Made By Bubble(권병진)</title>
<script>
<!--
/*
자바스크립트 엑셀 - Version 0.5
Made By *** 개인정보보호를 위한 이메일주소 노출방지 ***
*/
cCellC='a';cCellN=2;mC='';mN=0;rC='';rN=0;cellState=0;dragState=0;sRow=0;sCol=0;stack='';rows=5;
strMenu='<div id="menu" class="menubody" style="width:150px; height:100px; position:absolute; left:1px; top:1px; z-index:1; visibility:hidden;">\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="sAll()"> 모두 선택(<span style=text-decoration:underline;>A</span>) Ctrl+A</div>\n'+
'<div class="line"></div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="cut()"><img class=imgitem src=cut.gif width=18 hieght=16> 잘라내기(<span style=text-decoration:underline;>X</span>) Ctrl+X</div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="copy()"><img class=imgitem src=copy.gif width=18 hieght=16> 복사(<span style=text-decoration:underline;>C</span>) Ctrl+C</div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="paste()"><img class=imgitem src=paste.gif width=18 hieght=16> 붙여넣기(<span style=text-decoration:underline;>V</span>) Ctrl+V</div>\n'+
'<div class="line"></div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="rInsert()"> 행 삽입</div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="rDel()"> 행 삭제</div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="cDel()"> 내용 지우기 Delete</div>\n'+
'<div class="line"></div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="mClose()"> 메뉴 닫기</div></div>\n'
document.write(strMenu);
function initiate() {
var txtRow, sheetHead, totalRow = ""
var sheetHead='<table width="800" align="center" border="1" style="border-right:1pt solid black; border-bottom:1pt solid black" bordercolordark="white" bordercolorlight="#666666" cellspacing=0 cellpadding=0 onmousedown="mouseDown(event)" onmousemove="mouseMove(event)" onmouseup="mouseUp(event)" ondblclick="eCell()" onkeydown="cMove()">\n'+
'<tr height="25"><td> </td><td class="t">A</td><td class="t">B</td><td class="t">C</td><td class="t">D</td><td class="t">E</td><td class="t">F</td><td class="t">G</td><td class="t">H</td><td class="t">I</td><td class="t">J</td>\n'
for (i=1;i<=rows;i++) {
var txtRow='<tr>\n'+
'<td height="22" width="50" class="t">'+i+'</td>\n'+
'<td name=a'+i+'><input id=a style="text-align:right;" type=text name=a'+i+' size=10></td>\n'+
'<td name=b'+i+'><input id=b style="text-align:right;" type=text name=b'+i+' size=10></td>\n'+
'<td name=c'+i+'><input id=c style="text-align:right;" type=text name=c'+i+' size=10></td>\n'+
'<td name=d'+i+'><input id=d style="text-align:right;" type=text name=d'+i+' size=10></td>\n'+
'<td name=e'+i+'><input id=e style="text-align:right;" type=text name=e'+i+' size=10></td>\n'+
'<td name=f'+i+'><input id=f style="text-align:right;" type=text name=f'+i+' size=10></td>\n'+
'<td name=g'+i+'><input id=g style="text-align:right;" type=text name=g'+i+' size=10></td>\n'+
'<td name=h'+i+'><input id=h style="text-align:right;" type=text name=h'+i+' size=10></td>\n'+
'<td name=i'+i+'><input id=i style="text-align:right;" type=text name=i'+i+' size=10></td>\n'+
'<td name=j'+i+'><input id=j style="text-align:right;" type=text name=j'+i+' size=10></td>\n'+
'</tr>'
totalRow=totalRow+txtRow;
}
sheet.innerHTML=sheetHead+totalRow+'\n</table>';
cCellC='a';cCellN=1;
cCell_View();
}
function initVar() {
cellState=0;dragState=0;rC='';rN=0;sRow=0;sCol=0;
}
function menu() {
var source=event.srcElement;
cellState=0;
if (window.event.button==1) {
document.all["menu"].style.visibility="hidden";
}
if ((window.event.button==2 || window.event.button==3))
{
document.all["menu"].style.left=event.clientX + document.body.scrollLeft;
document.all["menu"].style.top=event.clientY + document.body.scrollTop;
document.all["menu"].style.visibility="visible";
}
}
function mSel() {
var source=event.srcElement;
if (source.tagName=="DIV") {
source.className="itemover";
} else if (source.tagName=="IMG"||source.tagName=="SPAN") {
source.parentElement.className="itemover";
}
}
function mOut() {
var source=event.srcElement;
if (source.tagName=="DIV") {
source.className="menuitem";
} else if (source.tagName=="IMG"||source.tagName=="SPAN") {
source.parentElement.className="menuitem";
}
}
function sAll() {
tmpC=cCellC;tmpN=cCellN;
cCellC='a';cCellN=1;cCell_View();
rC='a'; rN=1; sCol=9; sRow=rows-1;
selView();
document.all["menu"].style.visibility = "hidden";
}
function cut() {
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'cut');
document.all["menu"].style.visibility = "hidden";
}
function copy() {
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'copy');
document.all["menu"].style.visibility = "hidden";
}
function paste() {
rPaste();
cCell_View();
document.all["menu"].style.visibility = "hidden";
window.event.returnValue=false;
}
function rInsert() {
document.all["menu"].style.visibility = "hidden";
var bcol, brow
bcol=cCellC;
brow=cCellN;
line(1);
rCopy('a'+brow,parseInt(rows)-brow-1,9,'cut');
cCellC='a';cCellN=parseInt(brow)+1;
rPaste();
window.clipboardData.setData("Text", '');
cCellC=bcol;cCellN=brow;
cCell_View();
}
function rDel() {
document.all["menu"].style.visibility = "hidden";
if (rows==3) {
alert("더 이상 행을 삭제할 수 없습니다.");
} else {
var bcol, brow;
bcol=cCellC;
brow=parseInt(cCellN)+1;
if (brow>rows) {
line(-1);
} else {
rCopy('a'+brow,parseInt(rows)-brow,9,'cut');
line(-1);
cCellC='a';cCellN=parseInt(brow)-1;
rPaste();
window.clipboardData.setData("Text", '');
}
cCellC=bcol;
cCellN=(parseInt(brow)-1>rows)? rows:parseInt(brow)-1;
cCell_View();
}
}
function cDel() {
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'del');
document.all["menu"].style.visibility = "hidden";
}
function mClose() {
document.all["menu"].style.visibility = "hidden";
}
function cCell_View() {
var idx
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].parentElement.className="cu";
document.excel.elements[idx].focus();
}
function cCell_Recover () {
var idx
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].className=null;
document.excel.elements[idx].parentElement.className=null;
}
function eCell() {
var srcName, srcTag, idx;
srcName=event.srcElement.name;
srcTag=event.srcElement.tagName;
if (srcName!==undefined) {
idx_name=event.srcElement.name;
cCellC=idx_name.substring(0,1);
cCellN=idx_name.substring(1);
cellState=1;
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].parentElement.className="ed";
document.excel.elements[idx].focus();
}
}
function keySelect() {
var cell, tC, tR
tC=sCol;sCol=charTonum(mC)-charTonum(cCellC);
tR=sRow;sRow=parseInt(mN)-parseInt(cCellN);
cellInit(rC+rN,tC,tR);
cell=searchCell();
rC=cell.substring(0,1);
rN=cell.substring(1);
selView();
}
function cMove() {
var nC, nN, kCode, cell, tC, tR
kCode=event.keyCode;
if (cellState==0) {
if (kCode==32) {
cMove_edit();
window.event.returnValue=false;
} else if (kCode==37) {
if (event.shiftKey==true) {
if (dragState==2) {
mC=numTochar((charTonum(mC)-1<97)? 97 : charTonum(mC)-1);
} else {
dragState=2;
mC=numTochar((charTonum(cCellC)-1<97)? 97 : charTonum(cCellC)-1);
mN=cCellN;
}
keySelect();
} else {
nC=numTochar((charTonum(cCellC)-1<97)? 97 : charTonum(cCellC)-1);
nN=cCellN;
cMove_cursor(nC,nN);
}
} else if (kCode==38) {
if (event.shiftKey==true) {
if (dragState==2) {
mN=(mN-1<1)? 1 : mN-1;
} else {
dragState=2;
mC=cCellC;
mN=(cCellN-1<1)? 1 : cCellN-1;
}
keySelect();
} else {
nC=cCellC;
nN=(cCellN-1<1)? 1 : cCellN-1;
cMove_cursor(nC,nN);
}
} else if (kCode==39) {
if (event.shiftKey==true) {
if (dragState==2) {
mC=numTochar((charTonum(mC)+1>106)? 106 : charTonum(mC)+1);
} else {
dragState=2;
mC=numTochar((charTonum(cCellC)+1>106)? 106 : charTonum(cCellC)+1);
mN=cCellN;
}
keySelect();
} else {
nC=numTochar((charTonum(cCellC)+1>106)? 106 : charTonum(cCellC)+1);
nN=cCellN;
cMove_cursor(nC,nN);
}
} else if (kCode==40) {
if (event.shiftKey==true) {
if (dragState==2) {
mN=(parseInt(mN)+1>rows)? rows : parseInt(mN)+1;
} else {
dragState=2;
mC=cCellC;
mN=(parseInt(cCellN)+1>rows)? rows : parseInt(cCellN)+1;
}
keySelect();
} else {
nC=cCellC;
nN=(parseInt(cCellN)+1>rows)? rows : parseInt(cCellN)+1;
cMove_cursor(nC,nN);
}
} else if (kCode==9) {
if (event.shiftKey==true) {
nC=numTochar((charTonum(cCellC)-1<97)? 97 : charTonum(cCellC)-1);
nN=cCellN;
cMove_cursor(nC,nN);
} else {
nC=numTochar((charTonum(cCellC)+1>106)? 106 : charTonum(cCellC)+1);
nN=cCellN;
cMove_cursor(nC,nN);
}
} else if (kCode==13) {
nC=cCellC;
nN=(parseInt(cCellN)+1>rows)? rows : parseInt(cCellN)+1;
cMove_cursor(nC,nN);
} else if(kCode==65) {
if (event.ctrlKey==true) {
window.event.returnValue=false;
sAll();
} else {
cMove_edit();
}
} else if(kCode==67) {
if (event.ctrlKey==true) {
window.event.returnValue=false;
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'copy');
} else {
cMove_edit();
}
} else if(kCode==88) {
if (event.ctrlKey==true) {
window.event.returnValue=false;
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'cut');
} else {
cMove_edit();
}
} else if(kCode==86) {
if (event.ctrlKey==true) {
window.event.returnValue=false;
rPaste();
cCell_View();
} else {
cMove_edit();
}
} else if (kCode==46) {
cDel();
} else if (33<=parseInt(kCode)&&parseInt(kCode)<=126) {
cMove_edit();
} else if (kCode==190) {
cMove_edit();
} else if (kCode==229) {
cMove_edit();
}
} else {
if(kCode==9) {
if (event.shiftKey==true) {
nC=charTonum(cCellC)-1;
nC=numTochar((nC<97)? 97 : nC);
nN=cCellN;
cMove_cursor(nC,nN);
} else {
nC=charTonum(cCellC)+1;
nC=numTochar((nC>106)? 106 : nC);
nN=cCellN;
cMove_cursor(nC,nN);
}
}
if(kCode==13) {
nC=cCellC;
nN=parseInt(cCellN)+1;
nN=(nN>rows)? rows : nN;
initVar();
cMove_cursor(nC,nN);
}
}
}
function cMove_cursor(c,n) {
window.event.returnValue=false;
cellState=0;
if (!sCol==0||!sRow==0) {
cellInit(rC+rN,sCol,sRow);
} else {
cCell_Recover();
}
initVar();
cCellC=c;
cCellN=n;
cCell_View();
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].focus();
}
function cMove_edit() {
if (!sCol==0||!sRow==0) {
cellInit(rC+rN,sCol,sRow);
} else {
cCell_Recover();
}
cellState=1;
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].className="e";
document.excel.elements[idx].parentElement.className="ed";
document.excel.elements[idx].value="";
document.excel.elements[idx].focus();
}
function mouseDown(e) {
var srcName, srcTag, idx
srcName=e.srcElement.name;
srcTag=e.srcElement.tagName;
if (srcName!==undefined) {
if (window.event.button==2 || window.event.button==3) {
if (sCol!==0||sRow!==0) {
menu();
} else {
cellInit(cCellC+cCellN,sCol,sRow);
initVar();
cCellC=srcName.substring(0,1);
cCellN=srcName.substring(1);
cCell_View();
menu();
}
} else {
document.all["menu"].style.visibility = "hidden";
if (sCol!==0||sRow!==0) {
cellInit(rC+rN,sCol,sRow);
} else {
cCell_Recover();
}
if (e.shiftKey==true) {
dragState=3;
mC=srcName.substring(0,1);
mN=srcName.substring(1);
tC=sCol;sCol=charTonum(mC)-charTonum(cCellC);
tR=sRow;sRow=parseInt(mN)-parseInt(cCellN);
if (tC!==sCol||tR!==sRow) {
cellInit(rC+rN,tC,tR);
cell=searchCell();
rC=cell.substring(0,1);
rN=cell.substring(1);
if (!sCol==0||!sRow==0) {
selView();
} else {
cCell_View();
}
}
} else {
initVar();
if (srcTag=="INPUT"||srcTag=="TD") {
dragState=1;
cCellC=srcName.substring(0,1);
cCellN=srcName.substring(1);
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].parentElement.className="cu";
}
}
}
}
}
function mouseUp(e) {
dragState=0;
}
function mouseMove(e) {
var srcName, srcTag, tC, tR, cell
srcName=e.srcElement.name;
srcTag=e.srcElement.tagName;
if (dragState==1) {
if (srcName!==undefined) {
mC=srcName.substring(0,1);
mN=srcName.substring(1);
tC=sCol;sCol=charTonum(mC)-charTonum(cCellC);
tR=sRow;sRow=parseInt(mN)-parseInt(cCellN);
if (tC!==sCol||tR!==sRow) {
cellInit(rC+rN,tC,tR);
cell=searchCell();
rC=cell.substring(0,1);
rN=cell.substring(1);
if (!sCol==0||!sRow==0) {
selView();
} else {
cCell_View();
}
}
} else {
dragState=0;
}
} else {
}
}
function cellInit(cell, tC, tR) {
var idx, i, j, sR, sC, cC, cN, tR, tC
cC=parseInt(charTonum(cell.substring(0,1)));
cN=parseInt(cell.substring(1));
sR=Math.abs(parseInt(tR));
sC=Math.abs(parseInt(tC));
for (i=cC;i<=cC+sC;i++) {
for (j=cN;j<=sR+cN;j++) {
idx=cellTonum(numTochar(i), j);
document.excel.elements[idx].className=null;
document.excel.elements[idx].parentElement.className=null;
}
}
}
function selView() {
var cC, cN, sR, sC, idx, i, j
cC=parseInt(charTonum(rC));
cN=parseInt(rN);
sR=Math.abs(parseInt(sRow));
sC=Math.abs(parseInt(sCol));
for (i=cC;i<=cC+sC;i++) {
for (j=cN;j<=sR+cN;j++) {
idx=cellTonum(numTochar(i), j);
document.excel.elements[idx].className="sC";
document.excel.elements[idx].parentElement.className="sT";
}
}
}
function rCopy(cell,sR,sC,act) {
var idx, tmp, sCC, i, j, sC, sR, buf="";
cC=parseInt(charTonum(cell.substring(0,1)));
cN=parseInt(cell.substring(1));
sR=Math.abs(parseInt(sR));
sC=Math.abs(parseInt(sC));
if (act=='copy') {
for (j=cN;j<=sR+cN;j++) {
for (i=cC;i<=cC+sC;i++) {
idx=cellTonum(numTochar(i), j);
buf=buf+document.excel.elements[idx].value+'\t';
}
buf=buf.substring(0, buf.length-1);
buf=buf+String.fromCharCode(13)+String.fromCharCode(10);
}
window.clipboardData.setData("Text", buf);
} else if (act=='cut') {
for (j=cN;j<=sR+cN;j++) {
for (i=cC;i<=cC+sC;i++) {
idx=cellTonum(numTochar(i), j);
buf=buf+document.excel.elements[idx].value+'\t';
document.excel.elements[idx].value="";
}
buf=buf.substring(0, buf.length-1);
buf=buf+String.fromCharCode(13)+String.fromCharCode(10);
}
window.clipboardData.setData("Text", buf);
} else if (act=='del') {
for (j=cN;j<=sR+cN;j++) {
for (i=cC;i<=cC+sC;i++) {
idx=cellTonum(numTochar(i), j);
document.excel.elements[idx].value="";
}
}
} else if (act=='line') {
for (j=cN;j<=sR+cN;j++) {
for (i=cC;i<=cC+sC;i++) {
idx=cellTonum(numTochar(i), j);
stack=stack+document.excel.elements[idx].value+'\t';
}
stack=stack.substring(0, stack.length-1);
stack=stack+String.fromCharCode(13)+String.fromCharCode(10);
}
}
}
function rPaste() {
var idx, tmp, sCC, i, j, buf, rr, cc, temp, rLen
temp = new Array();
buf=window.clipboardData.getData("Text");
if (!isEmpty(buf)) {
buf=buf.substring(0, buf.length-2);
rr=buf.split(String.fromCharCode(13)+String.fromCharCode(10));rLen=parseInt(rr.length);
if (parseInt(rLen)-1>parseInt(rows)-parseInt(cCellN)){
line(parseInt(rLen)-(parseInt(rows)-parseInt(cCellN))-1);
}
for (i=0;i<rLen;i++) {
cc=rr[i].split(String.fromCharCode(9));
cLen=cc.length;
temp[i] = new Array(cLen);
for (j=0;j<cLen;j++) {
temp[i][j]=cc[j];
}
}
tmp=parseInt(charTonum(cCellC));
if (tmp+cLen>106) cLen=107-tmp;
sCC=parseInt(cCellN);
for (i=tmp;i<tmp+cLen;i++) {
for (j=sCC;j<sCC+rLen;j++) {
idx=cellTonum(numTochar(i), j);
document.excel.elements[idx].value=temp[j-sCC][i-tmp];
}
}
}
}
function rLine() {
var ix, tp, ssCC, k, l, bf, r, c, tep, cen, ren
tep = new Array();
bf=stack;
if (!isEmpty(bf)) {
bf=bf.substring(0, bf.length-2);
r=bf.split(String.fromCharCode(13)+String.fromCharCode(10));ren=parseInt(r.length);
for (k=0;k<ren;k++) {
c=r[k].split(String.fromCharCode(9));
cen=c.length;
tep[k] = new Array(cen);
for (l=0;l<cen;l++) {
tep[k][l]=c[l];
}
}
tp=parseInt(charTonum(cCellC));
if (tp+cen>106) cen=107-tp;
ssCC=parseInt(cCellN);
for (k=tp;k<tp+cen;k++) {
for (l=ssCC;l<ssCC+ren;l++) {
ix=cellTonum(numTochar(k), l);
document.excel.elements[ix].value=tep[l-ssCC][k-tp];
}
}
}
}
function searchCell() {return (sCol<0? mC:cCellC)+(sRow<0? mN:cCellN);}
function charTonum(c) {return c.charCodeAt(0)}
function numTochar(n) {return String.fromCharCode(n)}
function cellTonum(c,n) {var i, j;i=parseInt(charTonum(c));j=parseInt(n);return i-97+10*(j-1);}
function sWatch() {
var srcClass=event.srcElement.className;
if (srcClass) {
window.event.returnValue=false;
} else {
window.event.returnValue=true;
}
}
function line(n) {
var stackR, n, totalRow = "";
var sheetHead='<table width="800" align="center" border="1" style="border-right:1pt solid black; border-bottom:1pt solid black" bordercolordark="white" bordercolorlight="#666666" cellspacing=0 cellpadding=0 onmousedown="mouseDown(event)" onmousemove="mouseMove(event)" onmouseup="mouseUp(event)" ondblclick="eCell()" onkeydown="cMove()">\n'+
'<tr height="25"><td> </td><td class="t">A</td><td class="t">B</td><td class="t">C</td><td class="t">D</td><td class="t">E</td><td class="t">F</td><td class="t">G</td><td class="t">H</td><td class="t">I</td><td class="t">J</td>\n'
if (n<0) {
stackR=parseInt(rows)+n-1
} else {
stackR=parseInt(rows)-1
}
rows=parseInt(rows)+n;
if (rows<3) {
rows=3;
alert("더 이상 행을 삭제할 수 없습니다.");
} else {
if (rows==3) {
alert("더 이상 행을 삭제할 수 없습니다.");
} else {
}
rCopy('a1',stackR,9,'line');
for (i=1;i<=rows;i++) {
var txtRow='<tr>\n'+
'<td height="22" width="50" class="t">'+i+'</td>\n'+
'<td name=a'+i+'><input id=a style="text-align:right;" type=text name=a'+i+' size=10></td>\n'+
'<td name=b'+i+'><input id=b style="text-align:right;" type=text name=b'+i+' size=10></td>\n'+
'<td name=c'+i+'><input id=c style="text-align:right;" type=text name=c'+i+' size=10></td>\n'+
'<td name=d'+i+'><input id=d style="text-align:right;" type=text name=d'+i+' size=10></td>\n'+
'<td name=e'+i+'><input id=e style="text-align:right;" type=text name=e'+i+' size=10></td>\n'+
'<td name=f'+i+'><input id=f style="text-align:right;" type=text name=f'+i+' size=10></td>\n'+
'<td name=g'+i+'><input id=g style="text-align:right;" type=text name=g'+i+' size=10></td>\n'+
'<td name=h'+i+'><input id=h style="text-align:right;" type=text name=h'+i+' size=10></td>\n'+
'<td name=i'+i+'><input id=i style="text-align:right;" type=text name=i'+i+' size=10></td>\n'+
'<td name=j'+i+'><input id=j style="text-align:right;" type=text name=j'+i+' size=10></td>\n'+
'</tr>'
totalRow=totalRow+txtRow;
}
sheet.innerHTML=sheetHead+totalRow+'\n</table>';
tmpC=cCellC;tmpN=cCellN;
cCellC='a';cCellN=1;
rLine();
cCellC=tmpC;cCellN=(tmpN>rows)?rows:tmpN;
stack='';
}
excel.item.value=rows;
}
function isLetter(c) {return (((c >= "a") && (c<="z")) || ((c >="A") && (c <= "Z")))}
function isEmpty(s) {return ((s == null)||(s.length == 0))}
//-->
</script>
</head>
<body onLoad="initiate();" oncontextmenu="return false" ondragstart="return false" onselectstart="return false">
<p><br><br>
<form name="excel">
<div id=sheet></div>
</form>
</body>
</html>
이 내용을 이용하던지 해서 글쓰기에 내용을 입력하거나 수정을 할 수 있을까요? 며칠을 이러고 있는데 제가 전혀 모르는 내용이다보니 참 답 안나오네요.
오류 주소 :
안녕하세요.
야자바에서 무료로 되어 있는겁니다.
<html>
<head>
<style type="text/css">
/* link */
img{border:0px}
.menubody {background-color:Menu; margins:0px; padding:1px; border:2px outset; font-size:9pt; line-height:120%}
.menuitem {cursor:default; font:11px Tahoma; color:MenuText; width:100%; padding: 2px 2px 2px 2px;}
.itemover {cursor:hand; background-color:highlight; font:11px Tahoma; width:100%; padding:2px 2px 2px 2px; color:highlighttext;}
.imgitem {cursor:hand; padding:2px 10px 2px 10px; border:0px; background-color:Menu; vertical-align:middle;}
.line {font-size:0pt;border:1px inset;height:2px;overflow:hidden;margin:3px 1px 3px 1px;}
INPUT {cursor:url(sheet.cur); border:1pt solid #999999; border:none; font-size:9pt;}
TD {font:menu; color:MenuText; text-align:center;}
.t {cursor:default; background-color:#EEEEEE; font-size:9pt; text-align:center;}
.sC {background-color:black; color:white;}
.sT {background-color:black;}
.cu {border:1px solid blue; background-color:blue;}
.ed {border:1px solid red; background-color:red;}
</style>
<title>자바스크립트 엑셀 - Made By Bubble(권병진)</title>
<script>
<!--
/*
자바스크립트 엑셀 - Version 0.5
Made By *** 개인정보보호를 위한 이메일주소 노출방지 ***
*/
cCellC='a';cCellN=2;mC='';mN=0;rC='';rN=0;cellState=0;dragState=0;sRow=0;sCol=0;stack='';rows=5;
strMenu='<div id="menu" class="menubody" style="width:150px; height:100px; position:absolute; left:1px; top:1px; z-index:1; visibility:hidden;">\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="sAll()"> 모두 선택(<span style=text-decoration:underline;>A</span>) Ctrl+A</div>\n'+
'<div class="line"></div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="cut()"><img class=imgitem src=cut.gif width=18 hieght=16> 잘라내기(<span style=text-decoration:underline;>X</span>) Ctrl+X</div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="copy()"><img class=imgitem src=copy.gif width=18 hieght=16> 복사(<span style=text-decoration:underline;>C</span>) Ctrl+C</div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="paste()"><img class=imgitem src=paste.gif width=18 hieght=16> 붙여넣기(<span style=text-decoration:underline;>V</span>) Ctrl+V</div>\n'+
'<div class="line"></div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="rInsert()"> 행 삽입</div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="rDel()"> 행 삭제</div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="cDel()"> 내용 지우기 Delete</div>\n'+
'<div class="line"></div>\n'+
'<div class="menuitem" onmouseover="mSel()" onmouseout="mOut()" onclick="mClose()"> 메뉴 닫기</div></div>\n'
document.write(strMenu);
function initiate() {
var txtRow, sheetHead, totalRow = ""
var sheetHead='<table width="800" align="center" border="1" style="border-right:1pt solid black; border-bottom:1pt solid black" bordercolordark="white" bordercolorlight="#666666" cellspacing=0 cellpadding=0 onmousedown="mouseDown(event)" onmousemove="mouseMove(event)" onmouseup="mouseUp(event)" ondblclick="eCell()" onkeydown="cMove()">\n'+
'<tr height="25"><td> </td><td class="t">A</td><td class="t">B</td><td class="t">C</td><td class="t">D</td><td class="t">E</td><td class="t">F</td><td class="t">G</td><td class="t">H</td><td class="t">I</td><td class="t">J</td>\n'
for (i=1;i<=rows;i++) {
var txtRow='<tr>\n'+
'<td height="22" width="50" class="t">'+i+'</td>\n'+
'<td name=a'+i+'><input id=a style="text-align:right;" type=text name=a'+i+' size=10></td>\n'+
'<td name=b'+i+'><input id=b style="text-align:right;" type=text name=b'+i+' size=10></td>\n'+
'<td name=c'+i+'><input id=c style="text-align:right;" type=text name=c'+i+' size=10></td>\n'+
'<td name=d'+i+'><input id=d style="text-align:right;" type=text name=d'+i+' size=10></td>\n'+
'<td name=e'+i+'><input id=e style="text-align:right;" type=text name=e'+i+' size=10></td>\n'+
'<td name=f'+i+'><input id=f style="text-align:right;" type=text name=f'+i+' size=10></td>\n'+
'<td name=g'+i+'><input id=g style="text-align:right;" type=text name=g'+i+' size=10></td>\n'+
'<td name=h'+i+'><input id=h style="text-align:right;" type=text name=h'+i+' size=10></td>\n'+
'<td name=i'+i+'><input id=i style="text-align:right;" type=text name=i'+i+' size=10></td>\n'+
'<td name=j'+i+'><input id=j style="text-align:right;" type=text name=j'+i+' size=10></td>\n'+
'</tr>'
totalRow=totalRow+txtRow;
}
sheet.innerHTML=sheetHead+totalRow+'\n</table>';
cCellC='a';cCellN=1;
cCell_View();
}
function initVar() {
cellState=0;dragState=0;rC='';rN=0;sRow=0;sCol=0;
}
function menu() {
var source=event.srcElement;
cellState=0;
if (window.event.button==1) {
document.all["menu"].style.visibility="hidden";
}
if ((window.event.button==2 || window.event.button==3))
{
document.all["menu"].style.left=event.clientX + document.body.scrollLeft;
document.all["menu"].style.top=event.clientY + document.body.scrollTop;
document.all["menu"].style.visibility="visible";
}
}
function mSel() {
var source=event.srcElement;
if (source.tagName=="DIV") {
source.className="itemover";
} else if (source.tagName=="IMG"||source.tagName=="SPAN") {
source.parentElement.className="itemover";
}
}
function mOut() {
var source=event.srcElement;
if (source.tagName=="DIV") {
source.className="menuitem";
} else if (source.tagName=="IMG"||source.tagName=="SPAN") {
source.parentElement.className="menuitem";
}
}
function sAll() {
tmpC=cCellC;tmpN=cCellN;
cCellC='a';cCellN=1;cCell_View();
rC='a'; rN=1; sCol=9; sRow=rows-1;
selView();
document.all["menu"].style.visibility = "hidden";
}
function cut() {
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'cut');
document.all["menu"].style.visibility = "hidden";
}
function copy() {
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'copy');
document.all["menu"].style.visibility = "hidden";
}
function paste() {
rPaste();
cCell_View();
document.all["menu"].style.visibility = "hidden";
window.event.returnValue=false;
}
function rInsert() {
document.all["menu"].style.visibility = "hidden";
var bcol, brow
bcol=cCellC;
brow=cCellN;
line(1);
rCopy('a'+brow,parseInt(rows)-brow-1,9,'cut');
cCellC='a';cCellN=parseInt(brow)+1;
rPaste();
window.clipboardData.setData("Text", '');
cCellC=bcol;cCellN=brow;
cCell_View();
}
function rDel() {
document.all["menu"].style.visibility = "hidden";
if (rows==3) {
alert("더 이상 행을 삭제할 수 없습니다.");
} else {
var bcol, brow;
bcol=cCellC;
brow=parseInt(cCellN)+1;
if (brow>rows) {
line(-1);
} else {
rCopy('a'+brow,parseInt(rows)-brow,9,'cut');
line(-1);
cCellC='a';cCellN=parseInt(brow)-1;
rPaste();
window.clipboardData.setData("Text", '');
}
cCellC=bcol;
cCellN=(parseInt(brow)-1>rows)? rows:parseInt(brow)-1;
cCell_View();
}
}
function cDel() {
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'del');
document.all["menu"].style.visibility = "hidden";
}
function mClose() {
document.all["menu"].style.visibility = "hidden";
}
function cCell_View() {
var idx
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].parentElement.className="cu";
document.excel.elements[idx].focus();
}
function cCell_Recover () {
var idx
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].className=null;
document.excel.elements[idx].parentElement.className=null;
}
function eCell() {
var srcName, srcTag, idx;
srcName=event.srcElement.name;
srcTag=event.srcElement.tagName;
if (srcName!==undefined) {
idx_name=event.srcElement.name;
cCellC=idx_name.substring(0,1);
cCellN=idx_name.substring(1);
cellState=1;
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].parentElement.className="ed";
document.excel.elements[idx].focus();
}
}
function keySelect() {
var cell, tC, tR
tC=sCol;sCol=charTonum(mC)-charTonum(cCellC);
tR=sRow;sRow=parseInt(mN)-parseInt(cCellN);
cellInit(rC+rN,tC,tR);
cell=searchCell();
rC=cell.substring(0,1);
rN=cell.substring(1);
selView();
}
function cMove() {
var nC, nN, kCode, cell, tC, tR
kCode=event.keyCode;
if (cellState==0) {
if (kCode==32) {
cMove_edit();
window.event.returnValue=false;
} else if (kCode==37) {
if (event.shiftKey==true) {
if (dragState==2) {
mC=numTochar((charTonum(mC)-1<97)? 97 : charTonum(mC)-1);
} else {
dragState=2;
mC=numTochar((charTonum(cCellC)-1<97)? 97 : charTonum(cCellC)-1);
mN=cCellN;
}
keySelect();
} else {
nC=numTochar((charTonum(cCellC)-1<97)? 97 : charTonum(cCellC)-1);
nN=cCellN;
cMove_cursor(nC,nN);
}
} else if (kCode==38) {
if (event.shiftKey==true) {
if (dragState==2) {
mN=(mN-1<1)? 1 : mN-1;
} else {
dragState=2;
mC=cCellC;
mN=(cCellN-1<1)? 1 : cCellN-1;
}
keySelect();
} else {
nC=cCellC;
nN=(cCellN-1<1)? 1 : cCellN-1;
cMove_cursor(nC,nN);
}
} else if (kCode==39) {
if (event.shiftKey==true) {
if (dragState==2) {
mC=numTochar((charTonum(mC)+1>106)? 106 : charTonum(mC)+1);
} else {
dragState=2;
mC=numTochar((charTonum(cCellC)+1>106)? 106 : charTonum(cCellC)+1);
mN=cCellN;
}
keySelect();
} else {
nC=numTochar((charTonum(cCellC)+1>106)? 106 : charTonum(cCellC)+1);
nN=cCellN;
cMove_cursor(nC,nN);
}
} else if (kCode==40) {
if (event.shiftKey==true) {
if (dragState==2) {
mN=(parseInt(mN)+1>rows)? rows : parseInt(mN)+1;
} else {
dragState=2;
mC=cCellC;
mN=(parseInt(cCellN)+1>rows)? rows : parseInt(cCellN)+1;
}
keySelect();
} else {
nC=cCellC;
nN=(parseInt(cCellN)+1>rows)? rows : parseInt(cCellN)+1;
cMove_cursor(nC,nN);
}
} else if (kCode==9) {
if (event.shiftKey==true) {
nC=numTochar((charTonum(cCellC)-1<97)? 97 : charTonum(cCellC)-1);
nN=cCellN;
cMove_cursor(nC,nN);
} else {
nC=numTochar((charTonum(cCellC)+1>106)? 106 : charTonum(cCellC)+1);
nN=cCellN;
cMove_cursor(nC,nN);
}
} else if (kCode==13) {
nC=cCellC;
nN=(parseInt(cCellN)+1>rows)? rows : parseInt(cCellN)+1;
cMove_cursor(nC,nN);
} else if(kCode==65) {
if (event.ctrlKey==true) {
window.event.returnValue=false;
sAll();
} else {
cMove_edit();
}
} else if(kCode==67) {
if (event.ctrlKey==true) {
window.event.returnValue=false;
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'copy');
} else {
cMove_edit();
}
} else if(kCode==88) {
if (event.ctrlKey==true) {
window.event.returnValue=false;
var cell
cell=searchCell();
rCopy(cell,sRow,sCol,'cut');
} else {
cMove_edit();
}
} else if(kCode==86) {
if (event.ctrlKey==true) {
window.event.returnValue=false;
rPaste();
cCell_View();
} else {
cMove_edit();
}
} else if (kCode==46) {
cDel();
} else if (33<=parseInt(kCode)&&parseInt(kCode)<=126) {
cMove_edit();
} else if (kCode==190) {
cMove_edit();
} else if (kCode==229) {
cMove_edit();
}
} else {
if(kCode==9) {
if (event.shiftKey==true) {
nC=charTonum(cCellC)-1;
nC=numTochar((nC<97)? 97 : nC);
nN=cCellN;
cMove_cursor(nC,nN);
} else {
nC=charTonum(cCellC)+1;
nC=numTochar((nC>106)? 106 : nC);
nN=cCellN;
cMove_cursor(nC,nN);
}
}
if(kCode==13) {
nC=cCellC;
nN=parseInt(cCellN)+1;
nN=(nN>rows)? rows : nN;
initVar();
cMove_cursor(nC,nN);
}
}
}
function cMove_cursor(c,n) {
window.event.returnValue=false;
cellState=0;
if (!sCol==0||!sRow==0) {
cellInit(rC+rN,sCol,sRow);
} else {
cCell_Recover();
}
initVar();
cCellC=c;
cCellN=n;
cCell_View();
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].focus();
}
function cMove_edit() {
if (!sCol==0||!sRow==0) {
cellInit(rC+rN,sCol,sRow);
} else {
cCell_Recover();
}
cellState=1;
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].className="e";
document.excel.elements[idx].parentElement.className="ed";
document.excel.elements[idx].value="";
document.excel.elements[idx].focus();
}
function mouseDown(e) {
var srcName, srcTag, idx
srcName=e.srcElement.name;
srcTag=e.srcElement.tagName;
if (srcName!==undefined) {
if (window.event.button==2 || window.event.button==3) {
if (sCol!==0||sRow!==0) {
menu();
} else {
cellInit(cCellC+cCellN,sCol,sRow);
initVar();
cCellC=srcName.substring(0,1);
cCellN=srcName.substring(1);
cCell_View();
menu();
}
} else {
document.all["menu"].style.visibility = "hidden";
if (sCol!==0||sRow!==0) {
cellInit(rC+rN,sCol,sRow);
} else {
cCell_Recover();
}
if (e.shiftKey==true) {
dragState=3;
mC=srcName.substring(0,1);
mN=srcName.substring(1);
tC=sCol;sCol=charTonum(mC)-charTonum(cCellC);
tR=sRow;sRow=parseInt(mN)-parseInt(cCellN);
if (tC!==sCol||tR!==sRow) {
cellInit(rC+rN,tC,tR);
cell=searchCell();
rC=cell.substring(0,1);
rN=cell.substring(1);
if (!sCol==0||!sRow==0) {
selView();
} else {
cCell_View();
}
}
} else {
initVar();
if (srcTag=="INPUT"||srcTag=="TD") {
dragState=1;
cCellC=srcName.substring(0,1);
cCellN=srcName.substring(1);
idx=cellTonum(cCellC, cCellN);
document.excel.elements[idx].parentElement.className="cu";
}
}
}
}
}
function mouseUp(e) {
dragState=0;
}
function mouseMove(e) {
var srcName, srcTag, tC, tR, cell
srcName=e.srcElement.name;
srcTag=e.srcElement.tagName;
if (dragState==1) {
if (srcName!==undefined) {
mC=srcName.substring(0,1);
mN=srcName.substring(1);
tC=sCol;sCol=charTonum(mC)-charTonum(cCellC);
tR=sRow;sRow=parseInt(mN)-parseInt(cCellN);
if (tC!==sCol||tR!==sRow) {
cellInit(rC+rN,tC,tR);
cell=searchCell();
rC=cell.substring(0,1);
rN=cell.substring(1);
if (!sCol==0||!sRow==0) {
selView();
} else {
cCell_View();
}
}
} else {
dragState=0;
}
} else {
}
}
function cellInit(cell, tC, tR) {
var idx, i, j, sR, sC, cC, cN, tR, tC
cC=parseInt(charTonum(cell.substring(0,1)));
cN=parseInt(cell.substring(1));
sR=Math.abs(parseInt(tR));
sC=Math.abs(parseInt(tC));
for (i=cC;i<=cC+sC;i++) {
for (j=cN;j<=sR+cN;j++) {
idx=cellTonum(numTochar(i), j);
document.excel.elements[idx].className=null;
document.excel.elements[idx].parentElement.className=null;
}
}
}
function selView() {
var cC, cN, sR, sC, idx, i, j
cC=parseInt(charTonum(rC));
cN=parseInt(rN);
sR=Math.abs(parseInt(sRow));
sC=Math.abs(parseInt(sCol));
for (i=cC;i<=cC+sC;i++) {
for (j=cN;j<=sR+cN;j++) {
idx=cellTonum(numTochar(i), j);
document.excel.elements[idx].className="sC";
document.excel.elements[idx].parentElement.className="sT";
}
}
}
function rCopy(cell,sR,sC,act) {
var idx, tmp, sCC, i, j, sC, sR, buf="";
cC=parseInt(charTonum(cell.substring(0,1)));
cN=parseInt(cell.substring(1));
sR=Math.abs(parseInt(sR));
sC=Math.abs(parseInt(sC));
if (act=='copy') {
for (j=cN;j<=sR+cN;j++) {
for (i=cC;i<=cC+sC;i++) {
idx=cellTonum(numTochar(i), j);
buf=buf+document.excel.elements[idx].value+'\t';
}
buf=buf.substring(0, buf.length-1);
buf=buf+String.fromCharCode(13)+String.fromCharCode(10);
}
window.clipboardData.setData("Text", buf);
} else if (act=='cut') {
for (j=cN;j<=sR+cN;j++) {
for (i=cC;i<=cC+sC;i++) {
idx=cellTonum(numTochar(i), j);
buf=buf+document.excel.elements[idx].value+'\t';
document.excel.elements[idx].value="";
}
buf=buf.substring(0, buf.length-1);
buf=buf+String.fromCharCode(13)+String.fromCharCode(10);
}
window.clipboardData.setData("Text", buf);
} else if (act=='del') {
for (j=cN;j<=sR+cN;j++) {
for (i=cC;i<=cC+sC;i++) {
idx=cellTonum(numTochar(i), j);
document.excel.elements[idx].value="";
}
}
} else if (act=='line') {
for (j=cN;j<=sR+cN;j++) {
for (i=cC;i<=cC+sC;i++) {
idx=cellTonum(numTochar(i), j);
stack=stack+document.excel.elements[idx].value+'\t';
}
stack=stack.substring(0, stack.length-1);
stack=stack+String.fromCharCode(13)+String.fromCharCode(10);
}
}
}
function rPaste() {
var idx, tmp, sCC, i, j, buf, rr, cc, temp, rLen
temp = new Array();
buf=window.clipboardData.getData("Text");
if (!isEmpty(buf)) {
buf=buf.substring(0, buf.length-2);
rr=buf.split(String.fromCharCode(13)+String.fromCharCode(10));rLen=parseInt(rr.length);
if (parseInt(rLen)-1>parseInt(rows)-parseInt(cCellN)){
line(parseInt(rLen)-(parseInt(rows)-parseInt(cCellN))-1);
}
for (i=0;i<rLen;i++) {
cc=rr[i].split(String.fromCharCode(9));
cLen=cc.length;
temp[i] = new Array(cLen);
for (j=0;j<cLen;j++) {
temp[i][j]=cc[j];
}
}
tmp=parseInt(charTonum(cCellC));
if (tmp+cLen>106) cLen=107-tmp;
sCC=parseInt(cCellN);
for (i=tmp;i<tmp+cLen;i++) {
for (j=sCC;j<sCC+rLen;j++) {
idx=cellTonum(numTochar(i), j);
document.excel.elements[idx].value=temp[j-sCC][i-tmp];
}
}
}
}
function rLine() {
var ix, tp, ssCC, k, l, bf, r, c, tep, cen, ren
tep = new Array();
bf=stack;
if (!isEmpty(bf)) {
bf=bf.substring(0, bf.length-2);
r=bf.split(String.fromCharCode(13)+String.fromCharCode(10));ren=parseInt(r.length);
for (k=0;k<ren;k++) {
c=r[k].split(String.fromCharCode(9));
cen=c.length;
tep[k] = new Array(cen);
for (l=0;l<cen;l++) {
tep[k][l]=c[l];
}
}
tp=parseInt(charTonum(cCellC));
if (tp+cen>106) cen=107-tp;
ssCC=parseInt(cCellN);
for (k=tp;k<tp+cen;k++) {
for (l=ssCC;l<ssCC+ren;l++) {
ix=cellTonum(numTochar(k), l);
document.excel.elements[ix].value=tep[l-ssCC][k-tp];
}
}
}
}
function searchCell() {return (sCol<0? mC:cCellC)+(sRow<0? mN:cCellN);}
function charTonum(c) {return c.charCodeAt(0)}
function numTochar(n) {return String.fromCharCode(n)}
function cellTonum(c,n) {var i, j;i=parseInt(charTonum(c));j=parseInt(n);return i-97+10*(j-1);}
function sWatch() {
var srcClass=event.srcElement.className;
if (srcClass) {
window.event.returnValue=false;
} else {
window.event.returnValue=true;
}
}
function line(n) {
var stackR, n, totalRow = "";
var sheetHead='<table width="800" align="center" border="1" style="border-right:1pt solid black; border-bottom:1pt solid black" bordercolordark="white" bordercolorlight="#666666" cellspacing=0 cellpadding=0 onmousedown="mouseDown(event)" onmousemove="mouseMove(event)" onmouseup="mouseUp(event)" ondblclick="eCell()" onkeydown="cMove()">\n'+
'<tr height="25"><td> </td><td class="t">A</td><td class="t">B</td><td class="t">C</td><td class="t">D</td><td class="t">E</td><td class="t">F</td><td class="t">G</td><td class="t">H</td><td class="t">I</td><td class="t">J</td>\n'
if (n<0) {
stackR=parseInt(rows)+n-1
} else {
stackR=parseInt(rows)-1
}
rows=parseInt(rows)+n;
if (rows<3) {
rows=3;
alert("더 이상 행을 삭제할 수 없습니다.");
} else {
if (rows==3) {
alert("더 이상 행을 삭제할 수 없습니다.");
} else {
}
rCopy('a1',stackR,9,'line');
for (i=1;i<=rows;i++) {
var txtRow='<tr>\n'+
'<td height="22" width="50" class="t">'+i+'</td>\n'+
'<td name=a'+i+'><input id=a style="text-align:right;" type=text name=a'+i+' size=10></td>\n'+
'<td name=b'+i+'><input id=b style="text-align:right;" type=text name=b'+i+' size=10></td>\n'+
'<td name=c'+i+'><input id=c style="text-align:right;" type=text name=c'+i+' size=10></td>\n'+
'<td name=d'+i+'><input id=d style="text-align:right;" type=text name=d'+i+' size=10></td>\n'+
'<td name=e'+i+'><input id=e style="text-align:right;" type=text name=e'+i+' size=10></td>\n'+
'<td name=f'+i+'><input id=f style="text-align:right;" type=text name=f'+i+' size=10></td>\n'+
'<td name=g'+i+'><input id=g style="text-align:right;" type=text name=g'+i+' size=10></td>\n'+
'<td name=h'+i+'><input id=h style="text-align:right;" type=text name=h'+i+' size=10></td>\n'+
'<td name=i'+i+'><input id=i style="text-align:right;" type=text name=i'+i+' size=10></td>\n'+
'<td name=j'+i+'><input id=j style="text-align:right;" type=text name=j'+i+' size=10></td>\n'+
'</tr>'
totalRow=totalRow+txtRow;
}
sheet.innerHTML=sheetHead+totalRow+'\n</table>';
tmpC=cCellC;tmpN=cCellN;
cCellC='a';cCellN=1;
rLine();
cCellC=tmpC;cCellN=(tmpN>rows)?rows:tmpN;
stack='';
}
excel.item.value=rows;
}
function isLetter(c) {return (((c >= "a") && (c<="z")) || ((c >="A") && (c <= "Z")))}
function isEmpty(s) {return ((s == null)||(s.length == 0))}
//-->
</script>
</head>
<body onLoad="initiate();" oncontextmenu="return false" ondragstart="return false" onselectstart="return false">
<p><br><br>
<form name="excel">
<div id=sheet></div>
</form>
</body>
</html>
이 내용을 이용하던지 해서 글쓰기에 내용을 입력하거나 수정을 할 수 있을까요? 며칠을 이러고 있는데 제가 전혀 모르는 내용이다보니 참 답 안나오네요.
댓글 전체