python编辑excel文件_python编辑excel文件

工程目录结构

工程代码如下：# coding:utf-8

import xlrd,xlwt,xlsxwriter

import os

counter=1

column=0

class ExcelRead:

def test(self):

# 修改当前工作目录

os.chdir("D:\python\PyCharm\AutoOffice\/venv\Src\File")

xlsx = xlrd.open_workbook('./SourceFile/Bom.xlsx')

table = xlsx.sheet_by_index(0)

for i in range(0,table.nrows):

for j in range(0,table.ncols):

print(table.cell_value(i, j))

os.chdir("D:\python\PyCharm\AutoOffice\/venv\Src\File")

new_workbook = xlsxwriter.Workbook('./ModifyToSave/Test1.xlsx')

worksheet = new_workbook.add_worksheet("test")

for i in range(0,100):

for j in range(0, 100):

if(i%2!=0 and j%2!=0):

worksheet.write(i, j, "hello")

new_workbook.close()

运行后效果