记录一下本次实践作业，show code.
import openpyxlimport xlrdimport xlwtfrom datetime import date, datetimefrom xlutils.copy import copy;from openpyxl import Workbookimport numpy as npimport shijian1import shijian2print("1原样输出106 2原样输出实验数据 3456-增删改查")while True:try:n = int(input())if (n == 1):workbook = openpyxl.load_workbook("D:\\python\\细胞上清液中106化合物.xlsx")shenames = workbook.get_sheet_names()# print(shenames)worksheet = workbook.get_sheet_by_name("化合物名称及分类")# print(worksheet)name = worksheet.title# print(name)rows = worksheet.max_rowcolumns = worksheet.max_column# print(rows, columns)for row in worksheet.rows:for cell in row:print(cell.value, end=" ")print()elif (n == 2):workbook = openpyxl.load_workbook("D:\\python\\细胞上清定量结果.xlsx")shenames = workbook.get_sheet_names()# print(shenames)worksheet = workbook.get_sheet_by_name("结果列表")# print(worksheet)name = worksheet.title# print(name)rows = worksheet.max_rowcolumns = worksheet.max_column# print(rows, columns)for row in worksheet.rows:for cell in row:print(cell.value, end=" ")print()elif (n == 3):print("输入1为106 输入2为实验数据:")check = int(input())if (check == 1):workbook = openpyxl.load_workbook("D:\\python\\细胞上清液中106化合物.xlsx")shenames = workbook.get_sheet_names()# worksheet = workbook.get_sheet_by_name("化合物名称及分类")worksheet = workbook.worksheets[0]s1, s2, s3 = input().split()row = [s1, s2, s3]worksheet.append(row)# worksheet.append(row)workbook.save(filename="D:\\python\\细胞上清液中106化合物.xlsx")print("insert success")elif (check == 2):workbook = openpyxl.load_workbook("D:\\python\\细胞上清定量结果.xlsx")shenames = workbook.get_sheet_names()# worksheet = workbook.get_sheet_by_name("化合物名称及分类")worksheet = workbook.worksheets[0]s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, s15, s16 = input().split()row = [s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, s15, s16]worksheet.append(row)# worksheet.append(row)workbook.save(filename="D:\\python\\细胞上清定量结果.xlsx")print("insert success")elif (n == 4):print("输入1为106 输入2为实验数据:")check = int(input())if (check == 1):print("输入要删除的行数:")rownum = int(input())wb = openpyxl.load_workbook(r"D:\\python\\细胞上清液中106化合物.xlsx")ws = wb['化合物名称及分类']ws.delete_rows(rownum, 1)wb.save(r"D:\\python\\细胞上清液中106化合物.xlsx")print("delete success")elif (check == 2):print("输入要删除的行数:")rownum = int(input())wb = openpyxl.load_workbook(r"D:\\python\\细胞上清定量结果.xlsx")ws = wb['结果列表']ws.delete_rows(rownum, 1)wb.save(r"D:\\python\\细胞上清定量结果.xlsx")print("delete success")elif (n == 5):print("输入1为106 输入2为实验数据:")check = int(input())if (check == 1):print("请输入要修改的单元格位置和内容,第一行输入修改的字符串，第二行输入行列单元格位置：")workbook = openpyxl.load_workbook("D:\\python\\细胞上清液中106化合物.xlsx")shenames = workbook.get_sheet_names()worksheet = workbook.get_sheet_by_name("化合物名称及分类")updatestr = input()j, k = map(int,input().split())worksheet.cell(j, k, updatestr)workbook.save(filename="D:\\python\\细胞上清液中106化合物.xlsx")print("update success")elif (check == 2):print("请输入要修改的单元格位置和内容,第一行输入修改的字符串，第二行输入行列单元格位置：")workbook = openpyxl.load_workbook("D:\\python\\细胞上清定量结果.xlsx")shenames = workbook.get_sheet_names()worksheet = workbook.get_sheet_by_name("结果列表")updatestr = input()j, k = map(int, input().split())worksheet.cell(j, k, updatestr)workbook.save(filename="D:\\python\\细胞上清定量结果.xlsx")print("update success")elif (n == 6):print("输入1为106 输入2为实验数据:")check = int(input())if (check == 1):findstr = input()workbook = openpyxl.load_workbook("D:\\python\\细胞上清液中106化合物.xlsx")shenames = workbook.get_sheet_names()worksheet = workbook.get_sheet_by_name("化合物名称及分类")name = worksheet.titlerows = worksheet.max_rowcolumns = worksheet.max_columnfor row in worksheet.rows:for cell in row:if (cell.value == findstr):for cell in row:print(cell.value, end=" ")print()'''for cell in list(worksheet.rows)[1]: # 获取第四行的数据print(cell.value, end=" ")print()'''elif (check == 2):findstr = input()workbook = openpyxl.load_workbook("D:\\python\\细胞上清定量结果.xlsx")shenames = workbook.get_sheet_names()# print(shenames)worksheet = workbook.get_sheet_by_name("结果列表")# print(worksheet)name = worksheet.title# print(name)rows = worksheet.max_rowcolumns = worksheet.max_columnfor row in worksheet.rows:for cell in row:if (cell.value == findstr):for cell in row:print(cell.value, end=" ")print()except:break;
文件路径样式
细胞上清液中106化合物.xlsx
细胞上清定量结果.xlsx
如果觉得《python3：利用openpyxl xlwt xlrd实现对excel的增删改查和读入》对你有帮助，请点赞、收藏，并留下你的观点哦！
