فتح الملفات في جايثون
Contents
[
Hide
]
Aspose.Cells - فتح الملفات
لإلحاق المستندات باستخدام Aspose.Cells Java for Jython. هنا يمكنك رؤية رمز المثال.
رمز Jython
from aspose-cells import Settings
from com.aspose.cells import Workbook
from com.aspose.cells import FileFormatType
from com.aspose.cells import LoadOptions
from java.io import FileInputStream
class OpeningFiles:
def __init__(self):
dataDir = Settings.dataDir + 'WorkingWithFiles/OpeningFiles/'
fileFormatType = FileFormatType
# 1. Opening from path
# Creatin an Workbook object with an Excel file path
workbook1 = Workbook(dataDir + "Book1.xls")
print "Workbook opened using path successfully.";
# 2 Opening workbook from stream
#Create a Stream object
fstream = FileInputStream(dataDir + "Book2.xls")
#Creating an Workbook object with the stream object
workbook2 = Workbook(fstream)
fstream.close()
print ("Workbook opened using stream successfully.");
# 3.
# Opening Microsoft Excel 97 Files
#Createing and EXCEL_97_TO_2003 LoadOptions object
loadOptions1 = LoadOptions(fileFormatType.EXCEL_97_TO_2003)
#Creating an Workbook object with excel 97 file path and the loadOptions object
workbook3 = Workbook(dataDir + "Book_Excel97_2003.xls", loadOptions1)
# Print message
print("Excel 97 Workbook opened successfully.");
# 4.
# Opening Microsoft Excel 2007 XLSX Files
#Createing and XLSX LoadOptions object
loadOptions2 = LoadOptions(fileFormatType.XLSX)
#Creating an Workbook object with 2007 xlsx file path and the loadOptions object
workbook4 = Workbook(dataDir + "Book_Excel2007.xlsx", loadOptions2)
# Print message
print ("Excel 2007 Workbook opened successfully.")
# 5.
# Opening SpreadsheetML Files
#Creating and EXCEL_2003_XML LoadOptions object
loadOptions3 = LoadOptions(fileFormatType.EXCEL_2003_XML)
#Creating an Workbook object with SpreadsheetML file path and the loadOptions object
workbook5 = Workbook(dataDir + "Book3.xml", loadOptions3)
# Print message
print ("SpreadSheetML format workbook has been opened successfully.");
# 6.
# Opening CSV Files
#Creating and CSV LoadOptions object
loadOptions4 = LoadOptions(fileFormatType.CSV)
#Creating an Workbook object with CSV file path and the loadOptions object
workbook6 = Workbook(dataDir + "Book_CSV.csv", loadOptions4)
# Print message
print ("CSV format workbook has been opened successfully.")
# 7.
# Opening Tab Delimited Files
# Creating and TAB_DELIMITED LoadOptions object
loadOptions5 = LoadOptions(fileFormatType.TAB_DELIMITED);
# Creating an Workbook object with Tab Delimited text file path and the loadOptions object
workbook7 = Workbook(dataDir + "Book1TabDelimited.txt", loadOptions5)
# Print message
print("<br />");
print ("Tab Delimited workbook has been opened successfully.");
# 8.
# Opening Encrypted Excel Files
# Creating and EXCEL_97_TO_2003 LoadOptions object
loadOptions6 = LoadOptions(fileFormatType.EXCEL_97_TO_2003)
# Setting the password for the encrypted Excel file
loadOptions6.setPassword("1234")
# Creating an Workbook object with file path and the loadOptions object
workbook8 = Workbook(dataDir + "encryptedBook.xls", loadOptions6)
# Print message
print("<br />");
print ("Encrypted workbook has been opened successfully.");
if __name__ == '__main__':
OpeningFiles()
تحميل رمز التشغيل
قم بتنزيل مستندات الإضافة (Aspose.Cells) من أي من المواقع الاجتماعية للترميز الواردة أدناه: