批量处理一些EXCEL数据,但是导出的时候后面的一些字没了,是怎么回事?
"from openpyxl import Workbook\n",
"from openpyxl import load_workbook\n",
"from openpyxl.writer.excel import ExcelWriter\n",
"import os\n",
"\n",
"\n",
"rootPath = \"C:/Users/95806/Desktop/data/\" #文件夹位置\n",
"resultPath = \"C:/Users/95806/Desktop/result/\" #存放位置\n",
"\n",
"excelNames = os.listdir(rootPath) #获得所有的文件名\n",
"\n",
"for i in range(len(excelNames)):\n",
" # print(excelName)\n",
" excelName = excelNames[i]\n",
" path = rootPath + excelName #当前excel位置\n",
" wb = load_workbook(path)\n",
" sheetnames = wb.sheetnames #获得表单名字 \n",
" sheet = wb[sheetnames[0]]\n",
" \n",
" #修改操作\n",
" cell = sheet['C9'].value\n",
" sheet['C9'].value = str(sheet['C9'].value) +'%%'\n",
" cell = sheet['F9'].value\n",
" sheet['F9'].value = str(sheet['F9'].value) +'%%'\n",
" \n",
" #输出\n",
" saveFile = resultPath + \"output\" + excelName\n",
" wb.save(saveFile)
运行结果会导致我少了后面的勾什么的,为什么呢
我只想把那里面的C9改成和后面一样的双百分比格式,其余不动
是不是大小超限了,试试Pandas库