Curso python + openpyxl (excel)

• udemy
• https://www.udemy.com/course/python-learn-how-to-read-write-and-manipulate-excel-files/learn/lecture/8080232#overview

import openpyxl
import os
 
os.getcwd()
os.chdir(path)
 
wb=openpyxl.load_workbook('...xlsx')
type(wb)
wb.get_sheet_names()

sheet=wb.get_sheet_by_name('pestanya')
type(sheet)
sheet.title
sheet.max_row
sheet.max_column
sheet.title='nou nom'
wb.save('file.xlsx')

wb.create_sheet(index=<posición>,title='titol')
 
std=wd.get_sheet_by_name('titol')
wb.remove_sheet(std)
 
wb.save('file.xlsx')

sheet=wb.get_sheet_by_name('pestanya')
sheet['B2'].value
sheet['B2']='nou valor'
 
e=sheet['B2']
e.value
e.row
e.column
e.value='nou valor'
 
e=sheet.cell(row=2,column=2)
 
wb.save('file.xlsx')

for i in range(1,sheet.max_column+1):
  e=sheet.cell(row=1,column=i)
  print(e.value,end=' ')
 
lista = []
for i in range(1,5):
  e=sheet.cell(row=5,column=i)
  lista.append(e.value)

for i in range(0,len(lista)):
  e=sheet.cell(row=10,column=7+i)
  e.value=list[i]
 
wb.save('file.xlsx')