Python创建Excel表格并写入数据之xlwt

  

   

    

     

    
    

     

      #!python3
     
    
   

    

     

    
    

     

      #coding:utf-8
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      import xlwt
     
    
   

    

     

    
    

     

      f = xlwt.Workbook()
     
    
   

    

     

    
    

     

      sheet1 = f.add_sheet(r'sheet1', cell_overwrite_ok=True)
     
    
   

    

     

    
    

     

      sheet1.write(0,0,"Name")
     
    
   

    

     

    
    

     

      sheet1.write(0,1,"Conf")
     
    
   

    

     

    
    

     

      sheet1.write(0,2,"Grid score")
     
    
   

    

     

    
    

     

      sheet1.write(0,3,"Grid_vdw")
     
    
   

    

     

    
    

     

      sheet1.write(0,4,"Grid_es")
     
    
   

    

     

    
    

     

      sheet1.write(0,5,"Int_energy")
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      f.save('dockout.xls')
     
    
  
 

文章来源: drugai.blog.csdn.net，作者：DrugAI，版权归原作者所有，如需转载，请联系作者。

原文链接：drugai.blog.csdn.net/article/details/77676565