How to Read and Write Excel Files in Python

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Great! Now you know how to get data from Excel sheets, cells, and selection areas.

In the upcoming part, you'll learn how to add, modify, and delete data in Excel files.

Next exercise

17/17 Congratulations

1. Introduction

2. Loading files

3. Getting a list of worksheets

4. Getting a particular worksheet

5. Active worksheet

6. Accessing a particular cell – 1

7. Accessing a particular cell – 2

8. Cell value

9. Other cell properties

10. Getting data from multiple cells

11. Accessing a rectangular selection area – theory

12. Accessing a rectangular selection area – practice

13. Worksheet boundaries

14. The iter_rows() function

15. Summary

16. Exercise 1

17. Congratulations

Great work! That's all we have for this part. You know how to use Python to load worksheets and access data from an xlsx file.

Good job and see you in the next part!

Click Next exercise to continue.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Great job!

Instruction

Exercise

Need assistance?