C# .NET API to Create & Convert Excel Spreadsheets

Getting Started with Aspose.Cells for Python via .NET

Aspose.Cells for Python via .NET is distributed as a ZIP archive. You need to have Python 3.6 or higher versions to be installed. You can easily use Aspose.Cells for Python via .NET from pypi with the following command.

 $ pip install aspose-cells-python 

Excel Spreadsheet Creation via Python API

Aspose.Cells for Python via .NET has included complete support for Microsoft Excel Spreadsheet creation and management using Python commands. The library has included several important features for simple or complex spreadsheets creation and management, such as adding new worksheet to existing workbook, creating shared worksheets, Copy and Move Worksheets, add images and charts to worksheets, important text to spreadsheet, replace text inside worksheets, managing document properties, adding styles for content formatting, merging rows and columns, and many more.

import aspose.cells
from aspose.cells import Workbook

# Create an instance of the Workbook class.
workbook = Workbook()

# Insert the words Hello World! into a cell accessed.
workbook.worksheets.get(0).cells.get("A1").put_value("Hello World")

# Save as XLS file
workbook.save("output.xls")

# Save as XLSX file
workbook.save("output.xlsx")

# Save as ods file
workbook.save("output.ods")

Protect Excel Spreadsheet via Python API

Aspose.Cells for Python via .NET provides complete capability for protecting and unprotecting their Excel spreadsheet documents inside their own Python applications. The library enables software developers from preventing others from accessing data in Excel files, protecting Excel file with a password, preventing viewing hidden worksheets, protecting structure of your Excel workbook with a password, locking the entireExcel worksheet from accidentally or deliberately changing, moving, or deleting data in a worksheet and so on.

import aspose.cells
from aspose.cells import Workbook, LoadOptions, LoadFormat

# The path to the documents directory.
dataDir = ""

# Opening Microsoft Excel 2007 Xlsx Files
loadOptions = LoadOptions(LoadFormat.XLSX)

# Specify the password
loadOptions.password = "1234"

# Create a Workbook object and opening the file from its path
wbEncrypted = Workbook(dataDir + "EncryptedExcel.xlsx", loadOptions)
print("Encrypted excel file opened successfully!")

Use Formulas to Process Data via Python API

Aspose.Cells for Python via .NET has included the capability to process data with formulas and functions. The library has provided a large set of built-in functions and formulas that enables software developers to compute complex calculations with ease. The library supports a huge set of mathematical, string, Boolean, date/time, statistical, database, lookup and reference formulas. Moreover, it also possible to add user defined formulas that users want to include as an excel add-in. You can also use an array formula or add an R1C1 reference style formula to a cell inside your Python applications.

Excel Spreadsheet Conversion via Python API

Aspose.Cells for Python via .NET API is a very useful tool for converting Excel Spreadsheet to other supported file formats inside Python applications. There are several important features part of the library such as xporting spreadsheets to Markdown format , converting Excel Spreadsheet to PDF, Workbook to XPS, converting Excel files to OpenOffice & LibreOffice Calc, Excel workbook to MHTML, converting a workbook to JSON, Excel to TIFF and many more.  

import aspose.cells
from aspose.cells import Workbook,SaveFormat
 
#load file to be converted
wk = Workbook("Book.xlsx");

#Convert XLS to PDF, XPS and HTML
wk.save("output.pdf", SaveFormat.PDF);

wk.save("output.xps", SaveFormat.XPS);

wk.save("houtput.html", SaveFormat.HTML);