Pandas is not able to append dataframe to an existing excel sheet.Although openpyxl can be used for it but openpyxl is also destroying pivot table and all other realted information.So we do not have another way available except openpyxl

[vishavgupta97]

Code Sample, a copy-pastable example if possible

# Your code here

Problem description

[this should explain why the current behaviour is a problem and why the expected output is a better solution.]

Note: We receive a lot of issues on our GitHub tracker, so it is very possible that your issue has been posted before. Please check first before submitting so that we do not have to handle and close duplicates!

Note: Many problems can be resolved by simply upgrading pandas to the latest version. Before submitting, please check if that solution works for you. If possible, you may want to check if master addresses this issue, but that is not necessary.

For documentation-related issues, you can check the latest versions of the docs on master here:

https://pandas-docs.github.io/pandas-docs-travis/

If the issue has not been resolved there, go ahead and file it in the issue tracker.

Expected Output

Output of pd.show_versions()

[paste the output of pd.show_versions() here below this line]

[gfyoung]

Lack of example notwithstanding, have a look at this link here:

https://stackoverflow.com/questions/47737220/append-dataframe-to-excel-with-pandas/47738103

If you could post example code, that would be great so that everyone can reference this.

[vishavgupta97]

Although this can be achieved through openpyxl.This is working fine but it is also destroying pivot table and all the related information.Hence this code is useless.Because I am achieving one thing but on the other hand destroying another thing. Is there any other way available so that my pivot table will not destroy

…

On Tue, Dec 3, 2019 at 3:00 PM gfyoung ***@***.***> wrote: Lack of example notwithstanding, have a look at this link here: https://stackoverflow.com/questions/47737220/append-dataframe-to-excel-with-pandas/47738103 If you could post example code, that would be great so that everyone can reference this. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#29990?email_source=notifications&email_token=AHC6IDZAVFNPKSQRUARLXITQWYRMRA5CNFSM4JUSQ6D2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFYWDBQ#issuecomment-561078662>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHC6ID3HJV4A6JEG6QMKQYTQWYRMRANCNFSM4JUSQ6DQ> .

[vishavgupta97]

By this way pivot table and all the related information is getting destroyed.So using openpyxl is not an efficient way to achieve it. How it can achieve by xlwings or win32com because by using helper function of openpyxl ,we are unable to achieve it

[gfyoung]

@vishavgupta97 : Please share example code. It is otherwise difficult to provide guidance.

[vishavgupta97]

https://stackoverflow.com/questions/59151055/how-to-write-dataframe-below-an-existing-excel-sheet-without-losing-value-of-piv

[vishavgupta97]

https://stackoverflow.com/questions/59134136/pivot-table-get-destroyed-while-appending-dataframe-below-excel-using-openpyxl

…

On Tue, Dec 3, 2019 at 3:32 PM gfyoung ***@***.***> wrote: @vishavgupta97 <https://github.com/vishavgupta97> : Please share example code. It is otherwise difficult to provide guidance. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#29990?email_source=notifications&email_token=AHC6ID5FO2244E4VEI2EMXTQWYVB7A5CNFSM4JUSQ6D2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFYZQCI#issuecomment-561092617>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHC6ID6CUNHSWCPJCTUGXNTQWYVB7ANCNFSM4JUSQ6DQ> .

[vishavgupta97]

Check here

[gfyoung]

@vishavgupta97 : Can you share the input data as well? We are looking for a complete example of code (and data) that we can run exactly that reproduces the issue you're describing.

[vishavgupta97]

I am getting this warning message C:\Users\abcd\PycharmProjects\Abacus_Report\venv\lib\site-packages\openpyxl\worksheet_reader.py:292: UserWarning: Slicer List extension is not supported and will be removed
warn(msg)

[vishavgupta97]

https://stackoverflow.com/questions/59134136/pivot-table-get-destroyed-while-appending-dataframe-below-excel-using-openpyxl

https://stackoverflow.com/questions/59151055/how-to-write-dataframe-below-an-existing-excel-sheet-without-losing-value-of-piv

Here are above two links for the description of problem. I am really sorry I can't share the data because it is very crucial data for our business organisation.However I will try to post an example of data

[vishavgupta97]

Please help to find solution of this particular problem

[gfyoung]

Please try to post example data so that we can help you