How to read an Excel file using python | Read Excel file using openpyxl.
How to read an Excel file using python | Read Excel file using openpyxl.
Prerequisites:
pip install openpyxl
Code:
import openpyxl as op
filepath = "sample.xlsx"
wb = op.load_workbook(filepath)
sh = wb.active
sheet = wb["Sheet1"]
for row in sheet.iter_rows():
for cell in row:
print(cell.value, end=" ")
print()
Next Steps :
---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------
Must Watch Playlists
► 1. Javascript - • Javascript Factory
► 2. Puppetter - • Puppeteer
► 3. Cypress - • Cypress
► 4. Tech works - • Video
► 5. Vbscript Basics To Advanced - • VBScript Part 1 - Features Advantage...
► 6. Jmeter - • Jmeter Tutorials
► 7. Excel - • Videos On Excel
► 8. Appium - • Appium
► 9. Shares - • Shares
► 10. Javascript Interview Questions - • Javascript Interview Questions
► 11. C# Tutorials - • C# Factory
► 12. HTML & CSS - • HTML & CSS
► 13. Browser Console - • Browser Console
► 14. JSON - • Videos on Json
► 15. Specflow - • Specflow Tutorials
► 16. MongoDB - • MongoDB Tutorials
► 17. Postman - • Postman
► 18. Python - • Python
► 19. Typescript - • Typescript & Node Imp Questions
► 20. Node - • Node
► 21. Java Selenium Interview Questions: • Java and Selenium Imp
► 22. Real Time Interview Q & A: • Real Time Interview Questions
► 23.SOAP UI Tutorials : • SOAP UI
► 24. WebDriverIO : • Getting Started with WebdriverIO | In...
► 25. Jenkins : • How to download and install Jenkins o...
► 26. Cloud and CyberSecurity : • What is Windows Sandbox? How to enabl...
► 27. GitHub : • How to upload Files / Folders in GitH...
► 28. Videos on Ubuntu : • Videos on Ubuntu / Linux
---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------
#openpyxl
#python
#excel
Watch video How to read an Excel file using python | Read Excel file using openpyxl. online without registration, duration online in high quality. This video was added by user Azhar Techno Coder 16 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 140 once and liked it 34 people.