Details of python's use of the excel interactive tool

# I, xlrd read
# 1. Introduce the library & Download the library xlrd
	pip install xlrd  	# Download
	pip show xlrd  		# Show version
	pip install xlrd==1.2.0   # Download the specified version
	import xlrd			# Import
	workBook = xlrd.open_workbook('D:\project\', 'rb') # Open the file
	workBook = xlrd.open_workbook(r'D:\project\')
    allSheetNames = workBook.sheet_names()  # Get the names of all sheets (list type)
    SheetName1= workBook.sheet_names()[0]	# By index number
    print(allSheetNames, SheetName1)
#Output:
	['Sheet1', 'Sheet2', 'Sheet3'] Sheet1
	# Get the contents of the sheet
	sheet1_content1 = workBook.sheet_by_index(0) # The sheet index starts at 0
	sheet1_content2 = workBook.sheet_by_name('sheet1') # Get by sheet name
	# Get whole rows and columns of values (arrays)
	print(sheet1_content1.name,sheet1_content1.nrows,sheet1_content1.ncols)
	# Get whole rows and columns of values (arrays)
	rows = sheet1_content1.row_values(3) # Get the fourth line
	cols = sheet1_content1.col_values(2) # Get the contents of the third column
	print(rows)
	print(cols )
	# Get cell contents (three ways)
	print(sheet1_content1.cell(1, 0).value)
	print(sheet1_content1.cell_value(2, 2))
	print(sheet1_content1.row(2)[2].value)

Create table to write data
# Batch write false data to execl
import xlwt,faker,random
wb=()
sheet002=wb.add_sheet("002")
head=["Name","Age","Gender"]
for h in head:
    (0,(h),h)
    #Use a for loop to write the data row by row, column by column, value by value, using subscripts for columns.
fake=()
for i in  range(1,101):
    (i, 0, ())
    (i, 1, (10,60))
    (i, 2, (['Male','Female']))
("")

#2 Copying a table to write data
import xlwt
import xlrd
import 
rd = xlrd.open_workbook("", formatting_info = True)   # Open the file
wt = (rd)   # Copy
sheets = wt.get_sheet(0)   # Read the first worksheet
(m, n, "I love you!")   # Write to cells in row m-1 and column n-1
("")   # save (a file etc) (computing)

xl = openpyxl.load_workbook('D:\project\', data_only=True)
   # Set up worksheets
    sheet1 = [0]
    for i in range(1, 24):
        (i, 3).value = cvalue
    # Save the form
    ('D:\project\')