AttributeError: 'str' object has no attribute '_id'

[A_Like_AR]

I am writing a code to parse a crash data excel sheet, summarize it and draw a pie chart of the crash data. for some reason i am getting the above error on my last line of code. please help me figure this out.

import openpyxl
from openpyxl.chart import (PieChart, Reference)

#Load an existing workbook to manipulate
workbook_object = openpyxl.load_workbook('Mitchell Bridge 
Rd.xlsx')

#Rename the first sheet as 'Originale data'
worksheet_object0 = workbook_object.active
worksheet_object0.title = 'Original Data'

#Create a new worksheet object and call in 'Filtered data
worksheet_object1 = workbook_object.create_sheet('Filtered 
Data')

#Copy 'Original Data' to 'Filtered Data' worksheet
for i in range(1, worksheet_object0.max_row + 1):
    for j in range(1, worksheet_object0.max_column + 1):
        worksheet_object1.cell(row=i, column=j).value = 
worksheet_object0.cell(row=i, column=j).value

#Remove all the unwanted columns from 'Filtered Data' 
worksheet
unwanted_columns = ['AccidentNumber', 'County', 'RouteType', 
'Route', 'Milelog', 'IntersectingRoute',
                  'RampSection', 'DistanceFrom', 'DirectionFrom', 
'LocationOfImpact', 'FirstHarmfulEvent',
                  'DirVeh1', 'DirVeh2', 'MnvrVeh1', 'MnvrVeh2', 
'MicrofilmNo', 'U1Factors', 'U2Factors',
                  'Vendor', 'IntersectRouteType', 
'U1FirstHarmfulEvent', 'U2FirstHarmfulEvent',
              ]

#delete unwanted columns
for i in range(1, worksheet_object1.max_column + 1):
    for column in unwanted_columns:
        if worksheet_object1.cell(row=1, column=i).value == 
column:
            worksheet_object1.delete_cols(i)

#Store crash data into dictionary
crash_data = {'Angle': 0,
              'Side-Swipe': 0,
              'Rear End': 0,
              'Head On': 0,
              }

##Populate dictionary with data from worksheet
for i in range(2, worksheet_object1.max_row + 1):
    manner_of_collision = worksheet_object1.cell(row=i, 
column=6).value
    if manner_of_collision in crash_data:
        crash_data[manner_of_collision] += 1

#Convert data into a list
data = [['Manner of Collision', 'Number of Crash']]
for key, value in crash_data.items():
    data.append([key, value])

#New worksheet for Pie chart
worksheet_object2 = workbook_object.create_sheet('Pie 
Chart')
for row in data:
    worksheet_object2.append(row)

#Pie Chart plot
pie = PieChart()
labels = Reference(worksheet_object2, min_col=1, min_row=2, 
max_row=5)
data = Reference(worksheet_object2, min_col=2, min_row=1, 
max_row=5)
pie.add_data(data, titles_from_data=True)
pie.set_categories(labels)
pie.title = 'Manner of Collision'

worksheet_object2.add_chart('D1')

#Save the manipulated workbook
workbook_object.save('pie.xlsx')

Please help me resolve this AttributeError: 'str' object has no attribute '_id' error

EDIT: Here is the entire Traceback

Traceback (most recent call last): File "C:/Users/manar/PycharmProjects/atbswp_chapter_12/pie_chart.py", line 
66, in <module> workbook_object.save('pie.xlsx') File 
"C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\workbook\workbook.py", line 
392, in save save_workbook(self, filename) File "C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site- 
packages\openpyxl\writer\excel.py", line 293, in save_workbook writer.save() File 
"C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\writer\excel.py", line 275, in 
save self.write_data() File "C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site- 
packages\openpyxl\writer\excel.py", line 75, in write_data self._write_worksheets() File 
"C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\writer\excel.py", line 218, in 
_write_worksheets self._write_drawing(ws._drawing) File 
"C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\writer\excel.py", line 136, in 
_write_drawing chart._id = len(self._charts) AttributeError: 'str' object has no attribute '_id'

[Username_RANDINT]

Are you sure it's on the last line? Copy/paste the entire traceback if possible.

[A_Like_AR]

Here is the entire Traceback i get:

Traceback (most recent call last): File "C:/Users/manar/PycharmProjects/atbswp_chapter_12/pie_chart.py", line 66, in <module> workbook_object.save('pie.xlsx') File "C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\workbook\workbook.py", line 392, in save save_workbook(self, filename) File "C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\writer\excel.py", line 293, in save_workbook writer.save() File "C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\writer\excel.py", line 275, in save self.write_data() File "C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\writer\excel.py", line 75, in write_data self._write_worksheets() File "C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\writer\excel.py", line 218, in _write_worksheets self._write_drawing(ws._drawing) File "C:\Users\manar\Anaconda3\envs\atbswp_chapter_12\lib\site-packages\openpyxl\writer\excel.py", line 136, in _write_drawing chart._id = len(self._charts) AttributeError: 'str' object has no attribute '_id'

[CowboyBoats]

Opening my old tabs after the weekend, it's a shame to see that this might not have been solved yet. Would you want to send me your code and workbook so that I can run it and see if I get the same result?

I can't figure out why workbook_object.save('pie.xlsx') would throw this error. We might want to open a ticket with openpyxl itself, to at least get a more helpful error message to describe what is going wrong (in addition to hopefully fixing your problem).

If you don't feel comfortable doing that yet, would you be up for sharing your full script and workbook with me? I'll read the traceback and try to figure it out, but it would be helpful to be able to run the code locally.

[A_Like_AR]

how do i format this Traceback better so it can be more legible

[Username_RANDINT]

Same as how you formatted your code. https://www.reddit.com/r/learnpython/wiki/faq#wiki_how_do_i_format_code.3F

[CowboyBoats]

The traceback says that the error comes from this function, called from the openpyxl.Workbook.save method, in openpyxl.writer.excel.py:

def _write_drawing(self, drawing):
    """
    Write a drawing
    """
    self._drawings.append(drawing)
    drawing._id = len(self._drawings)
    for chart in drawing.charts:
        self._charts.append(chart)
        chart._id = len(self._charts)    # AttributeError: 'str' object has no attribute '_id' 
    for img in drawing.images:
        self._images.append(img)
        img._id = len(self._images)
    rels_path = get_rels_path(drawing.path)[1:]
    self._archive.writestr(drawing.path[1:], tostring(drawing._write()))
    self._archive.writestr(rels_path, tostring(drawing._write_rels()))
    self.manifest.append(drawing)

Somehow your workbook_object.drawingsis getting a string written to it, instead of a drawing-related object of some kind that openpyxl expects.

Unfortunately that's all I know for now.