Python | Adjusting rows and columns of an excel file using openpyxl module
Set the height and width of the cells:
Worksheet objects have
column_dimensions attributes that control row heights and column widths. A sheet’s
column_dimensions are dictionary-like values; row_dimensions contains RowDimension objects and column_dimensions contains ColumnDimension objects. In row_dimensions, one can access one of the objects using the number of the row (in this case, 1 or 2). In column_dimensions, one can access one of the objects using the letter of the column (in this case, A or B).
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course
Code #1 : Program to set the dimensions of the cells.
Merging the cells:
A rectangular area of cells can be merged into a single cell with the merge_cells() sheet method. The argument to
merge_cells() is a single string of the top-left and bottom-right cells of the rectangular area to be merged.
Code #2 : Program to merge the cells.
Unmerging the cells:
To unmerge cells, call the unmerge_cells() sheet method.
Code #3 : Program to unmerge the cells.
Setting the font styles of the cells:
To customize font styles in cells, important, import the Font() function from the openpyxl.styles module.
Code #4 : Program to set the font of the text.