Python script checks XLSX metadata cleanup without altering the workbook

An article on DEV Community explains how to verify that an XLSX metadata cleanup changed only the intended properties. The author describes comparing an original demo workbook with a cleaned copy to confirm that author, company, and custom fields were handled as expected. The method treats XLSX files as ZIP packages and inspects the docProps XML parts. A standard-library Python script compares SHA-256 hashes of the other package parts to detect unexpected changes. The article notes that AI helped draft the text, while the code and results were checked against the demo files.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in