Python 读取Excel

最新推荐文章于 2024-09-05 18:21:44 发布

原创最新推荐文章于 2024-09-05 18:21:44 发布 · 129 阅读

0 ·

CC 4.0 BY-SA版权

Python 专栏收录该内容

33 篇文章

订阅专栏

本文介绍了一个使用Python进行Excel文件自动化读写的方法，通过openpyxl和xlrd库，实现了对特定行数据的判断与修改，适用于批量处理电话号码运营商标记的任务。

# coding=utf-8

import openpyxl
import xlrd

file_path = 'a.xlsx'


def read_write(row_count):
    work_book = openpyxl.load_workbook(file_path)
    work_sheet = work_book['test']
    for rows_index in range(row_count):
        cell_obj = work_sheet.cell(row=rows_index+1, column=1)
        if cell_obj.value.startswith("137"):
            work_sheet.cell(row=rows_index+1, column=10).value = '移动'
        else:
            work_sheet.cell(row=rows_index+1, column=10).value = '其他'
    work_book.save(file_path)
    work_book.close()
    print 'success'


def get_row_count():
    work_book = xlrd.open_workbook(file_path)
    work_sheet = work_book.sheets()[0]
    row_count = work_sheet.nrows
    # print row_count
    return row_count


def get_column_count():
    work_book = xlrd.open_workbook(file_path)
    work_sheet = work_book.sheets()[0]
    col_count = work_sheet.ncols
    # print col_count
    return col_count


if __name__ == "__main__":
    row_count = get_row_count()
    read_write(row_count)