excel

Use openpyxl to load the workbook, then apply edits such as updating cells, find-replace, or adding rows. This Skill wraps those operations in a batch editor so multiple changes apply in one command after an initial inspection step.

Use the batch action with a JSON array of operations, such as update-cells with cell-value pairs, find-replace, and add-rows. Batch editing is preferred over single-action calls because it applies all changes in one pass.

This error usually means the file is DRM-protected with IRM, which wraps the XLSX in an OLE2 container with a D0 CF header. Check the file header bytes first, then strip DRM via the COM-based handler before opening with openpyxl.

No, openpyxl does not evaluate formulas. Inspection shows the formula text like =SUM(A1:A10), and computed values are only available if Excel last saved the file with cached values.

No, the DRM strip and re-apply handler requires Office COM automation, which is Windows-only. On macOS, protected files cannot be edited and the user should be warned that a Windows machine is required.

Running find-replace without a sheet parameter searches all sheets, which can silently change data in unexpected places. Always scope the operation to a specific sheet when the search term may appear in multiple locations.