Python |使用xlsxwriter模块在excel文件上创建和写入-yiteyi-C++库

XlsxWriter 是一个Python模块，用于以XLSX文件格式编写文件。它可以用于将文本、数字和公式写入多个工作表。此外，它还支持格式、图像、图表、页面设置、自动筛选、条件格式等功能。使用以下命令安装xlsxwriter模块：

null

 pip install xlsxwriter

注：在整个XlsxWriter中，行和列的索引为零。工作表中的第一个单元格，A1是（0,0），B1是（0,1），A2是（1,0），B2是（1,1）。。所有人都是如此。让我们看看如何使用Python创建并写入excel工作表。 代码#1： 使用A1符号（单元格名称）在特定单元格中写入数据。

Python3

                           # import xlsxwriter module                         
                           import                                        xlsxwriter                         
            
                           # Workbook() takes one, non-optional, argument                         
                           # which is the filename that we want to create.                         
                           workbook                                        =                                        xlsxwriter.Workbook(                                        'hello.xlsx'                                        )                         
            
                           # The workbook object is then used to add new                         
                           # worksheet via the add_worksheet() method.                         
                           worksheet                                        =                                        workbook.add_worksheet()                         
            
                           # Use the worksheet object to write                         
                           # data via the write() method.                         
                           worksheet.write(                                        'A1'                                        ,                                        'Hello..'                                        )                         
                           worksheet.write(                                        'B1'                                        ,                                        'Geeks'                                        )                         
                           worksheet.write(                                        'C1'                                        ,                                        'For'                                        )                         
                           worksheet.write(                                        'D1'                                        ,                                        'Geeks'                                        )                         
            
                           # Finally, close the Excel file                         
                           # via the close() method.                         
                           workbook.close()                         

输出：

图片[1]-Python |使用xlsxwriter模块在excel文件上创建和写入-yiteyi-C++库

代码#2： 使用行-列表示法（索引值）在特定单元格中写入数据。

Python3

                           # import xlsxwriter module                         
                           import                                        xlsxwriter                         
            
                           workbook                                        =                                        xlsxwriter.Workbook(                                        'Example2.xlsx'                                        )                         
                           worksheet                                        =                                        workbook.add_worksheet()                         
            
                           # Start from the first cell.                         
                           # Rows and columns are zero indexed.                         
                           row                                        =                                        0                         
                           column                                        =                                        0                         
            
                           content                                        =                                        [                                        "ankit"                                        ,                                        "rahul"                                        ,                                        "priya"                                        ,                                        "harshita"                                        ,                         
                                                     "sumit"                                        ,                                        "neeraj"                                        ,                                        "shivam"                                        ]                         
            
                           # iterating through content list                         
                           for                                        item                                        in                                        content :                         
            
                                                     # write operation perform                         
                                                     worksheet.write(row, column, item)                         
            
                                                     # incrementing the value of row by one                         
                                                     # with each iterations.                         
                                                     row                                        +                                        =                                        1                         
                                      
                           workbook.close()                         

输出：

图片[2]-Python |使用xlsxwriter模块在excel文件上创建和写入-yiteyi-C++库

代码#3： 创建具有特定名称的新工作表

Python3

                           # import xlsxwriter module                         
                           import                                        xlsxwriter                         
            
                           workbook                                        =                                        xlsxwriter.Workbook(                                        'Example3.xlsx'                                        )                         
            
                           # By default worksheet names in the spreadsheet will be                         
                           # Sheet1, Sheet2 etc., but we can also specify a name.                         
                           worksheet                                        =                                        workbook.add_worksheet(                                        "My sheet"                                        )                         
            
                           # Some data we want to write to the worksheet.                         
                           scores                                        =                                        (                         
                                                     [                                        'ankit'                                        ,                                        1000                                        ],                         
                                                     [                                        'rahul'                                        ,                                        100                                        ],                         
                                                     [                                        'priya'                                        ,                                        300                                        ],                         
                                                     [                                        'harshita'                                        ,                                        50                                        ],                         
                           )                         
            
                           # Start from the first cell. Rows and                         
                           # columns are zero indexed.                         
                           row                                        =                                        0                         
                           col                                        =                                        0                         
            
                           # Iterate over the data and write it out row by row.                         
                           for                                        name, score                                        in                                        (scores):                         
                                                     worksheet.write(row, col, name)                         
                                                     worksheet.write(row, col                                        +                                        1                                        , score)                         
                                                     row                                        +                                        =                                        1                         
            
                           workbook.close()                         