I found to paste one row from excel into the table
but I can’t paste all rows
def doPaste(event):
from java.awt import Toolkit
import system
from java.awt.datatransfer import DataFlavor
clipboard = Toolkit.getDefaultToolkit().getSystemClipboard()
contents = clipboard.getContents(None).getTransferData(DataFlavor.stringFlavor)
print contents
headers = [“Tag name type”,“DataType”,“OPCServer”,“OPCItemPath”,“HistoryEnabled”,“PrimaryHistoryProvider”,“HistoricalScanclass”,“HistoricalDeadband”]
data=[]
text = contents
line = text.split("\t")
print line
word = line
#print word
# Add the list as a row of data for our table
data.append(word)
event.source.parent.getComponent(‘Table’).data=system.dataset.toDataSet(headers,data)
Tks