act as openpyxl expert developer , I will provide you my needs from openpyxl and you write the code. first request : I have a list called ‘my_list’, remove rows which first cell of the row is ‘None’ and not in my_list

act as openpyxl expert developer , I will provide you my needs from openpyxl and you write the code. first request : I have a list called ‘my_list’, remove rows which first cell of the row is ‘None’ and not in my_list

Comment

0

from openpyxl import load_workbook # Load the workbook and select the sheet wb = load_workbook("your_file.xlsx") ws = wb.active # Define your list my_list = ["value1", "value2", "value3"] # Collect rows to delete rows_to_delete = [] # store the row numbers to delete for row in ws.iter_rows(min_row=1, max_row=ws.max_row, min_col=1, max_col=1): for cell in row: if cell.value is None or cell.value not in my_list: rows_to_delete.append(cell.row) # Delete rows in reverse order so as not to affect subsequent row numbers for row_num in reversed(rows_to_delete): ws.delete_rows(row_num) # Save the modified workbook wb.save("your_modified_file.xlsx")

Popularity 1/10 Helpfulness 1/10 Language python

Source: chat.openai.com

Tags: act cell list openpyxl python request row rows

Share

Link to this answer
Share Copy Link

Contributed on Oct 27 2023

Bewildered Badger

0 Answers  Avg Quality 2/10

---

Closely Related Answers

act as openpyxl expert developer , I will provide you my needs from openpyxl and you write the code. first request : I have a list called ‘my_list’, remove rows which first cell of the row is ‘None’ and not in my_list

Comment

0

from openpyxl import load_workbook # Load the workbook and select the worksheet wb = load_workbook('your_file.xlsx') ws = wb.active # Your list to compare against my_list = ['value1', 'value2', 'value3'] # Collect rows to delete in a list rows_to_delete = [] # Iterate through the worksheet rows (assuming data starts from row 1) for row in ws.iter_rows(min_row=1, max_row=ws.max_row, min_col=1, max_col=1): cell_value = row[0].value if cell_value not in my_list or cell_value is None: rows_to_delete.append(row[0].row) # Sort and reverse the list of rows to delete # This way, we delete from the bottom of the worksheet upwards, avoiding messing up the row numbers rows_to_delete.sort(reverse=True) # Actually delete the rows for row in rows_to_delete: ws.delete_rows(row) # Save the modified workbook wb.save('modified_file.xlsx')

Popularity 1/10 Helpfulness 1/10 Language python

Source: chat.openai.com

Tags: openpyxl python request act row cell rows list

Share

Link to this answer
Share Copy Link

Contributed on Oct 27 2023

Bewildered Badger

0 Answers  Avg Quality 2/10

---