python reade xlsx 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') #place "r" before the path string to address special character, such as '\'. Don't forget to put the file name at the end of the path + '.xlsx'
print (df)

Example 3: how to write xlsx file in python

import openpyxl

## initializing the xlsx
xlsx = openpyxl.Workbook()

## creating an active sheet to enter data
sheet = xlsx.active

## creating data to append
data = [
         [1, 2, 3],
         [4, 5, 6],
         [7, 8, 9],
         [10, 11, 12]
       ]

## appending row by row to the sheet
for row in data:
    ## append method is used to append the data to a cell
    sheet.append(row)

## saving the xlsx file using 'save' method
xlsx.save('appending.xlsx')

Example 4: import all xlsx file columns names in python jupyter

import pandas as pd

# reading in from external file
movies = pd.read_excel('movies.xls')

# prints first five rows 
movies.head(n=5)
# prints last five rows
movies.tail(n=5)

# for excel files w/ multiple sheets
movies_sheet1 = pd.read_excel(excel_file, sheetname=0)
movies_sheet2 = pd.read_excel(excel_file, sheetname=1)
movies_sheet2 = pd.read_excel(excel_file, sheetname='name of third sheet')

# sort by column
sorted_by_gross = movies.sort_values(['Gross Earnings'], ascending=False)

# exporting to file
movies.to_excel('output.xlsx')