Python – VSCode – Excel 操作 on Windows 10 No.58

> pip install openpyxl
	Collecting openpyxl
	  Downloading openpyxl-3.0.10-py2.py3-none-any.whl (242 kB)
	     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 242.1/242.1 KB 15.5 MB/s eta 0:00:00
	Collecting et-xmlfile
	  Downloading et_xmlfile-1.1.0-py3-none-any.whl (4.7 kB)
	Installing collected packages: et-xmlfile, openpyxl
Successfully installed et-xmlfile-1.1.0 openpyxl-3.0.10

(例)
mkdir c:\vscode\pythoncode
cd c:\vscode\pythoncode
code .

# (例) exceloperation.py

from openpyxl import load_workbook
from openpyxl import Workbook

#1ファイルのロード
wb=load_workbook('FinancialSample.xlsx')

#2シート名確認
ws=wb['Sheet1']
ws=wb.active
print(f'The sheet name is {ws.title}')

# get all of the sheet
#for row in ws.iter_rows():
#    for cell in row:
#        print(cell.value, end=' ')
#    print() 

#3 シートのデータの列名と 1 行目を表示 (A2-P2 が実際１行名)
first_row=ws['A1':'P2']
for row in first_row:
    for cell in row:
        print(cell.value, end=' ')
    print()

#4 シートを別のシートにコピーし、別名で Excel ファイルを保存
ws2=wb.copy_worksheet(ws)
ws2.title='Sheet2'
print(wb.sheetnames)
wb.save("C://work/vscode/pythoncode/FinancialSample2.xlsx")
print('Saved to FinancialSample2.xlsx') 

（コードの実行結果）
The sheet name is Sheet1
Segment Country Product Discount Band Units Sold Manufacturing Price Sale Price Gross Sales Discounts  Sales COGS Profit Date Month Number Month Name Year 
Government Canada Carretera None 1618.5 3 20 32370 0 32370 16185 16185 2014-01-01 00:00:00 1 January 2014
['Sheet1', 'Sheet2']
Saved to FinancialSample2.xlsx