xlrd单元格类型转换

    self.treeview.setRowCount(self.bst.nrows)
    self.treeview.setColumnCount(self.bst.ncols+1)

    for j in range(self.bst.nrows) :
        for i in range(self.bst.ncols):
            cg = ''
            cell = self.bst.cell(j,i)
            if cell.ctype == xlrd.XL_CELL_TEXT:
                cg = cell.value
            elif cell.ctype == 2 and cell.value % 1 == 0.0:  # ctype为2且为浮点
                cell = int(cell.value)  # 浮点转成整型
                cg = str(cell)  # 转成整型后再转成字符串，如果想要整型就去掉该行:
            elif cell.ctype == 3:
                date = datetime(*xldate_as_tuple(cell.value, 0))
                cell = date.strftime('%Y/%m/%d')
                cg = str(cell)

            newItem = QTableWidgetItem(cg) 
            self.treeview.setItem(j, i+1, newItem)