Good afternoon :) I am new at python and I would like to desperately ask for your help, currently I was assigned a task that has the following requirements : #The script must read,run,extract relevant updated data weekly from a folder that contains multiple excel files. #The updated data is added on an excel sheet as it follows KPI/SW/WEEK (to be able to check the improvement of KPI's per week #Requirements are : -to extract and do a graphical representation of the KPI1/SWC/WEEK #-to extract the KPI 1and 2 + the Average KPI of 1and 2 and to do a graphical representation /SWC/WEEK #-the graphs should show the results in % #-from master excel list (the list that need update every week) we extract from column G 2 data /hcp/swc/week and do a graphically representation. #-all the new RN's will be read and have the exact data extracted to be able to updated data and added to the master excel sheet. My code is as it follows: from openpyxl import load_workbook data_file = 'C:\\Users\IGal\\Desktop\\OneDrive_1_6-7-2022.xlsx' # Load the entire workbook. wb = load_workbook(data_file) # Load one worksheet. ws = wb['Data'] all_columns = list(ws.columns) all_rows = list(ws.rows) #print(f"Found {len(all_columns)} columns of data.") #print(f"Found {len(all_rows)} rows of data") #print("\nFirst columns of data:") #print("\nFirst rows of data:") for row in all_columns[:0]: for columns in all_rows[:0]: #print(columns) #print(rows) # Load the entire workbook. wb = load_workbook(data_file) # Load one worksheet. ws = wb['C:\\Users\\IGal\\Desktop\\SWKPIsCW.xlsx'] all_rows = list(ws.rows) for cell in all_rows[0]: print(cell.value) # Pull information from specific cells. for row in all_rows[1:455]: state = row[0].value percent_cw = row[2].value #percent_cw = row[4].value print(f"{state}") print(f" {percent_cw}% of cw kpi") print(f" {percent_cw}% of cw kpi") # Pull information from specific cells. for row in all_rows[1:455]: SWC = row[1:455].value percent_SWC = int(round(row[1:455].value, 2) * 100) percent_cw = int(round(row[1:455].value, 2) * 100) print(SWC) What I have tried: <pre>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)