Below is the implementation:<\/strong><\/p>\n# Import openpyxl module using the import keyword\r\nimport openpyxl\r\n\r\n# Create a new blank Workbook object by calling a Workbook() function of openpyxl\r\n# module and store it in a variable\r\nworkbookObj = openpyxl.Workbook()\r\n\r\n# Apply active attribute on the above Workbook object to get the workbook active sheet\r\n# and store it in another variable.\r\nworksheet = workbookObj.active\r\n\r\n# Write some random data to the specified cell by using row, column numbers and value attribute.\r\nworksheet.cell(row = 1, column = 1).value = ' Welcome '\r\n\r\nworksheet.cell(row = 2, column = 2).value = ' SheetsTips '\r\n\r\n# Adjust\/set the height of the row to some random value using the height attribute.\r\nworksheet.row_dimensions[2].height = 50\r\n\r\n# Adjust\/set the width of the column to some random value using the width attribute.\r\nworksheet.column_dimensions['C'].width = 30\r\n\r\n# Save the above Workbook object with some random name using the save() function\r\n# by passing the excel file name as an argument to it.\r\nworkbookObj.save('setdimensionsOutput.xlsx')<\/pre>\nOutput:<\/strong><\/p>\n![\"adjusting](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/adjusting-rows-and-columns-size.jpg\")
<\/p>\n
<\/p>\n
Method #2: Merge Cells of the Excel File<\/h3>\n
The merge cells() sheet function can merge a rectangular area of cells into a single cell. The merge_cells() accepts a parameter i.e, a single string containing the top-left and bottom-right cells of the rectangular area to be combined.<\/p>\n
Approach:<\/strong><\/p>\n\n- Import openpyxl module using the import keyword<\/li>\n
- Create a new workbook object using the Workbook() function of the openpyxl module and store it in a variable.<\/li>\n
- Create the new Worksheet using the active attribute and store it in another variable.<\/li>\n
- Merge cells starting from A3 to D4 i.e. A3, B3, C3, D3, A4, B4, C4, and D4 using the merge_cells() function.<\/li>\n
- A3:D4′ merges cells into a single cell.<\/li>\n
- Assigning the value for the above merged 8 cells<\/li>\n
- Save the above resultant worksheet with some random name using the save() function.<\/li>\n
- The Exit of the Program.<\/li>\n<\/ul>\n
Below is the implementation:<\/strong><\/p>\n# Import openpyxl module using the import keyword\r\nimport openpyxl\r\n# Create a new workbook object using the Workbook() function of the openpyxl module\r\n# and store it in a variable.\r\nworkbookObj = openpyxl.Workbook()\r\n# Create the new Worksheet using the active attribute and store it in another variable.\r\nnewWorksheet = workbookObj.active\r\n\r\n# Merge cell from the starting from A3 to D4 i.e.\r\n# A3, B3, C3, D3, A4, B4, C4 and D4 using the merge_cells() function.\r\n# A3:D4' merges cells into a single cell.\r\nnewWorksheet.merge_cells('A3:D4')\r\n\r\n# Assigning the value for the above merged 8 cells\r\nnewWorksheet.cell(row = 3, column = 1).value = 'Eight cells merged together.'\r\n\r\n# Save the above resultant worksheet with some random name using the save() function.\r\nworkbookObj.save('mergedCellsOutput.xlsx')<\/pre>\nOutput:<\/strong><\/p>\n <\/p>\n
![\"merging](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/merging-cells.jpg\")
<\/p>\n
Method #3: UnMerge the Cells of an Excel File<\/h3>\n
Approach:<\/strong><\/p>\n\n- Import openpyxl module using the import keyword<\/li>\n
- Load the above(Method #2) Merged cells output excel file using the load_workbook() function
\nand store it in a variable.<\/li>\n - Create the new Worksheet using the active attribute and store it in another variable.<\/li>\n
- Apply unmerge_cells() function on the above worksheet to unmerge the cells.<\/li>\n
- Save the above resultant worksheet with some random name using the save() function after unmerging the cells.<\/li>\n
- The Exit of the Program.<\/li>\n<\/ul>\n
Below is the implementation:<\/strong><\/p>\n# Import openpyxl module using the import keyword\r\nimport openpyxl\r\n# Load the above(Method #2) Merged cells output excel file using the load_workbook() function \r\n# and store it in a variable.\r\nworkbookObj = openpyxl.load_workbook('mergedCellsOutput.xlsx')\r\n# Create the new Worksheet using the active attribute and store it in another variable.\r\nnewWorksheet = workbookObj.active\r\n\r\n# Apply unmerge_cells() function on the above worksheet to unmerge the cells.\r\nnewWorksheet.unmerge_cells('A3:D4')\r\n\r\n# Save the above resultant worksheet with some random name using the save() function after unmerging the cells\r\nworkbookObj.save('unmergedCellsOutput.xlsx')<\/pre>\nOutput:<\/strong><\/p>\n![\"unmerging](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/unmerging-cells.jpg\")
<\/p>\n
Now that you are provided with all the necessary information on how to adjust row size or column size in an Excel file using Python, Stay tuned to SheetsTips.com to learn more about the Python programming language.<\/p>\n","protected":false},"excerpt":{"rendered":"
Python is a powerful programmable language that allows us to perform various operations on Excel, from simple to complicated. Adjusting rows and columns in an Excel file just takes seconds. But we can also adjust the rows and columns in Excel just by using the\u00a0openpyxl module in Python. Surprised? Well, the detailed steps and examples … Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":3101,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[182],"tags":[],"jetpack_featured_media_url":"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/How-to-Adjust-Rows-and-Columns-of-an-Excel-File-using-openpyxl-Module-in-Python.png","jetpack-related-posts":[{"id":2881,"url":"https:\/\/sheetstips.com\/reading-excel-file-using-python\/","url_meta":{"origin":2801,"position":0},"title":"Reading an Excel File and Performing More Operations on it using Python","author":"David","date":"May 31, 2022","format":false,"excerpt":"Reading Excel Files in Python using Pandas: If you are an Excel user who wants to retrieve the data from the spreadsheet in Python, then this page is for you. To read the Excel data in Python, we can use the Pandas read_excel() function. The read_excel() function in Python will\u2026","rel":"","context":"In "MS Excel"","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"Reading an Excel File and Performing More Operations on it using Python","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/05\/Reading-an-Excel-File-and-Performing-More-Operations-on-it-using-Python.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2319,"url":"https:\/\/sheetstips.com\/python-program-how-to-copy-data-from-one-excel-sheet-to-another\/","url_meta":{"origin":2801,"position":1},"title":"Python Program How to Copy Data from One Excel sheet to Another","author":"David","date":"May 28, 2022","format":false,"excerpt":"Python Copy Excel Sheet: Openpyxl, a Python package used to read, write, and edit Excel files (with the extension xlsx, xlsm, xltx, xltm) is what we need in order to work with them. We must first open the source and target Excel files before we may copy one Excel file\u2026","rel":"","context":"In "MS Excel"","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"Python Program How to Copy Data from One Excel sheet to Another","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/05\/Python-Program-How-to-Copy-Data-from-One-Excel-sheet-to-Another.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3130,"url":"https:\/\/sheetstips.com\/python-reading-excel-file-using-openpyxl-module\/","url_meta":{"origin":2801,"position":2},"title":"Python Program for Reading an Excel File using openpyxl Module","author":"Anthony","date":"June 1, 2022","format":false,"excerpt":"Openpyxl is a Python library that reads and writes Excel files (with the extensions xlsx\/xlsm\/xltx\/xltm). Python openpyxl module allows the program to read and modify Excel files. For example, a user will have to go through hundreds of rows of data and select a few handful of information to make\u2026","rel":"","context":"In "MS Excel"","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"Python Program for Reading an Excel File using openpyxl Module","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/Python-Program-for-Reading-an-Excel-File-using-openpyxl-Module.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3607,"url":"https:\/\/sheetstips.com\/how-to-delete-one-or-more-rows-in-excel-using-openpyxl\/","url_meta":{"origin":2801,"position":3},"title":"How to Delete One or More Rows in Excel File using Python Openpyxl?","author":"David","date":"June 30, 2022","format":false,"excerpt":"In this tutorial, let us look at how to use openpyxl library to delete rows from an Excel sheet. Openpyxl Library: Openpyxl is a Python package that allows you to work with xlsx\/xlsm\/xltx\/xltm files. Openpyxl can be used to create a new Excel file or sheet, as well as to\u2026","rel":"","context":"In "MS Excel"","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Delete One or More Rows in Excel File using Python Openpyxl","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/How-to-Delete-One-or-More-Rows-in-Excel-File-using-Python-Openpyxl.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3737,"url":"https:\/\/sheetstips.com\/how-to-replace-a-word-in-excel-using-python\/","url_meta":{"origin":2801,"position":4},"title":"Python Program to Replace a Word in Excel","author":"David","date":"November 29, 2022","format":false,"excerpt":"Excel is a very handy tool for displaying data in the form of rows and columns. We can state that before the database, excel played an important role in data storing. Many batch processes are now carried out using Excel input. The need to replace text in an Excel sheet\u2026","rel":"","context":"In "MS Excel"","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"Python Program to Replace a Word in Excel","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/Python-Program-to-Replace-a-Word-in-Excel.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4128,"url":"https:\/\/sheetstips.com\/how-to-count-number-of-rows-and-columns-in-an-excel-file-in-python\/","url_meta":{"origin":2801,"position":5},"title":"How to Count Number of Rows and Columns in an Excel file in Python?","author":"David","date":"December 2, 2022","format":false,"excerpt":"In this article, let us look at how to count the number of rows and columns in an excel file using python. For this purpose, we make use of the xlrd library in python here. Let us use the sampleExcelFile.xlsx file here which has the following data: sampleExcelFile: \u00a0 Python\u2026","rel":"","context":"In "MS Excel"","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Count Number of Rows and Columns in an Excel file in Python","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/07\/How-to-Count-Number-of-Rows-and-Columns-in-an-Excel-file-in-Python.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2801"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=2801"}],"version-history":[{"count":15,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2801\/revisions"}],"predecessor-version":[{"id":3464,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2801\/revisions\/3464"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media\/3101"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=2801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=2801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=2801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}