How to create a simple spreadsheet using Python Prt 2
Let’s start by creating a simple spreadsheet using Python and the XlsxWriter module
The first step is to import the module:
import xlsxwriter
i n this vidoe i will also discuss, how to write to excel file in python and This video contains:
1. xlsxwriter module in Python
2. How to install xlsxwriter module in python
3. How to use xlsxwriter module in python
4. How to work with excel files in python
5. xlsxwriter using Python
6. How to create an excel file using python
7. How to deal with excel files using Python
8. How to add or write data in excel file using python
9. How to add worksheet in excel file using python
10. How to add columns in excel file using python
11. How to add row in excel file using Python
12. Examples of xlsxwriter module
Python Code used in this turorial:
import xlsxwriter as xw
workbook=xw.Workbook("haidertech.xlsx")
w1=workbook.add_worksheet('HaiderTech')
w2=workbook.add_worksheet('like')
w1.write("A1", "studentName")
w1.write("B1", "Marks")
name=['Ali','Haider','Mehr']
m=['70','80','85']
for i in range(1, len(name)+1):
w1.write(i,0,name[i-1])
w1.write(i, 1, m[i - 1])
w1.write_formula("B5 ","=(B2+B3+B4)")
workbook.close()
HaiderTech Provides all latest technical and other development videos, in these videos especially includes, Kali Linux Learning tutorials, Windows Tutorials, Ethical hacking, Python Programming, C Programming, Huawei HCIA R& S, Cisco networking , CCNA, Mathematics, English grammar, IOT, Raspberry Pi tutorials, Windows servers configuration, Technology news, and motivational Speeches, English and Urdu language