Manage Excel

2018-653

API 참조)

- automatetheboringstuff.com

- openpyxl.readthedocs.io/end/default

1) pip install openpyxl

2)

Python IDLE Shell> import openpyxl

Python IDLE Shell> openpyxl.__version__

3) 

import os

os.chdir('c:\\users\pc1\\desktop')

wb = openpyxl.load_workbook('example.xlsx') // 미리 example.xlsx 를 만들어 둘것. 내용은 아무거나.

type(wb)

wb.get_sheet_names()

sheet = wb.get_sheet_by_name('Sheet1')

type(sheet)

sheet['A1'].value='abcd'

wb.save(example2.xlsx')

sheet.title = "My Sheet"

sheet.cell(row=1, column=3).value

for i in range(2, 5) : print(sheet.cell(row=i, column=3).value)

sheet.max_row

sheet.max_column

openpyxl.cell.get_column_letter(1) // 'A'

openpyxl.cell.column_index_from_string('Z') // 26

wb.create_sheet(title='My Sheet Name', index=1)

wb.save('example4.xlsx')

sheet.row_dimensions[1].height

sheet.row_dimensions[1].height = 70

sheet.column_dimensions['B'].width = 20

from openpyxl.styles import Font

sheet['B1'].font = Font(sz=14, bold=True, italic=True)

import random

for i in range(1, 11) : sheet ['A' + str(i)].value = random.randint(1, 100)

sheet['c8'].value = '=SUM(C1:C7)'

// http://pyautogui.readthedocs.io/en/latest/

// https://pyautogui.readthedocs.io/en/latest/install.html

// pip install pyautogui

import pyautogui

pyautogui.click(100, 100)