AutomateTheBoringStuff.Ch12 package

Subpackages

• AutomateTheBoringStuff.Ch12.Projects package
  • Submodules
  • AutomateTheBoringStuff.Ch12.Projects.P1_multiplicationTable module
  • AutomateTheBoringStuff.Ch12.Projects.P2_blankRowInserter module
  • AutomateTheBoringStuff.Ch12.Projects.P3_cellInverter module
  • AutomateTheBoringStuff.Ch12.Projects.P4_textToExcel module
  • AutomateTheBoringStuff.Ch12.Projects.P5_excelToText module
  • Module contents

Submodules

AutomateTheBoringStuff.Ch12.P1_readingExcel module

Reading Excel

This program uses openpyxl to read Excel documents.

AutomateTheBoringStuff.Ch12.P1_readingExcel.main()

AutomateTheBoringStuff.Ch12.P2_readCensusExcel module

Read census Excel

Tabulates population and number of census tracts for each county.

Note

• The censuspopdata.xlsx workbook can be downloaded from https://nostarch.com/automatestuff/

AutomateTheBoringStuff.Ch12.P2_readCensusExcel.main()

AutomateTheBoringStuff.Ch12.P3_writingExcel module

Writing Excel

This program uses openpyxl to write Excel documents.

AutomateTheBoringStuff.Ch12.P3_writingExcel.main()

AutomateTheBoringStuff.Ch12.P4_updateProduce module

Update produce

Corrects costs in produce sales spreadsheet.

Note

• The produceSales.xlsx workbook can be downloaded from https://nostarch.com/automatestuff/

AutomateTheBoringStuff.Ch12.P4_updateProduce.main()

AutomateTheBoringStuff.Ch12.P5_stylingExcel module

Styling Excel

This program uses openpyxl to format Excel documents

AutomateTheBoringStuff.Ch12.P5_stylingExcel.main()

Module contents