---
title: Conny Söderholm | Excel
description: Excel | Control your Office & Business with Python and Excel
---

[Skip to content](https://www.connysoderholm.com/blog/tag/excel#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)

This is a search field with an auto-suggest feature attached.

- There are no suggestions because the search field is empty.

[1](https://www.connysoderholm.com/blog/tag/excel) [2](https://www.connysoderholm.com/blog/tag/excel/page/2) [Next](https://www.connysoderholm.com/blog/tag/excel/page/2) [Last](https://www.connysoderholm.com/blog/tag/excel/page/2)

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

## [Inserting rows into Excel table without corrupting the table](https://www.connysoderholm.com/blog/inserting-rows-into-excel-table-without-corrupting-the-table)

 August 1, 2023

Inserting rows With OpenPyXL you can insert rows into a worksheet with the worksheet method insert\_r...

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

## [Iterating over tables in an existing Excel workbook with OpenPyXL](https://www.connysoderholm.com/blog/iterating-over-tables-in-an-existing-excel-workbook-with-openpyxl)

 July 31, 2023

There is a way to iterate over Excel tables with OpenPyXL. The functionality has changed in newer ve...

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

## [Transpose or rotate Excel cell data with OpenPyXL](https://www.connysoderholm.com/blog/transpose-or-rotate-excel-cell-data-with-openpyxl)

 December 28, 2019

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

## [How to automatically fill a column with days of the week in Excel](https://www.connysoderholm.com/blog/how-to-automatically-fill-a-column-with-days-of-the-week-in-excel)

 December 27, 2019

To autofill a column with weekdays in Excel we do not need any shortcuts at all.

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

## [How to generate an XML file from Excel with Python](https://www.connysoderholm.com/blog/how-to-generate-an-xml-file-from-excel-with-python)

 December 22, 2019

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

## [Copy Excel data to workbook with Python & OpenPyXL](https://www.connysoderholm.com/blog/copy-data-from-one-excel-workbook-to-a-new-workbook-with-python-openpyxl)

 December 16, 2019

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

## [Save an Excel sheet as pdf with Python and win32](https://www.connysoderholm.com/blog/save-an-excel-sheet-as-pdf-with-python-and-win32)

 December 15, 2019

Saving a finished report or table in Excel is easy. You choose "SaveAs" and save the sheet as Pdf. D...

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

## [Control Excel with Python & OpenPyXL](https://www.connysoderholm.com/blog/control-excel-with-python-openpyxl)

 August 1, 2019

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

[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)

 July 31, 2019

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

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

## [Creating and formatting a chart automatically in Excel with VBA](https://www.connysoderholm.com/blog/creating-and-formatting-a-chart-automatically-excel-vba)

 July 3, 2018

Creating and formatting a chart automatically in Excel with VBA Using Excel involves creating a lot ...

[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")](https://www.connysoderholm.com/)

Copyright © 2026 Conny Söderholm