Advertisement
skip420

Day_Plan

Aug 30th, 2020
282
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.64 KB | None | 0 0
  1. #Skip420_Life_Planner
  2. #
  3. import xlsxwriter
  4.  
  5.  
  6. # Create an new Excel file and add a worksheet.
  7. workbook = xlsxwriter.Workbook('Plan.xlsx')
  8. worksheet = workbook.add_worksheet()
  9.  
  10.  
  11. # Widen the first column to make the text clearer.
  12. worksheet.set_column('A:A', 20)
  13. worksheet.set_column('B:B', 20)
  14. worksheet.set_column('C:C', 20)
  15. worksheet.set_column('D:D', 20)
  16. worksheet.set_column('E:E', 20)
  17. worksheet.set_column('F:F', 20)
  18. worksheet.set_column('G:G', 20)
  19. worksheet.set_column('H:H', 20)
  20.  
  21. # Add a bold format to use to highlight cells.
  22. bold = workbook.add_format({'bold': True })
  23.  
  24. # Write some simple text.
  25. worksheet.write('A1', 'Lessons', bold)
  26. worksheet.write('A2', 'Lesson1')
  27. worksheet.write('A3', 'Lesson2')
  28. worksheet.write('A4', 'Lesson3')
  29. worksheet.write('A5', 'Lesson4')
  30. # Write some simple text.
  31. worksheet.write('A6', 'Lesson5')
  32. worksheet.write('A7', 'Lesson6')
  33. worksheet.write('A8', 'Lesson7')
  34. worksheet.write('A9', 'Lesson8')
  35. worksheet.write('A10', 'Lesson9')
  36.  
  37. # Text with formatting.
  38. worksheet.write('B1', 'Theme', bold)
  39. worksheet.write('B2', ' ', bold)
  40. worksheet.write('B3', ' ', bold)
  41. worksheet.write('B4', ' ', bold)
  42.  
  43. # Text with formatting.
  44. worksheet.write('B5', ' ', bold)
  45. worksheet.write('B6', ' ', bold)
  46. worksheet.write('B7', ' ', bold)
  47. worksheet.write('B8', ' ', bold)
  48. worksheet.write('B9', ' ', bold)
  49.  
  50. # Write some simple text.
  51. worksheet.write('C1', 'Pg.', bold)
  52. worksheet.write('C2', ' ')
  53. worksheet.write('C3', ' ')
  54. worksheet.write('C4', ' ')
  55. worksheet.write('C5', ' ')
  56. worksheet.write('C6', ' ')
  57. worksheet.write('C7', ' ')
  58. worksheet.write('C8', ' ')
  59. worksheet.write('C9', ' ')
  60.  
  61. # Write some simple text.
  62. worksheet.write('D1', 'Vocabulary.' , bold)
  63. worksheet.write('D2', ' ')
  64. worksheet.write('D3', ' ')
  65. worksheet.write('D4', ' ')
  66. worksheet.write('D5', ' ')
  67. worksheet.write('D6', ' ')
  68. worksheet.write('D7', ' ')
  69. worksheet.write('D8', ' ')
  70. worksheet.write('D9', ' ')
  71.  
  72. # Write some simple text.
  73. worksheet.write('E1', 'Sentences' , bold)
  74. worksheet.write('E2', ' ')
  75. worksheet.write('E3', ' ')
  76. worksheet.write('E4', ' ')
  77. # Write some simple text.
  78. worksheet.write('F1', 'Objectives' , bold)
  79. worksheet.write('F2', ' ')
  80. worksheet.write('F3', ' ')
  81. worksheet.write('F4', ' ')
  82. worksheet.write('F5', ' ')
  83. worksheet.write('F6', ' ')
  84. worksheet.write('F7', ' ')
  85. worksheet.write('F8', ' ')
  86. worksheet.write('F9', ' ')
  87.  
  88. # Write some simple text.
  89. worksheet.write('G1', 'Homework' , bold)
  90. worksheet.write('G2', ' ')
  91. worksheet.write('G3', ' ')
  92. worksheet.write('G4', ' ')
  93. worksheet.write('G6', ' ')
  94. worksheet.write('G7', ' ')
  95. worksheet.write('G8', ' ')
  96. worksheet.write('G9', ' ')
  97.  
  98.  
  99.  
  100.  
  101.  
  102.  
  103.  
  104.  
  105. workbook.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement