How to save excel of particular sheets into another excel sheet python

user_15299206 0
Viewed 42

I have an excel

  • There are 25 sheet in the excel
  • I need to extract sheet starting with TXN into another separate individualexcel sheets

I am doing with below code which is not proper way

import pandas as pd
df = pd.read_excel('TXN-data.xlsx', sheet_name='TXN-20210101')
df1 = pd.read_excel('TXN-data.xlsx',sheet_name='TXN-20210102')

After that i am saving

df.to_excel('TXN-20210101.xlsx')
df1.to_excel('TXN-20210102.xlsx')
excel python
1 Answers

Try:

import pandas as pd

df = pd.ExcelFile('TXN-data.xlsx')
sheets = df.sheet_names
sheets_selected = [x for x in sheets if x[0:3]=="TXN"]

for sheet in sheets_selected:
    df_sheet = pd.read_excel(df, sheet)
    df_sheet.to_excel(sheet + ".xlsx")
user_160384590
Related