plugin python, xldr
file = system.file.openFile()
if file != None:
book = xlrd.open_workbook(file,encoding_override="cp1251")
book = xlrd.open_workbook(file)
worksheet = book.sheet_by_index(0)
for i in range(1,1000):
oneRow = [linea,PuestoTrabajo]
print 'Cantidad de filas importadas',' ',fila
headers = ["Linea" , " Puesto Trabajo" ]
data = system.dataset.toDataSet(headers, rows)
table = event.source.parent.getComponent('tb_dataPamco')
table.data = data
I don't see a specific question, but I think good general advice is to use the Apache POI library to manipulate import/export/manipulate data in Excel files.
A forum post on the issue:
Except this post is flagged as 7.9 and I'm not sure that the Apache POI library was distributed with any 7.9 build. I would still probably opt for using Apache if I had it available though.
Good point. I didn't catch that.
If 7.9 doesn't include them, you can still put the .jar files in the
lib/core/common folder yourself, but it isn't as seamless.