{"id":1524,"date":"2023-02-08T20:00:00","date_gmt":"2023-02-08T11:00:00","guid":{"rendered":"https:\/\/python-academia.com\/en\/?p=1524"},"modified":"2023-01-09T11:09:13","modified_gmt":"2023-01-09T02:09:13","slug":"list-excel","status":"publish","type":"post","link":"https:\/\/python-academia.com\/en\/list-excel\/","title":{"rendered":"[Python] How to Write List to Excel [openpyxl, pandas]"},"content":{"rendered":"\n

This article shows how to write list to Excel<\/span>.<\/p>\n\n\n\n

Use “openpyxl”, a library for Excel manipulation in Python.<\/p>\n\n\n\n

As a supplement, I also show how to write a list to Excel using “pandas”.<\/p>\n\n\n\n

<\/i>Contents<\/span><\/p>

\n

<\/p>\n\n\n\n

  • How to use “openpyxl”<\/li>
  • How to write list to Excel using “openpyxl”<\/li>
  • How to write list to Excel using “pandas”<\/li><\/ul>\n\n\n\n

    <\/p>\n<\/div><\/div>\n\n\n\n

    <\/div>\n\n\n\n

    How to use “openpyxl”<\/h2>\n\n\n\n

    “openpyxl” is the most common library for Excel manipulation in Python<\/span>.<\/p>\n\n\n\n

    <\/div>\n\n\n\n

    In the beginning, I show basic usage of “openpyxl”.<\/p>\n\n\n\n

    <\/div>\n\n\n\n

    Installing “openpyxl” in Python<\/h3>\n\n\n\n

    “openpyxl” is external library.<\/p>\n\n\n\n

    External libraries in Python can also be downloaded and installed using pip which is a package manager.<\/p>\n\n\n\n

    To install “openpyxl”, you run the following in your terminal or command line.<\/p>\n\n\n\n

    > pip install openpyxl<\/p>\n\n\n\n

    <\/div>\n\n\n\n

    Basic usage of “openpyxl”<\/h3>\n\n\n\n

    I show basic usage of “openpyxl”<\/span>.<\/p>\n\n\n\n

    <\/div>\n\n\n\n

    This is an example code to create a new Excel Workbook<\/span>.<\/p>\n\n\n\n

    import openpyxl\n\npath_excel = r'C:\\***** any path *****\\test.xlsx'\n\nwb = openpyxl.Workbook()\nsheet = wb.worksheets[0]\n\nsheet.cell(2, 1, 'Apple')\n\nwb.save(path_excel)\nwb.close()<\/code><\/pre>\n\n\n\n
    <\/div>\n\n\n\n
    > path_excel = r’C:***** any path *****\\test.xlsx’<\/p>\n\n\n\n
    Specify the path of the new Excel file.<\/p>\n\n\n\n
    By prefixing a string literal with “r”, you can create a raw string in Python.<\/p>\n\n\n\n
    “Raw string” treats the backslash character “\\n” as a literal character, not newline.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    > wb = openpyxl.Workbook()<\/p>\n\n\n\n
    A new Excel file is created.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    > sheet = wb.worksheets[0]<\/p>\n\n\n\n
    The 0th Excel sheet is specified.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    > sheet.cell(2, 1, ‘Apple’)<\/p>\n\n\n\n
    The string “Apple” is written to the second row and first column of the sheet specified earlier.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    > wb.save(path_excel)<\/p>\n\n\n\n
    The Excel file is saved.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    > wb.close()<\/p>\n\n\n\n
    The Excel file is closed.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    Write list into existing Excel file<\/h3>\n\n\n\n
    <\/div>\n\n\n\n
    This is an example code to write list into existing Excel file.<\/p>\n\n\n\n
    import openpyxl\n\npath_excel = r'C:\\***** any path *****\\test.xlsx'\n\nwb = openpyxl.load_workbook(path_excel)\nsheet = wb.worksheets[0]\n\nsheet.cell(3, 1, 'Banana')\n\nwb.save(path_excel)\nwb.close()<\/code><\/pre>\n\n\n\n
    <\/div>\n\n\n\n
    > wb = openpyxl.load_workbook(path_excel)<\/p>\n\n\n\n
    Existing Excel file is opened.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    sponsored link<\/p>\n\n\n\n\n
    \n