python操作excel

python操作excel

 

?

1	pip install openpyxl

　　

写：

?

1 2 3 4 5 6 7 8 9 10 11 12 13

import openpyxl   # Load the workbook workbook = openpyxl.load_workbook('path/to/file.xlsx')   # Select the worksheet worksheet = workbook['Sheet1']   # Write data to the worksheet worksheet['A1'] = 'Hello, world!'   # Save the workbook workbook.save('path/to/file.xlsx')

　　

读：

?

1 2 3 4 5 6 7 8 9 10 11

import openpyxl   # Load the workbook workbook = openpyxl.load_workbook('path/to/file.xlsx')   # Select the worksheet worksheet = workbook['Sheet1']   # Read the data from the worksheet for row in worksheet.iter_rows(values_only=True):     print(row)

　　

 

 

 

######################