Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import xlrd
- book = xlrd.open_workbook('book.xlsx')
- sheet = book.sheets() [1]
- data = [[sheet.cell_value(r,c) for c in range (sheet.ncols)]for r in range(sheet.nrows)]
- from PySide import QtGui
- app = QtGui.QApplication([])
- mytable = QtGui.QTableWidget()
- # если нет заголовков, то следующие три строки можно удалить
- headers = data[0]
- data = data[1:]
- self.setHorizontalHeaderLabels(headers)
- for row, columnvalues in enumerate(data):
- for column, value in enumerate(columnvalues):
- item = QtGui.QTableWidgetItem(value)
- mytable.setItem(row, column, item)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement