Answers for "how to read xlsx file in python using xlrd"

6

python how to read a xlsx file

import pandas as pd

df = pd.read_excel (r'Path where the Excel file is storedFile name.xlsx')
print (df)
Posted by: Guest on August-14-2020
2

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')
Posted by: Guest on August-29-2020

Code answers related to "how to read xlsx file in python using xlrd"

Python Answers by Framework

Browse Popular Code Answers by Language