AutomateTheBoringStuff.Ch12.Projects package¶
Submodules¶
AutomateTheBoringStuff.Ch12.Projects.P1_multiplicationTable module¶
Multiplication table
Create a program multiplicationTable.py that takes a number N from the command line and creates an N×N multiplication table in an Excel spreadsheet. Row 1 and column A should be used for labels and should be in bold.
AutomateTheBoringStuff.Ch12.Projects.P2_blankRowInserter module¶
Blank row inserter
Create a program blankRowInserter.py that takes two integers and a filename string as command line arguments. Let’s call the first integer N and the second integer M. Starting at row N, the program should insert M blank rows into the spreadsheet.
AutomateTheBoringStuff.Ch12.Projects.P3_cellInverter module¶
Cell inverter
Write a program to invert the row and column of the cells in the spreadsheet. For example, the value at row 5, column 3 will be at row 3, column 5 (and vice versa). This should be done for all cells in the spreadsheet.
Note
Gets full file path from commandline arguments.
AutomateTheBoringStuff.Ch12.Projects.P4_textToExcel module¶
Text to Excel
Write a program to read in the contents of several text files (you can make the text files yourself) and insert those contents into a spreadsheet, with one line of text per row. The lines of the first text file will be in the cells of column A, the lines of the second text file will be in the cells of column B, and so on.
Note
- Default folder is
./p4files/ - Default output file is
textToExcel.xlsx
AutomateTheBoringStuff.Ch12.Projects.P5_excelToText module¶
Excel to text
Write a program that performs the tasks of the previous program in reverse order: The program should open a spreadsheet and write the cells of column A into one text file, the cells of column B into another text file, and so on.
Note
Default output folder is ./p5files/.