[jQuery] Paste excel data to the table
Hi,
sorry to send this email twice,but prev email may be lost.
I have write some code to paste excel data to table,it worked in firefox
but not in IE6,wait for your help,thanks
please just copy 2*2 data and click "paste"
<script src="jquery.js" type="text/javascript"></script>
<script>
function Paste(){
var ClipboardText=getClipboard();
var ClipboardText=ClipboardText.replace(/[\r\n]/g, ",");
var Rows=ClipboardText.split(",");
for(var iRow=0;iRow<Rows.length;iRow++) {
var Cells=Rows[iRow].split('\t');
for(var iCol=0;iCol<Cells.length;iCol++)
$('#TableExcel tr:eq('+iRow+') td:eq('+iCol+ ')
input:eq(0)').val(Cells[iCol]);
}
}
/**************************************************
http://www.codebase.nl/index.php/command/viewcode/id/174
**************************************************/
function getClipboard() {
if (window.clipboardData) {
return(window.clipboardData.getData('Text'));
}
else if (window.netscape) {
netscape.security.PrivilegeManager.enablePrivilege('UniversalXPConnect');
var clip =
Components.classes['@mozilla.org/widget/clipboard;1'].createInstance(Components.interfaces.nsIClipboard);
if (!clip) return;
var trans =
Components.classes['@mozilla.org/widget/transferable;1'].createInstance(Components.interfaces.nsITransferable);
if (!trans) return;
trans.addDataFlavor('text/unicode');
clip.getData(trans,clip.kGlobalClipboard);
var str = new Object();
var len = new Object();
try {
trans.getTransferData('text/unicode',str,len);
}
catch(error) {
return null;
}
if (str) {
if (Components.interfaces.nsISupportsWString)
str=str.value.QueryInterface(Components.interfaces.nsISupportsWString);
else if (Components.interfaces.nsISupportsString)
str=str.value.QueryInterface(Components.interfaces.nsISupportsString);
else str = null;
}
if (str) {
return(str.data.substring(0,len.value / 2));
}
}
return null;
}
</script>
<input id="paset" type="button" value="Paste" onclick="Paste();"></input>
<table id="TableExcel">
<tr><td><input></input></td><td><input></input></td></tr>
<tr><td><input></input></td><td><input></input></td></tr>
</table>
_______________________________________________
jQuery mailing list
discuss@jquery.com
http://jquery.com/discuss/