python3：利用openpyxl xlwt xlrd实现对excel的增删改查和读入

最新推荐文章于 2022-03-26 21:17:48 发布
最新推荐文章于 2022-03-26 21:17:48 发布
阅读量1.8k 收藏 5
点赞数
文章标签： python excel 列表
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/smebkoo70/article/details/106242018
版权

记录一下本次实践作业，show code.

import openpyxl
import xlrd
import xlwt
from datetime import date, datetime
from xlutils.copy import copy;
from openpyxl import Workbook
import numpy as np
import shijian1
import shijian2





print("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_row
            columns = 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_row
            columns = 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.title
                rows = worksheet.max_row
                columns = worksheet.max_column
                for 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_row
                columns = worksheet.max_column
                for 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

英文名称中文名称分类
DL-2-Aminoadipic acidDL-2-氨基己二酸氨基酸
γ-Aminobutanoic acid (Gaba)γ-氨基丁酸氨基酸
Hydroxyproline羟基脯氨酸 氨基酸
γ-Glu-Cys；γ-L-Glutamyl-L-cysteineG-谷氨酸-半胱-三氟乙酸盐氨基酸
L-Pyroglutamic acidL-焦谷氨酸氨基酸
L-Alanine; AlaL-丙氨酸氨基酸
L-Alanyl-L-glutamineL-丙氨酰-L-谷氨酰胺氨基酸
L-ArginineL-精氨酸氨基酸
L-AsparagineL-天冬酰胺氨基酸
L-Aspartic Acid; AspL-天门冬氨酸氨基酸
DL-CitrullineDL-瓜氨酸氨基酸
CystathionineDL-胱硫醚氨基酸
L-CysteineL-半胱氨酸氨基酸
L-Cystine; CysL-胱氨酸氨基酸
L-Glutamic Acid; GluL-谷氨酸氨基酸
L-Glutamine; GlnL-谷氨酰胺氨基酸
L-Glutathione reducedL-还原型谷胱甘肽氨基酸
Glycine; Gly甘氨酸氨基酸
Glycyl-L-glutaMine Monohydrate甘氨酰-L-谷氨酰胺一水合物氨基酸
L-HistidineL-组氨酸氨基酸
L-IsoleucineL-异亮氨酸氨基酸
L-KynurenineL-犬尿氨酸氨基酸
L-Leucine, LeuL-亮氨酸氨基酸
L-LysineL-赖氨酸氨基酸
L-Methionine; MetL-蛋氨酸氨基酸
DL-Methionine sulfoxideDL-蛋氨酸亚砜氨基酸
N-Acetylaspartic acidN-乙酰-L-天门冬氨酸氨基酸
N-AcetylcysteineN-乙酰-L-半胱氨酸氨基酸
L-OrnithineL-鸟氨酸氨基酸
英文名称中文名称分类
L-Glutathione oxidizedL-谷胱甘肽 (氧化型)氨基酸
L-Phenylalanine; PheL-苯丙氨酸氨基酸
D-Pipecolic acidD-哌啶酸氨基酸
L-Proline; ProL-脯氨酸氨基酸
L-Serine; SerL-丝氨酸氨基酸
L-Threonine, ThrL-苏氨酸氨基酸
L-Tryptophan, TrpL-色氨酸氨基酸
L-Tyrosine, TyrL-络氨酸氨基酸
L-Valine; ValL-缬氨酸氨基酸
Boc-D-Tyr-OHBoc-D-酪氨酸氨基酸
Vitamin B1硫胺素盐酸盐(维生素B1)维生素
4-Aminobenzoic acid 对-氨基苯甲酸维生素
Vitamin C抗坏血酸(维生素C)维生素
D(+)-Biotin生物素(维生素B7)维生素
Choline胆碱维生素
Vitamin B12钴胺素(维生素B12)维生素
Vitamin D2维生素D2维生素
Folic acid叶酸(维生素B9)维生素
5-formyltetrahydrofolate 5-甲酰四氢叶酸维生素
Lipoic acid硫辛酸维生素
Niacinamide烟酰胺(维生素B3)维生素
Nicotinic acid烟酸(维生素B3)维生素
Pantothenic AcidD-泛酸(维生素B5)维生素
Pyridoxamine dihydrochloride吡哆胺盐酸盐(维生素B6)维生素
Pyridoxal hydrochloride吡哆醛盐酸盐(维生素B6)维生素
Pyridoxine吡哆醇(维生素B6)维生素
Vitamin B2核黄素(维生素B2)维生素
Vitamin E维生素E维生素
Vitamin E acetate维生素E乙酸酯维生素
Adenine         腺嘌呤(维生素B4 ）核苷酸
Adenosine腺苷核苷酸
Adenosine 5'-monophosphate腺苷酸核苷酸
Cytidine胞苷核苷酸
Cytidylic acid胞苷酸核苷酸
2'-Deoxycytidine2'-脱氧胞苷核苷酸
Guanine鸟嘌呤核苷酸
英文名称中文名称分类
Guanosine鸟苷核苷酸
Guanosine-5'-monophosphate鸟苷酸核苷酸
Hypoxanthine次黄嘌呤核苷酸
Inosine次黄苷核苷酸
Thymidine胸苷核苷酸
2,​4(1H,​3H)​-​Pyrimidinedione, 5-​methyl-胸腺嘧啶核苷酸
2,​4(1H,​3H)​-​Pyrimidinedione尿嘧啶核苷酸
Uric acid尿酸核苷酸
Uridine尿苷核苷酸
Xanthine2,6-二羟基嘌呤核苷酸
Xanthosine黄嘌呤核苷核苷酸
Penicillin G sodium青霉素G钠抗生素
ethanolamine乙醇胺其他
2-Ketoisovaleric acid3-甲基-2-氧丁酸其他
3-Methyl-2-oxovaleric acid3-甲基-2-氧基戊酸其他
3-(4-Hydroxyphenyl)lactate3-(4-羟基苯基)乳酸其他
Citric acid柠檬酸其他
Ethylenediamine乙二胺其他
Fumaric acid延胡索酸（富马酸）其他
Glyceric acid甘油酸其他
Histamine组胺其他
Isocitric acid异柠檬酸其他
Lactic acid乳酸其他
DL-Malic acidDL-苹果酸其他
O-PhosphorylethanolamineO-磷酸乙醇胺其他
Putrescine 腐胺其他
Pyruvic acid丙酮酸其他
Succinic acid 丁二酸其他
DL-Mevalonic acid 甲羟戊酸其他
itaconic acid衣康酸其他
phthalic acid对苯二甲酸其他
4-coumaric acid4-羟基肉桂酸其他
tropic acid莨菪酸其他
3,5-dinitrosalicylic acid 3,5-二硝基水杨酸其他
Gluconic acid葡萄糖酸其他

 

细胞上清定量结果.xlsx

上机编号S1S2S3S4S5S6S7S8S9S10S11S12S13S14S15
Histamine7258.7511778399.3755561486.4557324651.9061186475.1691584954.2048737686.6010755960.8365713082.2641312820.5479891469.4556628754.1529039027.8661476574.1566112735.355849
L-Ornithine5325.8997967573.4228361312.9128757817.335518777.46725595.36488984232.834361064.5990441724.7363395071.61313248.0789964989.1537315206.8483431305.2117995670.20848
L-Histidine9635.501357416.2210183029.9252334491.8007388175.611812700.03093048042.1785392166.8523187282.4131088307.0156537259.1813824519.6723032347.1380353851.9200978076.10492
Ethanolamine801.70756879970.1797966976.6992068644.449656950.5102485063.7419836486.531366683.9827234833.72884495.1226768159.596119304.1231629178.473306782.56494769192.085798
Glucosamine8227.3223243868.601675114.3176883902.5784418003.9881236543.72873322.91167182534.1620477604.306003355.91934986326.9565512699.908113886.5572418176.704514744.459107
L-Arginine5406.2789396200.0240942929.807128890.4322897856.3179879594.9393617947.3641041296.170319794.7510351620.6841514405.9316436066.4150213766.290823472.9731547.008788
L-Cystine1209.1049049126.757141849.79402995.01033029997.7335992056.073572569.54089233453.8146169100.3064065445.1637058720.3180462229.4088348765.6854163835.0352473457.53374
Glycine1184.9132954630.672685318.4070748504.3297224499.269115020.5608525798.6466243818.8131916854.7418453301.2560161091.6096225720.9820192695.6399059550.9130994988.664459
L-Lysine2756.9690848234.0051552780.592818809.1818874557.1184591321.7182744315.3256521632.3684024143.4807688589.7705225903.5814564618.1952174078.63373159.38695762210.562437
L-Serine6068.952732940.18068378518.070452N/A5234.6529996333.268622883.5497293478.3506259737.4617663320.5761292669.336657294.9417313688.4767521995.7145078667.151344
L-Asparagine8312.5596129327.2644126034.7819498855.1114595721.794518854.29837443304.9475046231.3398929525.1817293565.8839996201.1766139401.0605869595.0459353453.3724749264.430232
L-Aspartic Acid8197.4913252823.4885853643.7660566415.4591278970.2198696395.140158193.30697446783.6563684245.5606628618.6263269946.4351361606.7903341772.9451023592.2817073978.676017
L-Alanine3639.3549352683.6820761688.493606719.55890773006.8987798300.6170583468.4218439053.1462738309.4455991168.3153531659.1211619231.652552812.8361512182.590685164.618287
L-Glutamine4502.1476141925.5917795285.5934442289.01336278.298010048545.4346377438.0644488273.4056441731.9395199998.1222624459.6053752183.2571748493.4203226378.8868942125.408498
Choline6976.4625324846.3167445734.6624028249.9651354415.015827616.4532481622.0084518761.7328183201.6424998372.4717372292.78633015.6300312089.7998945266.8596622272.222783
Hydroxyproline5868.5533852675.5676488035.2328578991.84882253.41784716.9300097624.9954264096.6099055538.5752434957.941222622.5878954811.5015563779.311104877.12853966542.176362
L-Threonine1610.523273583.68439322895.351146442.46781278040.0306425925.9639863159.2303717334.1746779947.8224135485.2459741713.8025723153.7260294944.782156N/A7288.81127
Pyridoxamine dihydrochloride443.65178097156.3148184910.5937855238.9123258915.1808733881.3912281156.1714332767.5565894883.5731034062.9067518759.7193734809.0631882643.066044944.44367117130.572345
γ-Aminobutanoic acid948.30634617927.4790152742.1613484564.21381397.3619741517.0030629172.5102883896.5101989139.7409032369.9214862697.1836239529.9484645356.2680489403.044896765.31441
L-Glutamic AcidN/A8846.162624622.67765759146.7126841941.9618363585.8803765293.877836813.76967529729.656917295.5352921973.9096443387.472765191.5241965833.7338581710.840954
DL-Citrulline4977.9355174792.2779274759.020573374.29659512978.2524846353.686252860.88219258426.5690634651.5894412230.8971274635.7943526687.23371972.0598888451.2930587213.211693
L-Cysteine5605.8992959618.805324570.95246514459.6662058246.562842625.2555234041.3773276447.7825295933.4436066871.9269687791.3954428385.3206242808.5434453503.585376230.9326845
DL-Methionine sulfoxide2701.915378487.7313929764.3905372169.6823973067.1026245257.4797056940.2188665925.064287764.64457874090.4317588736.7058143076.9172849184.205448423.54951722503.254671
L-Proline2564.830052442.40938717945.558857106.2812527608.4756073646.247149092.998113699.212738N/A8998.1608874063.3030597840.5485251617.8607677219.5141075557.79243
L-Valine7395.9188492056.3326731370.0039924366.9682599805.8171746701.3536986183.1074745499.9051327059.0865336545.1672827338.9997088707.7241349856.2597519941.6874812267.677153
Guanine4030.8124053211.5023133078.3442067342.9598273719.9519249649.0826348433.543984122.977084133.7805269607.9808192629.8213071647.5937686317.535848209.2046386316.238912
2,​4(1H,​3H)​-​Pyrimidinedione1350.789436522.4268192133.2114781499.763149N/A4754.3216578141.02697451.727694314596.1428294080.9332045529.5642628552.5701812148.6473691745.2380588792.529301
Cytidine8084.1393139515.7310463879.9898738418.1497451560.941837811.8954607610.76065165859.7054228792.1784694136.9444496606.157585982.8980865967.0421183994.7454787233.113683
L-Methionine9801.556849899.7996128685.41075267.742314454282.0934157094.6711673453.7291969122.8429999130.1441973641.3149074620.7400058599.8241677878.4647538882.4660612106.317811
Niacinamide3737.6219967558.5404695051.3478311388.7345948409.791837447.6581244954.4217723964.9885452500.8471619948.2556633443.4986783100.0898987707.1254582969.1556487084.731147
2'-Deoxycytidine8052.4490748916.8646941875.3742547282.6708739302.3154062749.3289891894.1342725425.7266672556.3478349909.9990026683.401866352.82946476614.8135547003.0371736226.962414
Hypoxanthine3239.451903597.7001557846.69481649864.0855256356.3658593485.039764475.0744988600.6083045133.845591511.1086541100.6781042529.69405325924.3020899856.156971666.499206
L-Pyroglutamic acid2482.2515023130.6260553175.9006364329.0597758905.6233639360.5006787619.9838348298.2319081438.2934636616.0999827987.1610033739.0353352636.985673N/A8882.570994
Vitamin B62199.3957193070.305123653.22977134358.9784221192.1480168769.6766974556.995337559.1920921652.9562113605.971831198.7942513070.8849495641.244517458.69723598875.582963
Xanthine2112.2800765720.6865714867.261591310.8606831274.8053227046.397507313.10861639641.7744085915.1422218733.1481898658.284796495.8217799550.221846756.82499231690.414403
L-Isoleucine7002.4695781224.106187535.88051231.929002337831.6222812996.9680896458.7592881897.510039315.18941577503.1343523733.8100273206.4236784401.7186148457.3012918090.458765
L-Leucine 18986.8969981901.6731455789.4005133277.0805953105.0500329131.5094749882.8869073817.0793987931.546633627.6664615466.4484359345.5743623038.9387043049.4680516576.032994
Uridine491.26545825750.5434849985.8620126994.2873138535.4430486040.9596862191.3553794144.2756795977.666917920.8223043392.3289642241.1059514431.4597595356.1076669898.500685
2,​4(1H,​3H)​-​Pyrimidinedione, 5-​methyl-4972.861427771.881349N/A9232.7170149614.632293696.6114512473.9225524348.7278657231.8185314583.8007424422.9920439740.4679716603.4872391804.8604373493.03134
Guanosine9976.9009757339.8346074862.0810363454.8608977579.9750066130.232234N/A4426.2560484563.351958424.6564683213.3139039267.6201715110.7970246027.1702762524.440932
Xanthosine4472.6192462374.4918316257.1331238210.2362719216.5368998442.373437933.025446165.11758276531.9125696165.3705625256.355279904.1788091899.5056278650.2317898188.252221
Adenosine6774.9369937877.7357446020.9554874846.7417069141.2559049745.0036765084.9232251643.2776272044.3070837897.03594063.1348786800.4799786835.4520666515.5690122696.77046
L-Kynurenine4620.8197067502.8654487744.2979372240.926422358.20345582390.1815623138.7364219199.8947421499.0321323990.5316052524.6277741129.9680191489.2406136871.5879937551.603934
Thymidine7505.6655381065.2363889374.788097750.76339433432.555772508.3740276536.12888763.5050057746.6237564612.7088024678.0553291975.8875553655.9656317154.9979761066.23922
L-Phenylalanine8067.6216357564.3778839500.0838155382.6195713224.9825593141.820865849.0046932908.659242722.056383365.43465044907.1826296788.433511387.593027164.27365124410.691293
Folic acid1976.9450477617.5301593711.973226482.263427762.5117295576.9932939035.2483085233.2530551333.0014945605.1620021456.3932097613.7021221290.7772326859.9478338092.312547
Vitamin B124766.8309671773.2601237111.8782492928.2121353450.4807335427.9309967699.0259293526.3895814286.4401493304.2268672999.3648294213.3086456826.56421678.565726324168.838487
L-Tryptophan1555.1006263740.26894814.997558931722.242712147.68917089264.3385042672.2282371657.2501929070.5752755952.9623862348.209803564.73046686253.2239428751.1994519327.364909
Vitamin B24440.3751971320.1813851367.7657841383.7365586944.0384675756.9244565440.238408161.12131316100.085643381.4597255566.3925745652.0441137514.640002743.13933117315.611969
D(+)-Biotin4476.3255088098.7425224180.6580197056.4846116672.3002065649.1636092117.527398943.93073015102.4765217723.1927116912.5906336366.4462543526.667051567.2241616674.681841

 

 

 

smebkoo70
关注
  • 0
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
python xlrd读取excel所有数据_python读取excel进行遍历/xlrd模块操作
weixin_39794340的博客
11-28 822
我就废话不多说了，大家还是直接看代码吧~#!/usr/bin/env python# -*- coding: utf-8 -*-import csvimport xlrdimport xlwtdef handler_excel(filename=r'/Users/zongyang.yu/horizon/ops_platform/assets/upload/1.xlsl'):# 打开文件workbo...
Python入门基础——列表常用基本操作增删改查
qq_34780861的博客
10-04 4937
列表跟元组有着根本性的区别，列表是可变的类型，可以对列表的内容进行增删改查操作。而分组却是不可变类型。所以列表在实际的应用中更加的灵活可变。
python excel读取、 写入
EdmundBai的博客
09-29 319
def write_data(data): import openpyxl try: workbook = openpyxl.load_workbook(“test.xlsx”) except Exception as e: workbook = openpyxl.Workbook() worksheet = workbook.active worksheet.title = “test.xlsx” worksheet.append([“关键字”, “页码”, “排名”, “url”]) worksheet
初学 python 之 模拟sql语句实现对员工表格的增删改查
weixin_30314793的博客
05-15 133
具体需求: 员工信息表程序，实现增删改查操作： 可进行模糊查询，语法支持下面3种: 　　select name,age from staff_data where age > 22 多个查询参数name,age 用','分割 　　select * from staff_data where dept = 人事 　　select * from sta...
使用Python快速处理Excel操作笔记三：基本操作增删改查
wait me的博客
05-22 773
使用Python快速处理Excel操作笔记三：基本操作增删改查、排序 1、读取excel表格并增加行 index_info = ['姓名', '年龄', '居住地', '薪资'] df = pd.read_excel(filename) ser_data = pd.Series(['夏利', 27, '河北', 20000], index=index_info) all_info = df.append(ser_data, ignore_index=True) pandas读取excel生成的df是Dat
python实现通讯录的增删改查语句_利用python模拟sql语句对员工表格进行增删改查...
weixin_42403100的博客
02-20 368
导读热词本文主要给大家介绍了关于python模拟sql语句对员工表格进行增删改查的相关内容，分享出来供大家参考学习，下面来一起看看详细的介绍：具体需求:员工信息表程序，实现增删改查操作：可进行模糊查询，语法支持下面3种:select name,age from staff_data where age > 22 多个查询参数name,age 用','分割se...
python实现xlwt xlrd 指定条件给excel行添加颜色
09-16
总之，通过结合使用XLWT和XLRD，我们可以实现根据特定条件为Excel文件中的行添加颜色的功能。虽然这种方法有一定的局限性，但在某些情况下仍然是一种实用的解决方案。在未来的项目中，可以考虑升级到更现代的库以...
Python3使用xlrd、xlwt处理Excel方法数据
09-17
Python3中处理Excel文件的方法主要依赖于两个库：xlrd和xlwt。xlrd库用于读取Excel文件，而xlwt库则用于写入Excel文件。这两个库对于处理大量数据，尤其是在数据分析和预处理阶段，是非常有用的工具。 首先，要使用...
Python xlrd/xlwt 创建excel文件及常用操作
09-27
Python中的xlrd和xlwt库是用于处理Excel文件的两个重要工具。xlrd库主要用于读取Excel文件，而xlwt库则用于创建和写入Excel文件。这两个库都是Python进行数据处理时非常实用的库，尤其在数据分析、报表生成以及自动...
python使用xlrd和xlwt读写Excel文件的实例代码
09-20
在Python中，`xlrd` 和 `xlwt` 是两个常用的库，分别用于读取和写入Excel文件。本文将详细介绍如何使用这两个库进行Excel操作。 首先，我们需要确保这两个库已经正确安装。在Linux环境下，如果你已经安装了`pip`，...
实例3：python 删除excel中的多余列
03-25
实例3：python 删除excel中的多余列（所用数据）
python3结合openpyxl库实现excel操作的实例代码
09-20
Python3结合openpyxl库是...以上就是使用Python3和openpyxl库进行Excel操作的主要知识点，通过这些方法，你可以实现对Excel文件的全面控制，无论是创建新表、读取数据还是格式化工作表，openpyxl都能提供强大的支持。
使用python 对Excel表简单的增删改查
fanudediandian的博客
10-16 4744
#用于副本操作 # 封装Excel类，用于操作excel文件，管理数据并CRUD #Excel表需提前建好 表头也需提前在Excel表中写好 import xlrd import xlwt from xlutils.copy import copy import os #TODO: 创建一个Excel表类 class Excel(object): def __init__(self...
python操作mysql数据库(增、删、改、查)_Python3操作mysql数据库，实现增、批量增、删、改、查...
weixin_39659837的博客
12-06 342
Python3 MySQL 数据库操作什么是 PyMySQL？PyMySQL 是在 Python3.x 版本中用于连接 MySQL 服务器的一个库，Python2中则使用mysqldb。 PyMySQL 遵循 Python 数据库 API v2.0 规范，并包含了 pure-Python MySQL 客户端库。PyMySQL 安装在使用 PyMySQL 之前，我们需要确保 PyMySQL 已安装。...
利用Python对Excel数据进行处理
热门推荐
weixin_54500974的博客
07-08 4万+
通过本文，记录分享我利用Python对已存在的excel表格进行数据处理。 1.功能分析 1. 加载文件夹内所有的Excel数据； 2. 生产贡献度分析图表(以柱状图显示表格数据)； 3.提起Excel表格中指定列数据； 4. 定向筛选所需数据； 5. 多表数据统计排行； 6.多表数据合并在文件夹内生成合并后的新excel表格。 2. 系统开发必备 2.1 系统开发环境 本系统的软件开发及运行环境具体如下： 操作系统：Windows7、Windows10； Python版本：Pyt.
python对excel数据增删改查_Python操作Mysql——使用python批量对数据进行增删改查...
weixin_28842269的博客
01-14 214
如果对于sqlalchemy框架不会使用，可以看——Python操作MySql——使用SQLAlchemy ORM操作数据库1 使用sqlalchemy 框架，连接数据库from random import randomfrom sqlalchemy import create_enginefrom sqlalchemy.ext.declarative import declarative_bas...
Python 对excel数据增删改查
weixin_39482751的博客
05-17 1533
Python 对excel数据增删改查 1、查（读指定文件） import pandas as pd openfile='C:/Users/Desktop/School/data.xlsx' #这是我自己的文件路径，请运行前修改成你的路径 table=pd.read_excel(openfile,sheet_name='Sheet1',engine='openpyxl',keep_default_na=False) #注意 keep_default_na=False 表示读入空数据为'',而不是nan
python之列表的增删改查四种方法
weixin_65440201的博客
03-26 1万+
首先我们创建一个列表： n = [1,2,3,4,5] 1.增 此时我们用到一个函数append()，其作用是： 在列表的末尾增加一个指定的元素，比如说： n = [1,2,3,4,5,6,7,8,9,10] n.append(11)//其中11为指定的元素，增加到列表的末尾 此外，还有一个函数也有该功能，那就是extend()，但是这个函数有所限制： extend()方法的参数必须是一个可迭代对象，新的内容是追加到原列表最后一个元素的后面。 以上是在末尾增加一个元素，那么我们在列..
利用python包（xlrd和xlwt）处理excel
B_H_L的专栏
11-28 1万+
一 读取excel   这里介绍一个不错的包xlrd ,可以工作在任何平台。这也就意味着你可以在Linux下读取Excel文件。 下载http://pypi.python.org/pypi/xlrd 首先，打开workbook；     import xlrd wb = xlrd.open_workbook('myworkbook.xls') 检查表单名字：  
python excel快速处理入门教程:xlwt与xlrd库的使用
最新发布
11-04
总结起来，xlwt和xlrd是Python用于处理Excel文件的两个常用库。xlwt用于将数据写入Excel文件，而xlrd用于读取Excel文件中的数据。通过学习xlwt和xlrd的使用，可以方便地进行Excel文件的处理和操作。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值