Загрузка и управление файлами Excel,OpenOffice,Json, Csv и Html

Создание новой книги

В следующем примере создается новая книга с нуля.

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

Открытие и сохранение файла

С Aspose.Cells для Python via .NET просто открывать, сохранять и управлять файлами 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

Продвинутые темы

NumPy, Pandas и Python Data