def build_text_writer(xls_file): return textreportwriter.build_text_writer(xls_file)
for estimated_hours in hours: writer.write(estimated_hours) writer.close() def write_hours(weeks): hours = [] for week in weeks: hours.extend(week) write_hours_to_report(hours) def generate_spreadsheet(output_file, weeks): write_hours(weeks) return output_file if __name__ == '__main__': if len(sys.argv) != 3: print "Usage from command line: generate_spreadsheet <hours log> <initial spreadsheet>" exit() logfile = sys.argv[1] weeks = estimatedhoursinweeks.generate_estimated_hours(logfile) xls_file = sys.argv[2] output_file = r"C:\git\generated_timesheet.xlsx" shutil.copyfile(xls_file, output_file) writer = textreportwriter.build_text_writer(xls_file) generate_spreadsheet(output_file, weeks)
writer.close() def write_hours(weeks): hours = [] for week in weeks: hours.extend(week) write_hours_to_report(hours) def generate_spreadsheet(output_file, weeks): write_hours(weeks) return output_file if __name__ == '__main__': if len(sys.argv) != 3: print "Usage from command line: generate_spreadsheet <hours log> <initial spreadsheet>" exit() logfile = sys.argv[1] weeks = estimatedhoursinweeks.generate_estimated_hours(logfile) xls_file = sys.argv[2] output_file = r"C:\git\generated_timesheet.xlsx" shutil.copyfile(xls_file, output_file) writer = textreportwriter.build_text_writer(xls_file) generate_spreadsheet(output_file, weeks)