Talks to Excel through COM automation instead of reading xlsx files directly, which means it works with DRM-protected workbooks and live sessions that openpyxl can't touch. You get 11 tools covering the usual suspects like read_data and write_data, plus Excel-specific stuff like run_macro for VBA execution, get_active_workbook to see what the user has selected, and manage_sheets for inserting rows or copying sheets. The read_data tool handles merged cells properly and can batch-read all sheets with sheet="*". Useful when you're dealing with enterprise Excel files that have protection or when you need to interact with formulas and macros in a running instance. Windows only since it requires Excel's COM interface.
claude mcp add --transport stdio geniuskey-mcp-server-xlwings -- uvx mcp-server-xlwings