Loading and managing Excel,OpenOffice,Json, Csv and Html files
Contents
[
Hide
]
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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") |
Opening and saving a File
With Aspose.Cells for Python via .NET, it is simple to open, save and mange Excel files.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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") |
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