Writing to an excel sheet using Python

Using xlwt module, one can perform multiple operations on spreadsheet. For example, writing or modifying the data can be done in Python. Also, the user might have to go through various sheets and retrieve data based on some criteria or modify some rows and columns and do a lot of work.

Let’s see how to create and write to an excel-sheet using Python.
 

Code #1 :

filter_none

edit
close

play_arrow

link
brightness_4
code

# Writing to an excel 
# sheet using Python
import xlwt
from xlwt import Workbook
  
# Workbook is created
wb = Workbook()
  
# add_sheet is used to create sheet.
sheet1 = wb.add_sheet('Sheet 1')
  
sheet1.write(1, 0, 'ISBT DEHRADUN')
sheet1.write(2, 0, 'SHASTRADHARA')
sheet1.write(3, 0, 'CLEMEN TOWN')
sheet1.write(4, 0, 'RAJPUR ROAD')
sheet1.write(5, 0, 'CLOCK TOWER')
sheet1.write(0, 1, 'ISBT DEHRADUN')
sheet1.write(0, 2, 'SHASTRADHARA')
sheet1.write(0, 3, 'CLEMEN TOWN')
sheet1.write(0, 4, 'RAJPUR ROAD')
sheet1.write(0, 5, 'CLOCK TOWER')
  
wb.save('xlwt example.xls')

chevron_right






                        filter_none










Output :

Sample excel file

 



Code #2 : Adding style sheet in excel











                                    filter_none




                                    edit

                                    close




                                    play_arrow




                                    link

                                    brightness_4

                                    code
                                




















# importing xlwt module 


import xlwt 


  


workbook = xlwt.Workbook()  


  


sheet = workbook.add_sheet("Sheet Name") 


  


# Specifying style 


style = xlwt.easyxf('font: bold 1') 


  


# Specifying column 


sheet.write(0, 0, 'SAMPLE', style) 


workbook.save("sample.xls") 



















                        chevron_right







                        filter_none










Output :

Sample file

 

Code #3 : Adding multiple styles to a cell













                                    filter_none




                                    edit

                                    close




                                    play_arrow




                                    link

                                    brightness_4

                                    code
                                




















# importing xlwt module 


import xlwt 


  


workbook = xlwt.Workbook()  


  


sheet = workbook.add_sheet("Sheet Name") 


  


# Applying multiple styles 


style = xlwt.easyxf('font: bold 1, color red;') 


  


# Writing on specified sheet 


sheet.write(0, 0, 'SAMPLE', style) 


  


workbook.save("sample.xls") 



















                        chevron_right







                        filter_none










Output :

sample file



          
          
          
          

            

    

        My Personal Notes
        arrow_drop_up
    

    

        
        

            
            
        

    


Recommended Posts:
Image
aishwarya.27
Check out this Author's contributed articles.
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on  the "Improve Article" button below.


Improved By :  shubham_singh


      
      
      
      

      

      
					
		

    Article Tags : 
Python

           	
        

         

         
 
                1

                

        



        
        
        
        
        

    

            

            2
            

            

             
                 Based on 1 vote(s)
                    

            
            
            
            
            
        

        
        

        

        

        

        

        

        


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.