In [1]:

    

import pandas as pd
import openpyxl


    

In [2]:

    

df = pd.DataFrame([[11, 21, 31], [12, 22, 32], [31, 32, 33]],
                  index=['one', 'two', 'three'], columns=['a', 'b', 'c'])


    

In [3]:

    

print(df)


    

    




        a   b   c
one    11  21  31
two    12  22  32
three  31  32  33

In [4]:

    

df.to_excel('data/dst/pandas_to_excel.xlsx', sheet_name='new_sheet_name')


    

In [5]:

    

df.to_excel('data/dst/pandas_to_excel_no_index_header.xlsx', index=False, header=False)


    

In [6]:

    

df2 = df[['a', 'c']]
print(df2)


    

    




        a   c
one    11  31
two    12  32
three  31  33

In [7]:

    

with pd.ExcelWriter('data/dst/pandas_to_excel_multi.xlsx') as writer:
    df.to_excel(writer, sheet_name='sheet1')
    df2.to_excel(writer, sheet_name='sheet2')


    

In [8]:

    

path = 'data/dst/pandas_to_excel.xlsx'

with pd.ExcelWriter(path) as writer:
    writer.book = openpyxl.load_workbook(path)
    df.to_excel(writer, sheet_name='new_sheet1')
    df2.to_excel(writer, sheet_name='new_sheet2')