python 写入excel

最新推荐文章于 2023-06-12 15:29:58 发布

furaoingqq

最新推荐文章于 2023-06-12 15:29:58 发布

阅读量512

点赞数

分类专栏： python programming

python programming 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

XlsxWriter是基于Python的，用来操作Excel的库。100%支持xlsx文件的写入操作。

示例代码：

 
        from 
         xlsxwriter.workbook  
        import 
         Workbook 
       
        # Create an new Excel file and add a worksheet. 
       
        workbook  
        = 
         Workbook( 
        'demo.xlsx' 
        ) 
       
        worksheet  
        = 
         workbook.add_worksheet() 
       
        # Widen the first column to make the text clearer. 
       
        worksheet.set_column( 
        'A:A' 
        ,  
        20 
        ) 
       
        # Add a bold format to highlight cell text. 
       
        bold  
        = 
         workbook.add_format({ 
        'bold' 
        :  
        1 
        }) 
       
        # Write some simple text. 
       
        worksheet.write( 
        'A1' 
        ,  
        'Hello' 
        ) 
       
        # Text with formatting. 
       
        worksheet.write( 
        'A2' 
        ,  
        'World' 
        , bold) 
       
        # Write some numbers, with row/column notation. 
       
        worksheet.write( 
        2 
        ,  
        0 
        ,  
        123 
        ) 
       
        worksheet.write( 
        3 
        ,  
        0 
        ,  
        123.456 
        ) 
       
        workbook.close()