how to write in excel using python

Introduction to Python

Collection in Python

Object Oriented python

Python With MYSQL And Excel

Python GUI

Programs in Python

Working With Excel Sheet Using Python

How to read data from excel spreadsheet using Python:

Using python we can read the data from excel sheet. For this we need to install module named xlrd using pip

After Installing the xlrd using pip installer by using the following code we can read the

data from excel sheet

xlrd is a python library to work with python and excel it must be installed before following

code

import xlrd
filePath=("C://Users//Sharp//Desktop//Book1.xls")
workbook=xlrd.open_workbook(filePath)
sheet=workbook.sheet_by_index(0)
for i in range(sheet.nrows):
 for j in range(sheet.ncols):
  print(sheet.cell_value(i,j),end=" ")
 print()

Output: As Per Excel Sheet Data For All rows and columns

How to Write data in excel spreadsheet using Python:

Using python we can write the data into excel sheet. For this we need to install module named xlwt using pip

xlwt is a python library to write with in excel using python it must be installed before

using following code

import xlwt
from xlwt import Workbook
wb=Workbook()
sheet1=workbook.add_sheet('Sheet 1')
sheet1.write(0,0,"Roll No")
sheet1.write(0,0,"Name")
sheet1.write(1,0,"4390")
sheet1.write(1,1,"John")
wb.save("C://Users//Sharp//Desktop//WriteExl.xls")

Output: Excel Sheet with one heading record and one data record created on the given path

How to Edit in excel spreadsheet using Python:

Using python we can edit excel sheet. For this we need to install module named xlrd & xlutils using pip

xlrd & xlutils is a python library to read and edit in excel using python it must be

installed before using following code

from xlrd import open_workbook
from xlutils.copy import copy
rb=open_workbook("C://Users//Sharp//Desktop//WriteExl.xls")
wb=copy(rb)
sheet=wb.get_sheet(0)
sheet.write(0,0,"RegNo")
wb.save("C://Users//Sharp//Desktop//WriteExl.xls")

Output: In The above file Heading Roll No is being changed from RollNo to RegNo

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

Working With Excel Sheet Using Python

How to read data from excel spreadsheet using Python:

How to Write data in excel spreadsheet using Python:

How to Edit in excel spreadsheet using Python:

Video/ C Introduction