#!/usr/bin/env python # Copyright (C) 2005 Kiseliov Roman from xlwt3 import Workbook w = Workbook() ws = w.add_sheet('Hey, Dude') ws.write(0, 0, 1) ws.write(1, 0, 1.23) ws.write(2, 0, 12345678) ws.write(3, 0, 123456.78) ws.write(0, 1, -1) ws.write(1, 1, -1.23) ws.write(2, 1, -12345678) ws.write(3, 1, -123456.78) ws.write(0, 2, -17867868678687.0) ws.write(1, 2, -1.23e-5) ws.write(2, 2, -12345678.90780980) ws.write(3, 2, -123456.78) w.save('numbers.xls')
def SaveFinalResultsExcel(Results): currentRow = 0 wb = Workbook() ws = wb.add_sheet('Testing Results') ws.write(0, 0, 'Files Tested') currentRow += 1 ### Output the number of files ran per machine ### for file in Results._files: machine = file.replace("../Resources/", "") machine = machine.replace(".txt", "") ws.write(currentRow, 0, machine) ws.write(currentRow, 1, str(Results._current_Output[file]['Numb Files'])) currentRow += 1 #### Output the any errors in the standard files #### currentRow += 1 ws.write(currentRow, 0, 'Standard Files Errors') currentRow += 1 for file in Results._files: machine = file.replace("../Resources/", "") machine = machine.replace(".txt", "") for key in Results._standard_Errors[file].keys(): ws.write(currentRow, 0, machine + " - " + key) for col in range(len(Results._standard_Errors[file][key])): ws.write(currentRow, col + 1, Results._standard_Errors[file][key][col]) currentRow += 1 #### Standard Files Missing #### currentRow += 1 ws.write(currentRow, 0, 'Missing Standard Files') currentRow += 1 for file in Results._files: machine = file.replace("../Resources/", "") machine = machine.replace(".txt", "") for key in Results._standard_Missing[file]: ws.write(currentRow, 0, machine) ws.write(currentRow, 1, key) currentRow += 1 #### Output the Error terminations #### currentRow += 1 ws.write(currentRow, 0, 'Error Terminations') currentRow += 1 #Write the Machine names across the top currentCol = 1 for file in Results._files: machine = file.replace("../Resources/", "") machine = machine.replace(".txt", "") ws.write(currentRow, currentCol, machine) currentCol += 1 currentRow += 1 #Loop through the files and output errors for file in Results._files: for key in Results._current_Errors.keys(): ws.write(currentRow, 0, key) for col in range(len(Results._current_Errors[key])): ws.write(currentRow, col + 1, Results._current_Errors[key][col]) currentRow += 1 #### Write out the Variations currentRow += 1 ws.write(currentRow, 0, 'Variations') currentRow += 1 ws.write(currentRow, 0, '- = Nothing Wrong') ws.write(currentRow, 2, 'M = Missing Standard') ws.write(currentRow, 4, 'R = Residual') ws.write(currentRow, 6, 'S = Steps') ws.write(currentRow, 8, 'U = Unknown Issue') currentRow += 1 #Write the Machine names across the top currentCol = 1 for file in Results._files: machine = file.replace("../Resources/", "") machine = machine.replace(".txt", "") ws.write(currentRow, currentCol, machine) currentCol += 1 currentRow += 1 for key in Results._variations.keys(): ws.write(currentRow, 0, key) for col in range(len(Results._variations[key])): ws.write(currentRow, col + 2, Results._variations[key][col]) currentRow += 1 today = datetime.date.today() ExcelFile = '../Results/Results-' + str(today) + '.xls' wb.save(ExcelFile)