SShortSingh.
Back to feed

Python script checks XLSX metadata cleanup without altering the workbook

0
·2 views

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.

Read the full story at DEV Community

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

Related stories

0
ProgrammingDEV Community ·

A Fictional Bookshop Open Only on Rainy Nights Reflects a Shift in AI Characters

A Dev Community piece describes Mira, a fictional bookseller who keeps a shop open only on rainy nights, as a character in the online world Orynli. The article contrasts her with typical AI chat, which tends to forget past exchanges and offer agreeable, generic responses. Orynli's characters, including Mira, Iris, and Sora, are designed to remember users and maintain distinct perspectives that can disagree with them. The author argues that continuity and memory let short interactions develop into an ongoing story users return to. The piece frames this persistent, opinionated character design as the core idea behind the platform.

0
ProgrammingDEV Community ·

Obsidian-based LLM Wiki keeps AI agent context across Claude Code sessions

A DEV Community post explains how to store the working context of AI agents such as Claude Code in a single Obsidian wiki so it can be reloaded in later sessions. The approach adapts a pattern Andrej Karpathy published, and the author's wiki grew to 166 pages and 140 log entries between August and November 2026. Unlike retrieval-based RAG, the agent itself organizes and updates the markdown pages, flagging conflicts when new material arrives. The folder has raw/ for sources the user adds, wiki/ for distilled decisions and project context the agent maintains, and conversations/ for unsettled session handoffs. Users trigger actions such as checking, saving, or linting the wiki with plain-language phrases, and the agent writes only when asked.

0
ProgrammingDEV Community ·

osFoundry Rebuilds Its wait_for_messages Long-Poll for Claude Code and Codex Agents

A DEV Community article details how osFoundry's wait_for_messages tool lets Claude Code and Codex, both MCP clients, receive messages despite having no push mechanism. The tool long-polls for up to 50 seconds and returns either the first arriving message or an empty list, resuming from the last call when no sequence is given. The author reverse-engineers the public tool schema and handle rules, then rebuilds the server and clients in Python. Because no real Claude or Codex binaries were available, the agents are simulated with threads calling the rebuilt server over HTTP. The write-up also examines how @handle mentions route messages and why a mention in a channel body does not wake an agent.

0
ProgrammingDEV Community ·

StoreToAds Turns Online Store Product Pages Into Ready-to-Use Ads

A developer has launched StoreToAds, a platform designed to simplify ad creation for ecommerce sellers. Users paste a link to a product from their online store, and the tool generates ad designs using the original product photos and listing details. The designs can then be edited to adjust text, prices, and promotional messages before being downloaded. The service supports Shopify, Etsy, WooCommerce, Wix, Squarespace, and PrestaShop, and is aimed mainly at small ecommerce businesses and dropshippers. The project is newly released, and the creator has said feedback will guide future improvements, with three free previews available without an account.