5 examples of 'pandas read excel sheet names' in Python

80
def read_sheet_by_index(self, sheet_index):
81
    """
82
    read an indexed sheet from a excel data book
83
    """
84
    try:
85
        name = self.reader.content_array[sheet_index].name
86
        return {name: self.read_sheet(sheet_index)}
87
88
    except IndexError:
89
        self.close()
90
        raise

68
def worksheet_from_excel(excel_sheet):
69
    worksheet = Worksheet()
70
    for col in range(excel_sheet.ncols):
71
        for row in range(excel_sheet.nrows):
72
            cell = excel_sheet.cell(row, col)
73
            if cell.ctype == XL_CELL_ERROR:
74
                formula = '=%s' % (error_text_from_code[cell.value], )
75
            elif cell.ctype == XL_CELL_DATE:
76
                formula = '=DateTime(%s, %s, %s, %s, %s, %s)' % xldate_as_tuple(
77
                    cell.value, excel_sheet.book.datemode)
78
            else:
79
                formula = unicode(excel_sheet.cell(row, col).value)
80
            worksheet[col + 1, row + 1].formula = formula
81
    return worksheet

92
def ncols(self, worksheet):
93
    """ Return the number of columns in a worksheet """
94
    return self.__sheets__[worksheet]['cols']

49
def write(self, row_n, col_n, value):
50
    '''写入数据，如(2,3，"hello"),第二行第三列写入数据"hello"'''
51
    self.ws.cell(row_n, col_n).value = value
52
    self.wb.save(self.filename)

32
def write_sheet(self, name, objects):
33
    excel_sheet = self._sheet_map[name]
34
    worksheet = self.get_or_create_sheet(excel_sheet)
35
    excel_sheet.write(worksheet, self.styles, objects)
36
37
    self.update_active_sheet()