Chargement et gestion de fichiers Excel, OpenOffice, Json, Csv et Html

Création d’un nouveau classeur

L’exemple suivant crée un nouveau classeur à partir de zéro.

from aspose.cells import License, Workbook
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
try:
# Create a License object
license = License()
# Set the license of Aspose.Cells to avoid the evaluation limitations
license.set_license(dataDir + "Aspose.Cells.lic")
except Exception as ex:
print(str(ex))
# Instantiate a Workbook object that represents Excel file.
wb = Workbook()
# When you create a new workbook, a default "Sheet1" is added to the workbook.
sheet = wb.worksheets[0]
# Access the "A1" cell in the sheet.
cell = sheet.cells.get("A1")
# Input the "Hello World!" text into the "A1" cell
cell.put_value("Hello World!")
# Save the Excel file.
wb.save(dataDir + "MyBook_out.xlsx")
view raw Open-files-FirstApplication-1.py hosted with ❤ by GitHub

Ouverture et enregistrement d’un fichier

Avec Aspose.Cells pour Python via .NET, il est simple d’ouvrir, enregistrer et gérer des fichiers Excel.

from aspose.cells import Workbook
from datetime import datetime
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
dataDir = RunExamples.GetDataDir(".")
# Opening through Path
# Creating a Workbook object and opening an Excel file using its file path
workbook1 = Workbook(dataDir + "Book1.xlsx")
# Adding new sheet
sheet = workbook1.worksheets.add("MySheet")
# Setting active aheet
workbook1.worksheets.active_sheet_index = 1
# Setting values.
cells = sheet.cells
# Setting text
cells.get("A1").put_value("Hello!")
# Setting number
cells.get("A2").put_value(1000)
# Setting Date Time
cell = cells.get("A3")
cell.value = datetime.now()
style = cell.get_style()
style.number = 14
cell.set_style(style)
# Setting formula
cells.get("A4").formula = "=SUM(A1:A3)"
# Saving the workbook to disk.
workbook1.save(dir + "dest.xlsx")
view raw Open-files-Open-Save-Workbook-1.py hosted with ❤ by GitHub

Sujets avancés

NumPy, Pandas et Python pour les données