Python で Excel ファイルを作成する方法

Read and Write Excel Files

• Supports Multiple Formats: With IronXL, we can create an Excel file and read an existing Excel file. This includes both the XLS and Excel XLSX file formats that enable the usage of different versions of Excel files.
• Cross Platform Compatibility: It lets the users work on the files in Excel without having to install them on the machine, running in Windows, Linux, and macOS environments.

Formulas

• Microsoft Excel Formulas: It is capable of reading and writing Microsoft Excel formulas so that developers can perform calculations on the automated Excel spreadsheet. It supports formulas like SUM, AVERAGE, and VLOOKUP, besides complex ones with the use of nested ones in various forms.
• Dynamic Recalculation: In this library, formula recalculation is supported dynamically whenever data changes, and Excel files are maintained without manual recalculation for consistency.

Data Modification and Formatting

• Modifying Cells and Ranges: Cells or ranges of data could be easily changed to different types, aligned data ranges, or used in cell format without the complexity of syntax. IronXL offers simple methods to set data types like text, number, dates, and booleans.
• Bulk Data Input: IronXL supports inputting bulk data into an Excel sheet, making it much more efficient while dealing with large datasets or automatically importing data.

Styling and Formatting

• Cell and Text Formatting: IronXL supports formatting cells and text using more advanced fonts, colors, borders, and number formats, including currency and percentage formatting. The product allows the user to customize headers and footers and make even some data ranges bold or italic.
• Conditional Formatting: The rule for conditional formatting helps to enhance the presentation of data visually by applying styles based on the value in the cell's particular threshold may trigger the application of highlighting to the cell.

Chart Creation

• Charting Capabilities: IronXL can create various forms of charts such as bar, line, pie, and column charts right inside the Excel sheets. This is very helpful to automatically run any visual reports and data summarizations.
• Chart Styling: The user can style colors and legends, titles, and axes of a chart based on branding or presentation requirements.

Worksheet Management

• Multiple Worksheets: You can create, edit, and delete multiple worksheets within a single Excel file. This means that managing complex workbooks will be convenient.
• Sheet Navigation: You can navigate different sheets and focus on one after another, renaming or reordering sheets programmatically.

Data Validation

• Input Validations: Using IronXL, you can define data validation rules on what you want not to accept in particular cells so that the entered data is clean and accurate.
• Dropdown Lists: This is how you can create dropdown lists so that users can easily choose the correct data in Excel for a more enjoyable and less error-prone experience.

Create a New File

Create a new file in VSCode and save it using the .py extension, marking it as a Python script. For this tutorial, you might call it CreateToExcel.py.

Installing IronXL

Open the integrated terminal in VSCode using Ctrl+\`` or navigate through the menu:View > Terminal`.

Install IronXL by running the command:

pip install ironxl

pip install ironxl

The IronXL library and its dependencies are downloaded and installed with this command.

Create an Excel file Using IronXL

Below is an example of how one could create and work with an Excel workbook when using the IronXL library with Python.

from ironxl import *

# Create new Excel WorkBook document
workbook = WorkBook.Create()

# Create a blank WorkSheet in the workbook
worksheet = workbook.CreateWorkSheet("new_sheet")

# Add data to the specific cell A1 of the worksheet
worksheet["A1"].Value = "Hello World"

# Save the Excel file with the name "test.xlsx"
workbook.SaveAs("test.xlsx")

from ironxl import *

# Create new Excel WorkBook document
workbook = WorkBook.Create()

# Create a blank WorkSheet in the workbook
worksheet = workbook.CreateWorkSheet("new_sheet")

# Add data to the specific cell A1 of the worksheet
worksheet["A1"].Value = "Hello World"

# Save the Excel file with the name "test.xlsx"
workbook.SaveAs("test.xlsx")

In this code:

1. We start by importing all classes and functions from the ironxl library.
2. We create a new Excel workbook using the WorkBook.Create method.
3. A new blank worksheet named "new_sheet" is created and added to the workbook using the CreateWorkSheet method.
4. The value "Hello World" is written to cell A1 of the worksheet.
5. Finally, the workbook is saved to the disk as "test.xlsx" using the SaveAs method.

This code highlights the basic steps for creating Excel files, adding data to them, and saving them to disk. IronXL simplifies automation tasks such as data entry and formatting in Excel.