chronossc/openpyxl

open and save excel file(.xlxs) removing data validation (type list )

Closed this issue · 0 comments

When I open an excel file with write mode and save . It is removing the existing data validation (Type list data validation) from the file and I am getting warning Data Validation extension is not supported and will be removed warn(msg). Actually I wanted to append new row to the file as a list. I don't want to change or add new validation to existing file. Other than type list data validation every other validations it maintains after save