Excel Operation By OpenPyXL (OpenPyXLによるExcel操作)

OpenPyXLインストール

python -m pip install openpyxl

import openpyxl
wb = openpyxl.Workbook()

import openpyxl
wb = openpyxl.load_workbook('filename')

読み取り専用で開く

import openpyxl
wb = openpyxl.load_workbook('filename', read-only=True)

import openpyxl
wb = openpyxl.save('filename')

import openpyxl
ws = wb.create_sheet(title='sheetname')

import openpyxl
wb = openpyxl.load_workbook('filename')
print(wb.sheetnames)

import openpyxl
wb = openpyxl.load_workbook('filename')
ws = wb['sheetname']

import openpyxl
wb = openpyxl.load_workbook('filename')
ws = wb['sheetname']
wb.remove(ws)

cell = ws['A1']

cell = ws.cell(row=1, col=1)

cell = ws.cell(1, 1)

val = cell.value

cell.value = 'value'