添加或插入工作表
Contents
[
Hide
]
在这个主题中，我们将讨论使用Aspose.Cells.GridDesktop在Excel文件中添加或插入工作表的技术。添加和插入工作表的区别在于，添加工作表是简单地在Excel文件的工作表集合的末尾添加一个工作表，但插入意味着将工作表添加到工作表集合中的特定位置。
添加工作表
要使用Aspose.Cells.GridDesktop添加工作表，请按照以下步骤进行：
- 将Aspose.Cells.GridDesktop控件添加到表单中。
- 在GridDesktop控件中调用工作表集合的Add方法。
This file contains 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
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Adding a worksheet to the Grid | |
| int i = gridDesktop1.Worksheets.Add(); | |
| Worksheet sheet = gridDesktop1.Worksheets[i]; |
Add方法有多个重载版本。例如，使用上述重载版本，可以向Excel文件添加具有默认工作表名称的工作表。使用Add方法的其他重载版本，可以像以下示例中所示定义工作表名称。
This file contains 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
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Adding a worksheet to the Grid with a specific name | |
| Worksheet sheet1 = gridDesktop1.Worksheets.Add("AddWorksheetWithName"); |
插入工作表
要使用Aspose.Cells.GridDesktop插入工作表，请按照以下步骤进行：
- 在表单中添加 Aspose.Cells.GridDesktop 控件。
- 在GridDesktop控件中调用工作表集合的Insert方法。
This file contains 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
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Inserting a worksheet to Grid at first position of the worksheets collection | |
| gridDesktop1.Worksheets.Insert(0); |
重要提示：Microsoft Excel（97-2003 XLS）支持最多拥有65,536行和256列的Excel工作表。Aspose.Cells.GridDesktop遵循相同的标准。在Aspose.Cells.GridDesktop控件中，开发人员可以添加或插入拥有超过标准限制的行和列的工作表，但当他们尝试将网格数据保存至Excel文件时，将会引发异常。这意味着只有包含在65,536行和256列中的数据可以使用Aspose.Cells.GridDesktop保存至Excel XLS文件，如果使用XLSX（MS Excel 2007/2010）文件格式，则没有此限制。