Jacob_DiDiodato

Survey Results Upgrade Utility

Aug 9th, 2017
301
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.41 KB | None | 0 0
  1. import openpyxl
  2.  
  3. def main():
  4.     numberOfNewAttributes = int(raw_input("How many new attributes are there? -> "))
  5.     newAttributes = []
  6.     for i in range(numberOfNewAttributes):
  7.         newAttributes.append(raw_input("What is one of the new attributes? -> "))
  8.    
  9.     try:
  10.         wb = openpyxl.load_workbook('survey_results.xlsx')
  11.     except IOError:
  12.         print "The survey_results.xlsx file does not exist yet. This tool should only be used when upgrading an existing file"
  13.         raise SystemExit
  14.        
  15.     ws = wb.worksheets[0]
  16.     startOn = ws.max_column - 3
  17.     oldData = [[0 for i in range(4)] for j in range(ws.max_row)]
  18.    
  19.     for i in range(startOn, ws.max_column + 1):
  20.         for j in range(1, ws.max_row + 1):
  21.             oldData[j - 1][i - startOn] = ws.cell(row = j, column = i).value
  22.    
  23.     for i in range(startOn, startOn + numberOfNewAttributes):
  24.         ws.cell(row = 1, column = startOn+i-startOn).value = newAttributes[i - startOn]
  25.        
  26.     for i in range(startOn, startOn + numberOfNewAttributes):
  27.         for j in range(2, ws.max_row + 2):
  28.             ws.cell(row = j, column = i).value = ""
  29.        
  30.     for i in range(startOn + numberOfNewAttributes, startOn + numberOfNewAttributes + 4):
  31.         for j in range(1, ws.max_row - 2):
  32.             print "i -> " + str(i - (startOn + numberOfNewAttributes))
  33.             print "j -> " + str(j - 1)
  34.             ws.cell(row = j, column = i).value = oldData[j - 1][i - (startOn + numberOfNewAttributes)]
  35.        
  36.     wb.save("survey_results1.xlsx")
  37.    
  38. if __name__ == "__main__":
  39.     main()
Advertisement
Comments
  • User was banned
Add Comment
Please, Sign In to add comment