卡在 AttributeError 上:尝试在 openpyxl 中保存工作簿时，'int' 对象没有属性 'reindex' [英] Stuck on AttributeError: 'int' object has no attribute 'reindex' when trying to save workbook in openpyxl

问题描述

我无法弄清楚这一点.它在抱怨 wb.save() 行.我不知道是什么原因导致了这个问题.我怀疑这与尝试打开一张空白工作表并在完成格式化操作后保存它有关，但我无法想象我在那里做什么导致了这个问题.当我打开一个现有的电子表格并进行操作时，它运行良好，但这首先要求我拥有一个现有的电子表格.在这里，我正在尝试从头开始创建一个新电子表格.

I can't figure this one out. It's complaining about the wb.save() line. I have no idea what's causing it after banging my head on this. I suspect it has something to do with trying to open a blank sheet and saving it after doing stuff with formatting, but I can't imagine what I'm doing there that's causing this problem. It worked fine when I opened an existing spreadsheet and did manipulations, but that required me to have an existing spreadsheet in the first place. Here, I'm trying to start a new spreadsheet from scratch.

from bs4 import BeautifulSoup 
from lxml import etree 
import os, codecs
import imageFilesSub
import re
import openpyxl, lxml
from openpyxl.utils import get_column_letter, column_index_from_string

homeEnv = 0  # 1 - home, 0 - work

if homeEnv:
    filesDir = r'K:\Users\Johnny\My Documents\_World_of_Waterfalls\Website\tier 2 pages\tier 3 pages\tier 4 pages'
    filesOutDir = r'K:\Users\Johnny\My Documents\_World_of_Waterfalls\WordPressSite'
else:
    filesDir = r'..\old_travelblog_writeups'
    filesOutDir = r'./'


# First get the list of files to parse
filesInDir = os.listdir(filesDir)
filesToParse = []
for file in filesInDir:
    if ('travel-blog' in file) and (file.endswith('-template.html')):
        filesToParse.append(file)

# Open up the travelBlog spreadsheet and set it up
wb = openpyxl.Workbook()
sheet = wb.active
sheet.name = "travelBlog List"
sheet['A1'].value = 'Blog No.'
sheet['B1'].value = 'Title'
sheet['C1'].value = 'Category'
sheet['D1'].value = 'Keyword Tags'
sheet['E1'].value = 'Excerpt'
sheet['F1'].value = 'Featured Image Filename'
sheet['G1'].value = 'Featured Image Alt Text'
sheet['H1'].value = 'Start Date'
sheet['I1'].value = 'End Date'
sheet['J1'].value = 'Old Web Address'
sheet['K1'].value = 'New Travel Blog Body Filename'
sheet['L1'].value = 'Old Travel Blog Template to parse'
sheet.freeze_panes = 'C2'
sheet.column_dimensions['A'].width = 10
sheet.column_dimensions['H','I'] = 20
sheet.column_dimensions['B','F','J','K','L'] = 40
sheet.column_dimensions['D','E'] = 50
from openpyxl.styles import Font
headerFontObj = Font(name='Arial', bold=True)
for col in range(1,sheet.max_column):
    sheet.cell(row=1, column=col).font = headerFontObj

wb.save('travelBlogParsed.xlsx')

提前致谢，约翰尼

推荐答案

我想通了.问题在于以下几行:

I figured it out. The issue was the following lines:

sheet.column_dimensions['H','I'] = 20
sheet.column_dimensions['B','F','J','K','L'] = 40
sheet.column_dimensions['D','E'] = 50

首先，显然，您不能对向量使用 column_dimensions 方法.参数必须是字符串.其次，这些行缺少 .width 属性.所以这些行应该是:

First of all, apparently, you can't use the column_dimensions method on a vector. The argument must be a string. Second, these lines were missing the .width attribute. So those lines should have been:

sheet.column_dimensions['H'].width = 20
sheet.column_dimensions['I'].width = 20
sheet.column_dimensions['B'].width = 40
...
sheet.column_dimensions['E'].width = 50

这篇关于卡在 AttributeError 上:尝试在 openpyxl 中保存工作簿时，'int' 对象没有属性 'reindex'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！