Python Example Program - Openpyxl

#python #openpyxl #tutorial

If you like this video, do not forget to like and subscribe to my channel!!.
so you will not miss any of my next video's
https://bit.ly/2rrmKx5

Follow me on Instagram:

www.instagram.com/Sequenze2
DO NOT CLICK!! https://bit.ly/2rrmKx5

full script:

# This script uses the Openpyxl package to create and write to an Excel file

#before you begin, install openpyxl using the following command
# pip install openpyxl

#begin with importing the openpyxl package
from openpyxl import Workbook

#create a workbook
wb = Workbook()

#select active worksheet from workbook
ws = wb.active

#change the title of the sheet
ws.title = "SheetName"

# for reference I create a list of items
Numberlist = ["one","two","three","four","five","six","seven","eight","nine","ten"]

#use a for loop to put the values and the corresponding names in the rows
for a in range(1,11):
ws.cell(a,1,a) # write to rows 1-10 from column 1 (A) the value 1-10
ws.cell(a,2,Numberlist[a-1]) # write to rows 1-10 from column 2 (B)the corresponding names

#use another for loop to check the result
for a in range(1,11):
c = ws.cell(a,2) # select the cell to c
print("cell B"+ str(a)+ "= "+ c.value) #get the value from the selected cell

#save the workbook
wb.save("D:\\Py\\Tutorials\\Numbers.xlsx")
# you can now save and run the Python script