How to Wrap Text in Excel Using Python win32com

Question

I've been pouring over the web these last couple days to try to find a text wrapping method using win32com.client with python 2.7.2 (text wrapping as in wrapping the text in a single cell like you would to when you right click and do it in the Format Cells dialogue box).

Something like:

sheet.Cell(1,1).Font.WrapText = True

I've found a thread doing some finda nd replace stuff that includes wrapping I think here but I believe this is for word wrapping in MS Word.

I tried the methiod used here as well, but I'm getting an error indicating WrapText does not exist. I've just doing a quick report and exporting the results to an excel spreadsheet and the word wrapping would bea nice feature to have!

Oliver · Accepted Answer · 2014-03-13 18:18:08Z

1

As per http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.range.wraptext.aspx you would use

sheet.Cell(1,1).WrapText = True

answered Mar 13, 2014 at 18:18

Oliver

30k12 gold badges81 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Wrap Text in Excel Using Python win32com

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related