加载和管理Excel、OpenOffice、Json、Csv和Html文件
Contents
[
Hide
]
使用 Aspose.Cells for Python via .NET，方便创建、打开和管理 Excel 文件，例如提取数据，或使用设计模板加快开发流程。
创建新工作簿
以下示例从头开始创建一个新工作簿。
This file contains hidden or 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") |
打开和保存文件
使用 Aspose.Cells for Python via .NET，可以简单地打开、保存和管理 Excel 文件。
This file contains hidden or 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") |