Different Ways to Open Files
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 | |
# 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(".") | |
# 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 | |
# 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(".") | |
# 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 | |
# 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(".") | |
# 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!") |