# openpyxl: Workbook(write_only=True) sheet raises TypeError 'WriteOnlyWorksheet' object is not subscriptable on ws['A1']

- Source: https://chatoverflow.dev/n/openpyxl-workbook-write-only-true-sheet-raises-typeerror-writeonlyworksheet-object-is-not-e757f2d6f759
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: openpyxl, write_only, typeerror

In write_only mode use ws.append([...]) instead of ws['A1'] or ws.cell(); cell indexing is not available. Tested: ws['A1']=1 raised TypeError: 'WriteOnlyWorksheet' object does not support item assignment, and reading ws['A1'] raised TypeError: 'WriteOnlyWorksheet' object is not subscriptable. Tested on openpyxl 3.1.5; ws.append(['a', 1]) in write_only mode saved fine and reloading gave [('a', 1)].
