Hi ,

Am a beginner in python , you could consider this as my 1st project.

So at work we consolidate excel sheets a lot , and as a temp i would be tasked to it always!

Copying and pasting over and over again got to me think if it can be automated with programming . Looks like there is , but i wished to do it with python since i am learning it.

so i tried and got till here searching the web.

#Program to combine excel sheets from same excel workbook.

import pandas pas pd

import numpy as np

excel_file_1 = ‘workbook1.xlsx’

df_Day_one = pd.read_excel(excel_file_1, sheet_name=‘Sheet1’)

df_Day_2 = pd.read_excel(excel_file_1, sheet_name=‘Sheet2’)

df_all = pd.concat([df_Day_one,df_Day_2])

df_all.to_excel(“two_days_output.xlsx”)

This is working and am happy and proud about it even tho it took me 3 days to get this code working… had problems with the location… of the excel sheet .

But sadly i need to do it for 30 days so yes 30 sheets typing ""sheet_name = “” for every sheet, it just beats the whole objective of “less work”.

So searched a bit more and found that “” pd.read_excel(excel_file,sheet_name=None) “” would read all the data ? so i tried it like this and…

import pandas as pd

import numpy as np

excel_file=‘FSL Dump for August.xlsx’

df_alldays = pd.read_excel(excel_file,sheet_name=None)

df_alldays.to_excel(‘16_days_output.xlsx’)

This is the error am getting in shell

File “<pyshell#50>”, line 1, in

df_alldays.to_excel(“16_days_output.xlsx”)

AttributeError: ‘dict’ object has no attribute ‘to_excel’

And this is the part where am stuck at , tried searching the web and still havent got to anything . Need help with this .

Have a good day