O'Reilly logo

Automate it! - Recipes to upskill your business by Chetan Giridhar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Working with CSV and Excel Worksheets

Imagine a world where your important documents were stored in files and managed on work desks. Thanks to the advent of computers and software such as Excel sheets we can manage our data in an organized way. In fact, you can even manage worksheets in an automated way, and that too with Python.

In this chapter, we will cover the following recipes:

  • Reading CSV files with reader objects
  • Writing data into CSV files
  • Developing your own CSV dialects
  • Managing employee information in an automated way
  • Reading Excel sheets
  • Writing data into worksheets
  • Formatting Excel cells
  • Playing with Excel formulae
  • Building charts within Excel sheets
  • Automating the comparison of company financials

Introduction

Until computers became ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required