---
title: Control Excel with Python & OpenPyXL
description: Control Excel with Python & OpenPyXL
---

[Skip to content](https://www.connysoderholm.com/blog/control-excel-with-python-openpyxl#main-content)

![Conny-Söderholm](https://www.connysoderholm.com/hubfs/Conny-S%C3%B6derholm.svg)

- [Home](https://www.connysoderholm.com/)
- [Courses](https://www.connysoderholm.com/courses)
- [Articles](https://www.connysoderholm.com/blog)
- [Contact Me](https://www.connysoderholm.com/contact-me)

Open main navigation

Close main navigation

- [Home](https://www.connysoderholm.com/)
- [Courses](https://www.connysoderholm.com/courses)
- [Articles](https://www.connysoderholm.com/blog)
- [Contact Me](https://www.connysoderholm.com/contact-me)

 August 1, 2019

# Control Excel with Python & OpenPyXL

![Picture of Conny Söderholm](https://app.hubspot.com/settings/avatar/c60eb763b898c1f4c2e54f9401f3aef1) [Conny Söderholm](https://www.connysoderholm.com/blog/author/conny-soderholm)

Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://www.connysoderholm.com/blog/control-excel-with-python-openpyxl) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://www.connysoderholm.com/blog/control-excel-with-python-openpyxl) [Twitter icon](https://twitter.com/intent/tweet?url=https://www.connysoderholm.com/blog/control-excel-with-python-openpyxl) [pinterest-p icon](http://pinterest.com/pin/create/link/?url=https://www.connysoderholm.com/blog/control-excel-with-python-openpyxl) [envelope icon](mailto:?body=https://www.connysoderholm.com/blog/control-excel-with-python-openpyxl)

**I have finally published my first course, Control Excel with Python & OpenPyXL!**

The course covers the ins and outs of how to control and automate Excel with the OpenPyXL library.

I am offering this course for a discount for you who are reading this post.

Check out the course on [Udemy!](https://www.udemy.com/course/control-excel-with-python-openpyxl/?referralCode=E855FEBD01977693E6FA)

[Python](https://www.connysoderholm.com/blog/tag/python), [openpyxl](https://www.connysoderholm.com/blog/tag/openpyxl), [Excel](https://www.connysoderholm.com/blog/tag/excel)

## Related posts

[Excel](https://www.connysoderholm.com/blog/tag/excel)

## [Mapping and importing/exporting an XML schema to Excel](https://www.connysoderholm.com/blog/mapping-and-importing-exporting-an-xml-schema-to-excel)

![Picture of Conny Söderholm](https://app.hubspot.com/settings/avatar/c60eb763b898c1f4c2e54f9401f3aef1) [Conny Söderholm](https://www.connysoderholm.com/blog/author/conny-soderholm) 

 July 31, 2019

Here is a short video on how to map XML schemas to Excel.

[Read more](https://www.connysoderholm.com/blog/mapping-and-importing-exporting-an-xml-schema-to-excel)

[Excel](https://www.connysoderholm.com/blog/tag/excel)

## [How to Reference cells and sheets indirectly in Excel 2016](https://www.connysoderholm.com/blog/reference-cells-indirectly-excel)

![Picture of Conny Söderholm](https://app.hubspot.com/settings/avatar/c60eb763b898c1f4c2e54f9401f3aef1) [Conny Söderholm](https://www.connysoderholm.com/blog/author/conny-soderholm) 

 June 8, 2018

You have one Excel workbook. You have several sheets in the workbook. You have one summary table on...

[Read more](https://www.connysoderholm.com/blog/reference-cells-indirectly-excel)

[![](https://www.connysoderholm.com/hs-fs/hubfs/Imported_Blog_Media/28269236-99e7ea34-6b01-11e7-8ff9-21285576122f.png?height=200&name=28269236-99e7ea34-6b01-11e7-8ff9-21285576122f.png)](https://www.connysoderholm.com/blog/carnac-keypress-capture-software)

## [Carnac, Keypress capture software](https://www.connysoderholm.com/blog/carnac-keypress-capture-software)

![Picture of Conny Söderholm](https://app.hubspot.com/settings/avatar/c60eb763b898c1f4c2e54f9401f3aef1) [Conny Söderholm](https://www.connysoderholm.com/blog/author/conny-soderholm) 

 August 27, 2019

For anybody searching for a great Keypress capture software, that also is free, check out Carnac

[Read more](https://www.connysoderholm.com/blog/carnac-keypress-capture-software)

[linkedin-in icon](https://www.linkedin.com/in/connysoderholm) [Follow us on Facebook](https://www.youtube.com/@connysoderholm1473)

- [Home](https://www.connysoderholm.com)
- [Courses](https://www.connysoderholm.com/courses)
- [Articles](https://www.connysoderholm.com/blog)
- [Contact Me](https://www.connysoderholm.com/contact-me)
- [Privacy Policy](https://www.connysoderholm.com/privacy-policy)
- [Disclaimer](https://www.connysoderholm.com/disclaimer)

---

[![Conny Söderholm Logo](https://www.connysoderholm.com/hubfs/Conny-S%C3%B6derholm.svg "Conny Söderholm Logo")](http://Conny%20Söderholm)

Copyright © 2026 Conny Söderholm

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Conny Söderholm",
    "url" : "https://www.connysoderholm.com/blog/author/conny-soderholm"
  },
  "dateModified" : "2023-07-31T15:18:37.156Z",
  "datePublished" : "2019-08-01T18:33:55.000Z",
  "headline" : "Control Excel with Python & OpenPyXL",
  "mainEntityOfPage" : {
    "@id" : "https://www.connysoderholm.com/blog/control-excel-with-python-openpyxl",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.connysoderholm.com/hubfs/Conny-S%C3%B6derholm.svg"
    },
    "name" : "Conny Söderholm"
  }
}
```