按行和列格式化，使用Node.js via C++

在处理电子表格和向行或列添加数据时，可能需要调整行高或列宽。有时，应用格式意味着需要更改当前的高度或宽度以显示数据。通常，用户在Microsoft Excel中通过直观界面调整行高和列宽。但借助Aspose.Cells，开发者可以在运行时执行这些操作。

处理行

如何调整行高

Aspose.Cells提供一个类，Workbook，代表一个Microsoft Excel文件。Workbook类包含一个WorksheetCollection，可以访问Excel文件中的每个工作表。工作表由Worksheet类表示。Worksheet类提供一个Cells集合，代表工作表中的所有单元格。

Cells集合提供若干方法，用于管理工作表中的行或列。以下是一些详细介绍。

如何设置行的高度

可以通过调用Cells集合的setRowHeight(number, number)方法，设置单个行的高度。该setRowHeight(number, number)方法的参数如下：

行索引，要更改高度的行的索引。
行高，要应用于该行的行高。

try {
const path = require("path");
const fs = require("fs");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "book1.xls");
// Creating a file stream containing the Excel file to be opened
const fstream = fs.createReadStream(filePath);

// Reading the file stream into a buffer
const chunks = [];
fstream.on('data', chunk => chunks.push(chunk));
fstream.on('end', () => {
const buffer = Buffer.concat(chunks);

// Instantiating a Workbook object
// Opening the Excel file through the file stream
const workbook = new AsposeCells.Workbook(buffer);

// Accessing the first worksheet in the Excel file
const worksheet = workbook.getWorksheets().get(0);

// Setting the height of the second row to 13
worksheet.getCells().setRowHeight(1, 13);

// Saving the modified Excel file
workbook.save(path.join(dataDir, "output.out.xls"));

// Closing the file stream to free all resources
fstream.close();

如何设置工作表中所有行的高度

如果开发者需要为工作表中的所有行设置相同的行高，可以通过修改Cells集合的getStandardHeight()属性实现。

示例：

const fs = require("fs");
const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "book1.xls");

// Creating a file stream containing the Excel file to be opened
const fstream = fs.readFileSync(filePath);

// Instantiating a Workbook object
// Opening the Excel file through the file stream
const workbook = new AsposeCells.Workbook(fstream);

// Accessing the first worksheet in the Excel file
const worksheet = workbook.getWorksheets().get(0);

// Setting the height of all rows in the worksheet to 15
worksheet.getCells().setStandardHeight(15);

// Saving the modified Excel file
workbook.save(path.join(dataDir, "output.out.xls"));

// Closing the file stream to free all resources
// (Note: Closing the file stream is unnecessary in this context as it's a 
// synchronous read performed using fs.readFileSync, which does not require
// explicit closure, but if using fs.createReadStream, you would handle it accordingly)

使用列

如何设置列的宽度

通过调用Cells集合的setColumnWidth(number, number)方法来设置列宽。setColumnWidth(number, number)方法接受以下参数：

列索引，要更改其宽度的列的索引。
列宽度，所需的列宽度。

const fs = require("fs");
const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "book1.xls");

// Creating a file stream containing the Excel file to be opened
const fstream = fs.readFileSync(filePath);

// Instantiating a Workbook object
// Opening the Excel file through the file stream
const workbook = new AsposeCells.Workbook(fstream);

// Accessing the first worksheet in the Excel file
const worksheet = workbook.getWorksheets().get(0);

// Setting the width of the second column to 17.5
worksheet.getCells().setColumnWidth(1, 17.5);

// Saving the modified Excel file
workbook.save(path.join(dataDir, "output.out.xls"));

// Closing the file stream to free all resources
fstream; // Note: No explicit close needed for fs.readFileSync

如何以像素设置列宽

通过调用Cells集合的setColumnWidthPixel(number, number)方法来设置列宽。setColumnWidthPixel(number, number)方法接受以下参数：

列索引，要更改其宽度的列的索引。
列宽，以像素为单位的期望列宽。

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// Source directory
const sourceDir = path.join(__dirname, "data");
const outDir = path.join(__dirname, "output");

// Load source Excel file
const workbook = new AsposeCells.Workbook(path.join(sourceDir, "Book1.xlsx"));

// Access first worksheet
const worksheet = workbook.getWorksheets().get(0);

// Set the width of the column in pixels
worksheet.getCells().setColumnWidthPixel(7, 200);

workbook.save(path.join(outDir, "SetColumnWidthInPixels_Out.xlsx"));

如何设置工作表中所有列的宽度

要为工作表中的所有列设置相同的列宽，请使用Cells集合的getStandardWidth()属性。

const path = require("path");
const fs = require("fs");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Creating a file stream containing the Excel file to be opened
const filePath = path.join(dataDir, "book1.xls");

// Instantiating a Workbook object
// Opening the Excel file
const workbook = new AsposeCells.Workbook(filePath);

// Accessing the first worksheet in the Excel file
const worksheet = workbook.getWorksheets().get(0);

// Setting the width of all columns in the worksheet to 20.5
worksheet.getCells().setStandardWidth(20.5);

// Saving the modified Excel file
workbook.save(path.join(dataDir, "output.out.xls"));

// Closing the file stream to free all resources
// No explicit close needed in Node.js

高级主题

使用 Node.js 通过 C++ 管理Microsoft Excel文件的工作表用Node.js通过C++管理范围