Openpyxl Filter and Sort Data
Filter Data
- The auto_filter attribute is employed to line filtering and sorting conditions.
Openpyxl Filter
Sample Code
from openpyxl import Workbook
wb = Workbook()
sheet = wb.active
sheet['A3'] = 40
sheet['B3'] = 26
row_count = [
(93,45),
(23,54),
(80,43),
(21,12),
(63,29),
(34,15),
(80,68),
(20,41)
]
for row in row_count:
sheet.append(row)
print(sheet.dimensions)
for a1,a2 in sheet[sheet.dimensions]:
print(a1.value, a2.value)
sheet.auto_filter.add_sort_condition('B2:B8')
sheet.auto_filter.add_filter_column(1, ['40', '26'])
wb.save('dimension_1.xlsx')
Output
Merge Data
Openpyxl Merge
Sample Code
from openpyxl.styles import Alignment
wb = Workbook()
sheet = wb.active
sheet.merge_cells('A1:B2')
cell = sheet.cell(row=1, column=1)
cell.value = 'Wikitechy'
cell.alignment = Alignment(horizontal='center', vertical='center')
wb.save('merging.xlsx')
Output
