Answers for "import excel sheet data into another using python"

import excel file to python

import pandas as pd

df = pd.read_excel (r'Path where the Excel file is storedFile name.xlsx', sheet_name='your Excel sheet name')
print (df)

Posted by: Guest on May-12-2020

python import specific excel sheet

data = pd.read_excel('C:/Users/user/Downloads/data.xlsx', sheet_name='2016')

Posted by: Guest on August-18-2021

Code answers related to "import excel sheet data into another using python"