Different Ways to Open Files

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

How to Open an Excel File via a Path

Developers can open a Microsoft Excel file using its file path on the local computer by specifying it in the Workbook class constructor. Simply pass the path in the constructor as a string. Aspose.Cells for Python via .NET will automatically detect the file format type.

from aspose.cells import Workbook


#  The path to the documents directory.
dataDir = "./"
#  Opening through Path
#  Creating a Workbook object and opening an Excel file using its file path
workbook1 = Workbook(dataDir + "Book1.xlsx")
print("Workbook opened using path successfully!")

How to Open an Excel File via a Stream

It is also simple to open an Excel file as a stream. To do so, use an overloaded version of the constructor that takes the Stream object that contains the file.

from aspose.cells import Workbook


#  The path to the documents directory.
dataDir = "./"
#  Opening through Stream
#  Create a Stream object
fstream = open(dataDir + "Book2.xls", "rb")
#  Creating a Workbook object, open the file from a Stream object
#  That contains the content of file and it should support seeking
workbook2 = Workbook(fstream)
print("Workbook opened using stream successfully!")
fstream.close()

How to Open a File with Data only

To open a file with data only, use the LoadOptions and LoadFilter classes to set the related attribute and options of the classes for the template file to be loaded.

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


#  The path to the documents directory.
dataDir = "./"
#  Load only specific sheets with data and formulas
#  Other objects, items etc. would be discarded
#  Instantiate LoadOptions specified by the LoadFormat
loadOptions = LoadOptions(LoadFormat.XLSX)
#  Set LoadFilter property to load only data & cell formatting
loadOptions.load_filter = LoadFilter(LoadDataFilterOptions.CELL_DATA)
#  Create a Workbook object and opening the file from its path
book = Workbook(dataDir + "Book1.xlsx", loadOptions)
print("File data imported successfully!")