adding datetime into excel sheets using xls

Question

I was using the library datetime and xlwt i wanted to create a sheet name and i want to add the date and time is has been created so i used the following lines.

sheet1 = wb.add_sheet('applied job list'+datetime.now())

it throwed an error saying

 File "d:/PROJECTS/job_apply_bot/aasda.py", line 5, in <module>
    sheet1 = wb.add_sheet('applied job list'+datetime.now())
TypeError: can only concatenate str (not "datetime.datetime") to str

idk what i am missing can someone help

Harvey Jones · Accepted Answer · 2021-08-21 12:47:05Z

1

Looks like your returning an object with datetime.now() try converting it to a string first like this,

sheet1 = wb.add_sheet('applied job list' + str(datetime.now()))

answered Aug 21, 2021 at 12:47

Harvey Jones

264 bronze badges

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

Collectives™ on Stack Overflow

adding datetime into excel sheets using xls

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