FilesExpand file tree

 master

/

readExcel.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

17 lines (17 loc) · 610 Bytes

 master

/

readExcel.py

Copy path

Top

File metadata and controls

• Code
• Blame

17 lines (17 loc) · 610 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

from openpyxl import Workbook

from openpyxl.compat import range

from openpyxl.cell import get_column_letter

wb = Workbook()

dest_filename = 'empty_book2.xlsx'

ws1 = wb.active # 第一个表

ws1.title = "range names" # 第一个表命名

# 遍历第一个表的1到40行，赋值一个600内的随机数

for row in range(1, 40):

ws1.append(range(60))

ws2 = wb.create_sheet(title="Pi")

ws2['F5'] = 3.14

ws3 = wb.create_sheet(title="Data")

for row in range(10, 20):

for col in range(27, 54):

_ = ws3.cell(column=col, row=row, value="%s" % get_column_letter(col))

wb.save(filename=dest_filename)