xlsxwriter AttributeError: 'str' object has no attribute 'add_worksheet'

Question

I'm trying to write a python script where I add multiple worksheets to an excel document and each sheet's name is the name of a folder and I keep getting the error "AttributeError: 'str' object has no attribute 'add_worksheet'"

Here is a sample of my code:

import os
import xlsxwriter

directory = r"D:\Work\Folders"
workbook = (r"D:\Work\Folders\Data.xlsx")



for folder in os.listdir(directory):
    workbook = ("Data.xlsx")
    workbook.add_worksheet(folder)
    print (folder)

Its simple but I cant seam to figure out what the issue is.

Welcome to SO. Fwiw, workbook is a string since you've set it in workbook = ("Data.xlsx"). you're not using xlswriter at all. Did you intend to do workbook = xlswriter.Workbook("Data.xlsx")? And you also don't need to put workbook = ... inside the loop. — ewokx
– ewokx, Commented Oct 6, 2020 at 0:08

gold_cy · Accepted Answer · 2020-10-06 00:37:30Z

1

At no point in your code are you utilizing xlsxwriter. You simply iterate over a directory and try to use a add_worksheet method on a string, as the traceback shows. Just wrapping "Data.xlsx" in a tuple does not magically make it an Excel workbook. You will need to check the documentation for how to use xlsxwriter and how to open files with it.

answered Oct 6, 2020 at 0:37

gold_cy

14.2k4 gold badges27 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

xlsxwriter AttributeError: 'str' object has no attribute 'add_worksheet'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related