Caricamento e gestione di file Excel, OpenOffice, Json, Csv and Html

Creazione di un nuovo foglio di lavoro

Nell’esempio seguente si crea un nuovo libro di lavoro da zero.

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

Apertura e salvataggio di un file

Con Aspose.Cells per Python via .NET, è semplice aprire, salvare e gestire file 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

Argomenti avanzati

NumPy, Pandas e Python Data