I'm having great luck having Claude Code generate, read, and update spreadsheets by writing Python code that uses gspread.
It also works fine with Ruby and the "caxlsx" gem. Codex works fine with it as also.
Can it work with comments in sheets as well? When I looked into it, that seemed like a limitation.
It also works fine with Ruby and the "caxlsx" gem. Codex works fine with it as also.