Convert Dates to Japanese Dates with Python.NET

In the Japanese Calendar, a new era begins with the reign of a new emperor. On 1st May 2019, a new emperor came into power with which the Heisei era ended and the Reiwa era began.

Aspose.Cells provides a way to convert Gregorian dates to Japanese dates while considering era changes. The following code snippet demonstrates converting a source Excel file containing Gregorian dates to a PDF output with Japanese dates:

import os
from aspose.cells import Workbook, LoadOptions, LoadFormat, SaveFormat, CountryCode

# Source directory
current_dir = os.path.dirname(os.path.abspath(__file__))
source_dir = os.path.join(current_dir, "data")
output_dir = os.path.join(current_dir, "output")

# Create output directory if not exists
if not os.path.exists(output_dir):
    os.makedirs(output_dir)

# Initialize load options with XLSX format
options = LoadOptions(LoadFormat.XLSX)
options.region = CountryCode.JAPAN

# Load workbook with Japanese regional settings
workbook = Workbook(os.path.join(source_dir, "JapaneseDates.xlsx"), options)

# Save as PDF
workbook.save(os.path.join(output_dir, "JapaneseDates.pdf"), SaveFormat.PDF)

Python.NET Conversion:

Note: Ensure Japanese language support is enabled in your environment for accurate era conversions. The Workbook class and PdfSaveOptions provide the necessary functionality for this conversion.