{"id":41,"date":"2026-02-04T18:44:53","date_gmt":"2026-02-04T10:44:53","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=41"},"modified":"2026-01-17T05:21:57","modified_gmt":"2026-01-17T05:21:57","slug":"how-to-select-and-clear-cells-ranges-using-xlwings","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-select-and-clear-cells-ranges-using-xlwings\/","title":{"rendered":"How To Select and Clear Cells (Ranges) Using xlwings?"},"content":{"rendered":"

Method<\/h2>\n

Select<\/span><\/h3>\n

#xlwings<\/p>\n

sht.range(‘A1:B10’).select()<\/p>\n

\u00a0<\/p>\n

#xlwings API<\/p>\n

#sht.api.Range(‘A1:B10’).Select()<\/p>\n

#sht.api.Range(‘A1:B10’).Activate()<\/p>\n

\u00a0<\/p>\n

Select non-contiguous cell ranges<\/span><\/h3>\n

#xlwings<\/p>\n

#sht.range(‘A1:A5,C3,E1:E5’).select()<\/p>\n

\u00a0<\/p>\n

#xlwings API<\/p>\n

#sht.api.Range(‘A1:A5,C3,E1:E5’).Activate()<\/p>\n

#sht.api.Range(‘A1:A5,C3,E1:E5’).Select()<\/p>\n

\u00a0<\/p>\n

Clear all content from a cell range<\/span><\/h3>\n

#xlwings<\/p>\n

#sht.range(‘B<\/span>2<\/span>:<\/span>D<\/span>5′).clear()<\/span><\/p>\n

\u00a0<\/p>\n

#xlwings API<\/p>\n

#sht.api.Range(‘B<\/span>2<\/span>:<\/span>D<\/span>5′).Clear()<\/span><\/p>\n

\u00a0<\/p>\n

Clear text content of a cell<\/span><\/h3>\n

#xlwings<\/p>\n

#sht.range(‘B<\/span>2<\/span>:<\/span>D<\/span>5′).clear_contents()<\/span><\/p>\n

\u00a0<\/p>\n

#xlwings API<\/p>\n

#sht.api.Range(‘B<\/span>2<\/span>:<\/span>D<\/span>5′).ClearContents()<\/span><\/p>\n

\u00a0<\/p>\n

Clear cell comments<\/span><\/h3>\n

#xlwings API<\/p>\n

#sht.api.Range(‘B<\/span>2<\/span>:<\/span>D<\/span>5′).ClearComments()<\/span><\/p>\n

\u00a0<\/p>\n

Clear cell formatting<\/span><\/h3>\n

#xlwings API<\/p>\n

#sht.api.Range(‘B<\/span>2<\/span>:<\/span>D<\/span>5′).ClearFormats()<\/span><\/p>\n

Sample Code<\/h2>\n\n\n
#Select and clear cells \n\nimport xlwings as xw  #Import the xlwings package\n\napp=xw.App()\nbk=app.books.open('special.xlsx')\nsht=bk.sheets.active  #Get the active worksheet\n\n#Select\n#xlwings\n#sht.range('A1:B10').select()\n\n#xlwings API\n#sht.api.Range('A1:B10').Select()\n#sht.api.Range('A1:B10').Activate()\n\n#Select non-contiguous cell ranges\n#xlwings\n#sht.range('A1:A5,C3,E1:E5').select()\n\n#xlwings API\n#sht.api.Range('A1:A5,C3,E1:E5').Activate()\n#sht.api.Range('A1:A5,C3,E1:E5').Select()\n\n#Clear all content from a cell range\n#xlwings\n#sht.range('B2:D5').clear()\n\n#xlwings API\nsht.api.Range('B2:D5').Clear()\n\n#Clear text content of a cell\n#xlwings\n#sht.range('B2:D5').clear_contents()\n\n#xlwings API\n#sht.api.Range('B2:D5').ClearContents()\n\n#Clear cell comments\n#xlwings API\n#sht.api.Range('B2:D5').ClearComments()\n\n#Clear cell formatting\n#xlwings API\n#sht.api.Range('B2:D5').ClearFormats()\n\n#bk.close()\n#app.kill()<\/code><\/pre>\n\n\n\n
\"Select<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
Method<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-41","post","type-post","status-publish","format-standard","hentry","category-xlwings-cell-range"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/41","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=41"}],"version-history":[{"count":3,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":315,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/41\/revisions\/315"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}