Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Skip420_Life_Planner
- #
- import xlsxwriter
- # Create an new Excel file and add a worksheet.
- workbook = xlsxwriter.Workbook('Plan.xlsx')
- worksheet = workbook.add_worksheet()
- # Widen the first column to make the text clearer.
- worksheet.set_column('A:A', 20)
- worksheet.set_column('B:B', 20)
- worksheet.set_column('C:C', 20)
- worksheet.set_column('D:D', 20)
- worksheet.set_column('E:E', 20)
- worksheet.set_column('F:F', 20)
- worksheet.set_column('G:G', 20)
- worksheet.set_column('H:H', 20)
- # Add a bold format to use to highlight cells.
- bold = workbook.add_format({'bold': True })
- # Write some simple text.
- worksheet.write('A1', 'Lessons', bold)
- worksheet.write('A2', 'Lesson1')
- worksheet.write('A3', 'Lesson2')
- worksheet.write('A4', 'Lesson3')
- worksheet.write('A5', 'Lesson4')
- # Write some simple text.
- worksheet.write('A6', 'Lesson5')
- worksheet.write('A7', 'Lesson6')
- worksheet.write('A8', 'Lesson7')
- worksheet.write('A9', 'Lesson8')
- worksheet.write('A10', 'Lesson9')
- # Text with formatting.
- worksheet.write('B1', 'Theme', bold)
- worksheet.write('B2', ' ', bold)
- worksheet.write('B3', ' ', bold)
- worksheet.write('B4', ' ', bold)
- # Text with formatting.
- worksheet.write('B5', ' ', bold)
- worksheet.write('B6', ' ', bold)
- worksheet.write('B7', ' ', bold)
- worksheet.write('B8', ' ', bold)
- worksheet.write('B9', ' ', bold)
- # Write some simple text.
- worksheet.write('C1', 'Pg.', bold)
- worksheet.write('C2', ' ')
- worksheet.write('C3', ' ')
- worksheet.write('C4', ' ')
- worksheet.write('C5', ' ')
- worksheet.write('C6', ' ')
- worksheet.write('C7', ' ')
- worksheet.write('C8', ' ')
- worksheet.write('C9', ' ')
- # Write some simple text.
- worksheet.write('D1', 'Vocabulary.' , bold)
- worksheet.write('D2', ' ')
- worksheet.write('D3', ' ')
- worksheet.write('D4', ' ')
- worksheet.write('D5', ' ')
- worksheet.write('D6', ' ')
- worksheet.write('D7', ' ')
- worksheet.write('D8', ' ')
- worksheet.write('D9', ' ')
- # Write some simple text.
- worksheet.write('E1', 'Sentences' , bold)
- worksheet.write('E2', ' ')
- worksheet.write('E3', ' ')
- worksheet.write('E4', ' ')
- # Write some simple text.
- worksheet.write('F1', 'Objectives' , bold)
- worksheet.write('F2', ' ')
- worksheet.write('F3', ' ')
- worksheet.write('F4', ' ')
- worksheet.write('F5', ' ')
- worksheet.write('F6', ' ')
- worksheet.write('F7', ' ')
- worksheet.write('F8', ' ')
- worksheet.write('F9', ' ')
- # Write some simple text.
- worksheet.write('G1', 'Homework' , bold)
- worksheet.write('G2', ' ')
- worksheet.write('G3', ' ')
- worksheet.write('G4', ' ')
- worksheet.write('G6', ' ')
- worksheet.write('G7', ' ')
- worksheet.write('G8', ' ')
- worksheet.write('G9', ' ')
- workbook.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement