how to import xlsx file in python code example
Example 1: python how to read a xlsx file
import pandas as pd
df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx')
print (df)
Example 2: read excel file spyder
import pandas as pd
df = pd.read_excel (r'C:\Users\Ron\Desktop\Product List.xlsx')
print (df)
Example 3: import excel file in python pandas
import pandas as pd
df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx')
Example 4: how to write xlsx file in python
import openpyxl
xlsx = openpyxl.Workbook()
sheet = xlsx.active
data = [
[1, 2, 3],
[4, 5, 6],
[7, 8, 9],
[10, 11, 12]
]
for row in data:
sheet.append(row)
xlsx.save('appending.xlsx')