首先按行然后按列填充数据

Contents
[ ]

将数据放入顺序A1,B1,A2,B2比A1,A2,B1,B2更快。如果工作表中有许多单元格,并且按行填充数据,这个提示可以使程序运行速度更快。

const AsposeCells = require("aspose.cells.node");
const path = require("path");
// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
// Create a workbook
let workbook = new AsposeCells.Workbook();
// Populate Data into Cells
let cells = workbook.getWorksheets().get(0).getCells();
cells.get("A1").putValue("data1");
cells.get("B1").putValue("data2");
cells.get("A2").putValue("data3");
cells.get("B2").putValue("data4");
// Save workbook
workbook.save(path.join(dataDir, "output_out.xlsx"));