首先按行然后按列填充数据
Contents
[
Hide
]
通过首先按行然后按列填充电子表格来提高整体性能。
将数据放入顺序A1,B1,A2,B2比A1,A2,B1,B2更快。如果工作表中有许多单元格,并且按行填充数据,这个提示可以使程序运行速度更快。
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 | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Create a workbook | |
Workbook workbook = new Workbook(); | |
// Populate Data into Cells | |
Cells cells = workbook.Worksheets[0].Cells; | |
cells["A1"].PutValue("data1"); | |
cells["B1"].PutValue("data2"); | |
cells["A2"].PutValue("data3"); | |
cells["B2"].PutValue("data4"); | |
// Save workbook | |
workbook.Save(dataDir + "output_out.xlsx"); |