Question
can someone help me indent this python code correctly so I can run it? here's the code: import xlwt from xlwt import Workbook from decimal
can someone help me indent this python code correctly so I can run it?
here's the code:
import xlwt from xlwt import Workbook from decimal import *
#create a workbook wb = Workbook() #create a sheet sheet = wb.add_sheet('Sheet')
#percentages list percentages = [23.6, 38.2, 50, 61.8, 78.6, 113, 123.6, 138.2, 161.8] #add first row for i in range(len(percentages)): sheet.write(0,i+1,str(percentages[i])+'%')
#user input n = int(input('Enter number of elements: ')) #second row starts from index 1 row=1 print('Enter numbers: ') for i in range(n): #User input val = float(input()) #Add entered value to first column of the row sheet.write(row,0,str(val)) #calculate each percentage prev = "" for j in range(len(percentages)): result = (percentages[j]/100)*val #write result to sheet by rounding to nearest whole number using quantize method current = str(Decimal(result).quantize(Decimal("1"))) if(prev != current): sheet.write(row,j+1,current) prev = current #increment the row by 1 row+=1 #save Workbook as xls` wb.save('percentages.xls')
thanks to anyone who helped!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started