Python DataFrame ExcelWriter, returns an error

Question

I am trying to over-write specific tabs in an excel file (leaving the rest intact). I am trying to copy synatx from the documentation but I get an error.

with ExcelWriter('C:\\Users\Tiki\Desktop\work\VFT Technicals\Production2\dashboard_v2.xlsx') as writer: 
    output_rsi.to_excel(writer,sheet_name='rsi')

This returns the error:

NameError: name 'ExcelWriter' is not defined

Hoping for some advice, I am very much a beginner at coding.

Thanks in advance.

Jaydeep Devda · Accepted Answer · 2020-07-01 04:03:58Z

4

your script is not recognize 'ExcelWriter' keyword. it is part of python's pandas library. you should write below things to work it out.

please try :

import pandas as pd and use

with pd.ExcelWriter('C:\\Users\Tiki\Desktop\work\VFT Technicals\Production2\dashboard_v2.xlsx') as writer: 
    output_rsi.to_excel(writer,sheet_name='rsi')

or import pandas.ExcelWriter as ExcelWriter

answered Jul 1, 2020 at 4:03

Jaydeep Devda

7354 silver badges20 bronze badges

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

1 Comment

Tikhon Over a year ago

Dead on! It was a typo I was making. Thank you very much.

Collectives™ on Stack Overflow

Python DataFrame ExcelWriter, returns an error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related