10 examples of 'openpyxl get sheet by name' in Python

30
def test_sheet_by_name(self):
31
    for name in self.sheetnames:
32
        sheet = self.book.sheet_by_name(name)
33
        self.assertTrue(isinstance(sheet, Sheet))
34
        self.assertEqual(name, sheet.name)

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()

290
def get_sheet(wb, sheet):
291
    ws = wb.active
292
    if sheet is not None:
293
        try:
294
            ws = wb.get_sheet_by_name(sheet)
295
        except KeyError:
296
            ws = wb.worksheets[sheet]
297
    return ws

515
def sheet(self, name):
516
    """Get the desired sheet, fixing the name if needed"""
517
    return self.workbook.sheet_by_name(self.define_sheet_name(name))

11
def open_sheet(self, name_or_url):
12
    if 'docs.google.com' in name_or_url:
13
        sheet = self._client.open_by_url(name_or_url).sheet1
14
    else:
15
        sheet = self._client.open(name_or_url).sheet1
16
    return sheet

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

106
def start_new_sheet(self, sheet_name):
107
    self.ws = self.wb.create_sheet(sheet_name)

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

190
def write_worksheet_cols(doc, worksheet, style_table):
191
    """Write worksheet columns to xml."""
192
    if worksheet.column_dimensions:
193
        start_tag(doc, 'cols')
194
        for column_string, columndimension in \
195
            sorted(iteritems(worksheet.column_dimensions)):
196
            col_index = column_index_from_string(column_string)
197
            col_def = {'min': str(col_index), 'max': str(col_index)}
198
            if columndimension.width != -1:
199
                col_def['customWidth'] = '1'
200
            if not columndimension.visible:
201
                col_def['hidden'] = 'true'
202
            if columndimension.outline_level > 0:
203
                col_def['outlineLevel'] = str(columndimension.outline_level)
204
            if columndimension.collapsed:
205
                col_def['collapsed'] = 'true'
206
            if columndimension.auto_size:
207
                col_def['bestFit'] = 'true'
208
            if column_string in worksheet._styles:
209
                col_def['style'] = str(style_table[hash(worksheet.get_style(column_string))])
210
            if columndimension.width > 0:
211
                col_def['width'] = str(columndimension.width)
212
            else:
213
                col_def['width'] = '9.10'
214
            tag(doc, 'col', col_def)
215
        end_tag(doc, 'cols')

285
def get_range_of_cells(row_index=None, columns=None):
286
    if columns is None:
287
        start_letter = self._get_column_as_letter(sheet, self.data_df.columns[0], startcol)
288
        end_letter = self._get_column_as_letter(sheet, self.data_df.columns[-1], startcol)
289
    else:
290
        start_letter = self._get_column_as_letter(sheet, columns[0], startcol)
291
        end_letter = self._get_column_as_letter(sheet, columns[-1], startcol)
292
    if row_index is None:  # returns cells range for the entire dataframe
293
        start_index = startrow + 1
294
        end_index = start_index + len(self)
295
    else:
296
        start_index = startrow + row_index + 1
297
        end_index = start_index
298
    return '{start_letter}{start_index}:{end_letter}{end_index}'.format(start_letter=start_letter,
299
                                                                        start_index=start_index,
300
                                                                        end_letter=end_letter,
301
                                                                        end_index=end_index)