Mar-27-2020, 09:19 AM
Hi,
I want to iterate through a number of .xlsx files in a folder and make a simple calculation for each of the rows in each file. I want to subtract a given number ('compensation') from the first cell (index 0). I then want the calculated value ('corrected_pressure') returned in the adjacent cell (index 1) to the right. I want this to occur for the first cell in every row where there is data. I then want the process iterated for all the .xlsx files in a folder.
I have begun below but I can't seem to get line 5 working;
DA
I want to iterate through a number of .xlsx files in a folder and make a simple calculation for each of the rows in each file. I want to subtract a given number ('compensation') from the first cell (index 0). I then want the calculated value ('corrected_pressure') returned in the adjacent cell (index 1) to the right. I want this to occur for the first cell in every row where there is data. I then want the process iterated for all the .xlsx files in a folder.
I have begun below but I can't seem to get line 5 working;
compensation = 1000 import openpyxl as xl import Files for i in Files: if i[-4:] =='xlsx': wb = xl.load_workbook(i) sheet = wb['Content'] for row in range(2, sheet.max_row+1): cell = sheet.cell(row, 2) corrected_pressure = cell.value - compensation corrected_pressure_cell = sheet.cell(row, 4) corrected_pressure_cell.value = corrected_pressure wb.save(i)I get the error;
Error:Traceback (most recent call last):
File "C:/Users/daniel.appleton/PycharmProjects/draft/app.py", line 5, in <module>
for i in Files:
TypeError: 'module' object is not iterable
Any ideas? Should be a simple fixDA