OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

How to set the default row and column height in openpyxl?

  • Thread starter Thread starter 00noob
  • Start date Start date
0

00noob

Guest
I would like to change the row and column height using Openpyxl. I can change the specific row and height like this:

Code:
import openpyxl

wb = openpyxl.Workbook()
ws = wb.active
ws.row_dimensions[1].height = 10

But I want to change the default height and width of rows and column so that I don't have to do this for each row and each column.

Is it possible to do this?
<p>I would like to change the row and column height using Openpyxl.
I can change the specific row and height like this:</p>
<pre class="lang-py prettyprint-override"><code>import openpyxl

wb = openpyxl.Workbook()
ws = wb.active
ws.row_dimensions[1].height = 10
</code></pre>
<p>But I want to change the default height and width of rows and column so that I don't have to do this for each row and each column.</p>
<p>Is it possible to do this?</p>
 
Top