python替代excel_用Python替换excel中的字符串

一个建议是，将单元格数据读入字符串，然后对其进行操作。在

试试这个：（不幸的是我现在不能运行它）# Open Excel file from a user imput

import xlrd, xlwt

filename = raw_input("Enter Excel file name with extension (.xls) and path")

oldbook = xlrd.open_workbook(filename)

newbook = xlwt.Workbook()

# For all the sheets in the workbook

for sheetname in oldbook.sheet_names():

oldsheet = oldbook.sheet_by_name(sheetname)

newsheet = newbook.add_sheet(sheetname)

# For all the rows and all the columns in an excel

for ii in range(oldsheet.nrows):

for jj in range(oldsheet.ncols):

# Replace

CellString=str(oldsheet.cell(ii, jj).Value)

CellString=CellString.replace("%", "Perc")

CellString=CellString.replace(" ", "_")

newsheet.write(ii, jj, CellString)

# Save the file in a desired location with the desired name

savelocation = raw_input("Enter a new path and file name with extension (.xls) to save the new Excel spread sheet ")

newbook.save(savelocation)