Loading and managing Excel,OpenOffice,Json, Csv and Html files

With Aspose.Cells for Python via .NET, it is simple to create,open and manage Excel files, for example, to retrieve data, or to use a designer template to speed up the development process.

Creating a New Workbook

The following example creates a new workbook from the scratch.

Opening and saving a File

With Aspose.Cells for Python via .NET, it is simple to open, save and mange Excel files.

from aspose.cells import Workbook
from datetime import datetime


dataDir = "./"
#  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("dest.xlsx")

Advance topics

• Different Ways to Open Files
• Filter Defined Names while loading Workbook
• Filter Objects while loading Workbook or Worksheet
• Filtering the kind of data while loading the workbook from template file
• Load Source Excel File Without Charts
• Load Workbook with specified Printer Paper Size
• Opening Different Microsoft Excel Versions Files
• Opening Files with Different Formats
• Optimizing Memory Usage while Working with Big Files having Large Datasets
• Read Numbers Spreadsheet Developed by Apple Inc. using Aspose.Cells