{"id":2962,"date":"2022-06-01T20:46:42","date_gmt":"2022-06-01T15:16:42","guid":{"rendered":"https:\/\/sheetstips.com\/?p=2962"},"modified":"2022-06-01T20:46:42","modified_gmt":"2022-06-01T15:16:42","slug":"writing-excel-sheet-using-python","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/writing-excel-sheet-using-python\/","title":{"rendered":"Python Program to Write to an Excel Sheet using xlwt module"},"content":{"rendered":"<p>In this article, we are going to write to an Excel Sheet using the xlwt module in Python<\/p>\n<p><strong>Xlwt Module:<\/strong><\/p>\n<p>Multiple spreadsheet operations can be performed with the xlwt module. Python, for example, can be used to write or modify data. In addition, the user may have to navigate through several sheets and get data based on some criteria, or edit some rows and columns, among other things.<\/p>\n<h2>Program to Write to an Excel Sheet using xlwt module in Python<\/h2>\n<ul>\n<li><a href=\"#Writing_an_Excel_Worksheet\">Writing an Excel Worksheet<\/a><\/li>\n<li><a href=\"#Adding_Style_Sheet_in_Excel\">Adding Style Sheet in Excel<\/a><\/li>\n<li><a href=\"#Adding_Multiple_Styles_Sheet_in_Excel\">Adding Multiple Styles Sheet in Excel<\/a><\/li>\n<\/ul>\n<h3 id=\"Writing_an_Excel_Worksheet\">Code #1: Writing an Excel Worksheet<\/h3>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Import the xlwt module using the import keyword.<\/li>\n<li>Import the Workbook class from the xlwt module using the from and import keywords.<\/li>\n<li>Create a workbook using the Workbook() function and store it in a variable.<\/li>\n<li>Add a sheet to the above workbook by passing the Sheet Name to the add_sheet() function and store this sheet in a variable.<\/li>\n<li>Add some data to the sheet using the write() function.<\/li>\n<li>Save the workbook by passing the name as an argument using the save() function.<\/li>\n<li>The Exit of the Program.<\/li>\n<\/ul>\n<p><strong>Below is the Implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Import the xlwt module using the import keyword\r\nimport xlwt\r\n# Import the Workbook class from xlwt module using the from and import keywords\r\nfrom xlwt import Workbook\r\n# Create a workbook using the Workbook() function  and store it in a variable\r\nworkbook = Workbook()\r\n\r\n# Add a sheet to the above workbook by passing the Sheet Name to the add_sheet() function and store this sheet in a variable\r\nfirstSheet1 = workbook.add_sheet('Sheet 1')\r\n\r\n# Add some data to the sheet using the write() function\r\nfirstSheet1.write(1, 0, 'Sheets Tips')\r\nfirstSheet1.write(2, 0, 'Python-Programs')\r\nfirstSheet1.write(3, 0, 'Btechgeeks')\r\nfirstSheet1.write(4, 0, 'Python Array')\r\nfirstSheet1.write(5, 0, 'Vikram')\r\nfirstSheet1.write(0, 1, 'Sheets Tips')\r\nfirstSheet1.write(0, 2, 'Python-Programs')\r\nfirstSheet1.write(0, 3, 'Btechgeeks')\r\nfirstSheet1.write(0, 4, 'Python Array')\r\nfirstSheet1.write(0, 5, 'Vikram')\r\n\r\n# Save the workbook by passing the name as an argument using the save() function\r\nworkbook.save('sampleExcelFile1.xlsx')\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3099\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output.jpg\" alt=\"sample excel file output\" width=\"898\" height=\"377\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output.jpg 898w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-300x126.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-768x322.jpg 768w\" sizes=\"(max-width: 898px) 100vw, 898px\" \/><\/p>\n<h3 id=\"Adding_Style_Sheet_in_Excel\">Code #2: Adding Style Sheet in Excel<\/h3>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Import the xlwt module using the import keyword.<\/li>\n<li>Import the Workbook class from xlwt module using the from and import keywords.<\/li>\n<li>Create a workbook using the Workbook() function and store it in a variable.<\/li>\n<li>Add a sheet to the above workbook by passing the Sheet Name to the add_sheet() function and store this sheet in a variable.<\/li>\n<li>\n<div>\n<div>Give\u00a0the\u00a0style\u00a0as\u00a0argument\u00a0to\u00a0the\u00a0easyxf()\u00a0function\u00a0of\u00a0the\u00a0xlwt\u00a0module<\/div>\n<\/div>\n<\/li>\n<li>Add some data to the sheet using the write() function.<\/li>\n<li>Save the workbook by passing the name as an argument using the save() function.<\/li>\n<li>The Exit of the Program.<\/li>\n<\/ul>\n<p><strong>Below is the Implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Import the xlwt module using the import keyword\r\nimport xlwt\r\n# Import the Workbook class from xlwt module using the from and import keywords\r\nfrom xlwt import Workbook\r\n# Create a workbook using the Workbook() function  and store it in a variable\r\nworkbook = Workbook()\r\n\r\n# Add a sheet to the above workbook by passing the Sheet Name to the add_sheet() function and store this sheet in a variable\r\nfirstSheet1 = workbook.add_sheet('Sheet 1')\r\n\r\n# Give the style as argument to the easyxf() function of the xlwt module\r\nstyleFormat = xlwt.easyxf('font: bold 1')\r\n# Add some data to the sheet using the write() function\r\nfirstSheet1.write(1, 0, 'Sheets Tips',styleFormat)\r\nfirstSheet1.write(2, 0, 'Python-Programs',styleFormat)\r\nfirstSheet1.write(3, 0, 'Btechgeeks',styleFormat)\r\nfirstSheet1.write(4, 0, 'Python Array',styleFormat)\r\nfirstSheet1.write(5, 0, 'Vikram',styleFormat)\r\nfirstSheet1.write(0, 1, 'Sheets Tips',styleFormat)\r\nfirstSheet1.write(0, 2, 'Python-Programs',styleFormat)\r\nfirstSheet1.write(0, 3, 'Btechgeeks',styleFormat)\r\nfirstSheet1.write(0, 4, 'Python Array',styleFormat)\r\nfirstSheet1.write(0, 5, 'Vikram',styleFormat)\r\n\r\n# Save the workbook by passing the name as an argument using the save() function\r\nworkbook.save('sampleExcelFile2.xlsx')\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3098\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-after-adding-styles.jpg\" alt=\"sample excel file output after adding styles\" width=\"950\" height=\"377\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-after-adding-styles.jpg 950w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-after-adding-styles-300x119.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-after-adding-styles-768x305.jpg 768w\" sizes=\"(max-width: 950px) 100vw, 950px\" \/><\/p>\n<h3 id=\"Adding_Multiple_Styles_Sheet_in_Excel\">Code #3: Adding Multiple Styles Sheet in Excel<\/h3>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Import the xlwt module using the import keyword.<\/li>\n<li>Import the Workbook class from xlwt module using the from and import keywords.<\/li>\n<li>Create a workbook using the Workbook() function and store it in a variable.<\/li>\n<li>Add a sheet to the above workbook by passing the Sheet Name to the add_sheet() function and store this sheet in a variable.<\/li>\n<li>\n<div>\n<div>Give the multiple styles as an argument to the easyxf() function of the xlwt module<\/div>\n<\/div>\n<\/li>\n<li>Add some data to the sheet using the write() function.<\/li>\n<li>Save the workbook by passing the name as an argument using the save() function.<\/li>\n<li>The Exit of the Program.<\/li>\n<\/ul>\n<p><strong>Below is the Implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Import the xlwt module using the import keyword\r\nimport xlwt\r\n# Import the Workbook class from xlwt module using the from and import keywords\r\nfrom xlwt import Workbook\r\n# Create a workbook using the Workbook() function  and store it in a variable\r\nworkbook = Workbook()\r\n\r\n# Add a sheet to the above workbook by passing the Sheet Name to the add_sheet() function and store this sheet in a variable\r\nfirstSheet1 = workbook.add_sheet('Sheet 1')\r\n\r\n# Give the style as argument to the easyxf() function of the xlwt module\r\nstyleFormat = xlwt.easyxf('font: bold 1, color blue;')\r\n# Add some data to the sheet using the write() function\r\nfirstSheet1.write(1, 0, 'Sheets Tips',styleFormat)\r\nfirstSheet1.write(2, 0, 'Python-Programs',styleFormat)\r\nfirstSheet1.write(3, 0, 'Btechgeeks',styleFormat)\r\nfirstSheet1.write(4, 0, 'Python Array',styleFormat)\r\nfirstSheet1.write(5, 0, 'Vikram',styleFormat)\r\nfirstSheet1.write(0, 1, 'Sheets Tips',styleFormat)\r\nfirstSheet1.write(0, 2, 'Python-Programs',styleFormat)\r\nfirstSheet1.write(0, 3, 'Btechgeeks',styleFormat)\r\nfirstSheet1.write(0, 4, 'Python Array',styleFormat)\r\nfirstSheet1.write(0, 5, 'Vikram',styleFormat)\r\n\r\n# Save the workbook by passing the name as an argument using the save() function\r\nworkbook.save('sampleExcelFile3.xlsx')\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3097\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-after-adding-multiple-styles.jpg\" alt=\"sample excel file output after adding multiple styles\" width=\"922\" height=\"374\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-after-adding-multiple-styles.jpg 922w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-after-adding-multiple-styles-300x122.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/sample-excel-file-output-after-adding-multiple-styles-768x312.jpg 768w\" sizes=\"(max-width: 922px) 100vw, 922px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we are going to write to an Excel Sheet using the xlwt module in Python Xlwt Module: Multiple spreadsheet operations can be performed with the xlwt module. Python, for example, can be used to write or modify data. In addition, the user may have to navigate through several sheets and get data &#8230; <a title=\"Python Program to Write to an Excel Sheet using xlwt module\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/writing-excel-sheet-using-python\/\" aria-label=\"More on Python Program to Write to an Excel Sheet using xlwt module\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":3121,"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\/Python-Program-to-Write-to-an-Excel-Sheet-using-xlwt-module.png","jetpack-related-posts":[{"id":3560,"url":"https:\/\/sheetstips.com\/python-for-spreadsheet-users\/","url_meta":{"origin":2962,"position":0},"title":"Python for Spreadsheet Users","author":"David","date":"June 29, 2022","format":false,"excerpt":"Spreadsheet: A spreadsheet is a type of computer program that captures, displays, and manipulates data that is organized in rows and columns. Spreadsheets are one of the most widely used tools on personal computers. A spreadsheet is typically used to store numerical data as well as short text strings. Spreadsheet\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"Python for Spreadsheet Users","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/Python-for-Spreadsheet-Users.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1971,"url":"https:\/\/sheetstips.com\/change-value-in-excel-using-python\/","url_meta":{"origin":2962,"position":1},"title":"Change value in Excel using Python","author":"David","date":"May 12, 2022","format":false,"excerpt":"Here, we will use Python to update a value in an Excel spreadsheet. 1)Opening an Excel File: openpyxl is a Python package that allows you to read and write Excel xlsx\/xlsm\/xltx\/xltm files. It originated from the lack of an existing library that allowed Python to read and write the Office\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"Change value in Excel using Python using xlwt","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/01\/Change-value-in-Excel-using-Python-using-xlwt.png?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":2962,"position":2},"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 &quot;MS Excel&quot;","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":4110,"url":"https:\/\/sheetstips.com\/how-to-find-the-number-of-blank-and-non-blank-cells-in-excel-table-using-python\/","url_meta":{"origin":2962,"position":3},"title":"How to Find the number of Blank and Non-Blank cells in Excel table using Python?","author":"David","date":"August 15, 2022","format":false,"excerpt":"In this article let us see how to count\/find the number of blank and Non-Blank cells in an Excel table using Python Along with the use of excel spreadsheets in nearly every aspect of daily life to perform calculations, analysis, and visualization of data and information, keeping track of the\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Find the number of Blank and Non-Blank cells in Excel table using Python","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/07\/How-to-Find-the-number-of-Blank-and-Non-Blank-cells-in-Excel-table-using-Python.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2729,"url":"https:\/\/sheetstips.com\/how-to-create-and-write-on-excel-file-using-xlsxwriter-module-in-python\/","url_meta":{"origin":2962,"position":4},"title":"How to Create and Write on Excel File using xlsxwriter Module in Python","author":"David","date":"May 28, 2022","format":false,"excerpt":"If you want to read or write data in an Excel file using Python, then you can simply use the XLSX writer module. Using the xlsxwriter function in Python, you can simply read or add information to the desired Excel file. Also, with the help of the xlsxwriter function, one\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Create and Write on Excel File using xlsxwriter Module in Python","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/05\/How-to-Create-and-Write-on-Excel-File-using-xlsxwriter-Module-in-Python.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2974,"url":"https:\/\/sheetstips.com\/python-plotting-charts-in-excel-sheet-using-openpyxl-module-set-3\/","url_meta":{"origin":2962,"position":5},"title":"Python Program Plotting Charts in Excel Sheet using openpyxl module | Set 3","author":"David","date":"June 1, 2022","format":false,"excerpt":"One of the most significant Python packages, Openpyxl, enables users to automate a variety of Excel tasks, including reading, writing, mathematical calculations, creating graphs, and more. Let's talk about how to use Openpyxl to make charts on an Excel sheet without launching the Excel sheet in this article. Before plotting\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"Python Program Plotting Charts in Excel Sheet using openpyxl module Set 3","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/05\/Python-Program-Plotting-Charts-in-Excel-Sheet-using-openpyxl-module-Set-3.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2962"}],"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=2962"}],"version-history":[{"count":6,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2962\/revisions"}],"predecessor-version":[{"id":3100,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2962\/revisions\/3100"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media\/3121"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=2962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=2962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=2962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}