格式化行和列

使用电子表格并将数据添加到行或列时，您可能需要更改行高或列宽。有时，对行或列应用格式意味着当前的高度或宽度需要更改才能显示数据。通常，用户使用 Microsoft Excel 在所见即所得的环境中调整行高和列宽。但是，使用 Aspose.Cells 开发人员可以在运行时执行这些操作。

使用行

调整行高

Aspose.Cells提供了一个类，工作簿，代表一个 Microsoft Excel 文件。这工作簿类包含一个工作表集合允许访问 Excel 文件中的每个工作表。工作表由工作表班级。这工作表类提供了Cells代表工作表中所有单元格的集合。

这Cellscollection 提供了多种方法来管理工作表中的行或列。下面将更详细地讨论其中的一些。

设置行高

可以通过调用来设置单行的高度Cells收藏的设置行高方法。这设置行高方法采用以下参数，如下所示：

• 行索引，您要更改其高度的行的索引。
• 行高应用于行的行高。

// 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);

// Creating a file stream containing the Excel file to be opened
FileStream fstream = new FileStream(dataDir + "book1.xls", FileMode.Open);

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

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

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

// Saving the modified Excel file
workbook.Save(dataDir + "output.out.xls");

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

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

如果开发人员需要为工作表中的所有行设置相同的行高，他们可以使用标准身高的财产Cells收藏。

例子：

// 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);

// Creating a file stream containing the Excel file to be opened
FileStream fstream = new FileStream(dataDir + "book1.xls", FileMode.Open);

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

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Setting the height of all rows in the worksheet to 15
worksheet.Cells.StandardHeight = 15;

// Saving the modified Excel file
workbook.Save(dataDir + "output.out.xls");

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

使用列

设置列宽

通过调用设置列的宽度Cells收藏的设置列宽方法。这设置列宽方法采用以下参数：

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

// 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);

// Creating a file stream containing the Excel file to be opened
FileStream fstream = new FileStream(dataDir + "book1.xls", FileMode.Open);

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

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

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

// Saving the modified Excel file
workbook.Save(dataDir + "output.out.xls");

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

以像素为单位设置列宽

通过调用设置列的宽度Cells收藏的设置列宽像素方法。这设置列宽像素方法采用以下参数：

• 列索引，您要更改其宽度的列的索引。
• 列宽所需的列宽（以像素为单位）。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
string outDir = RunExamples.Get_OutputDirectory();

//Load source Excel file
Workbook workbook = new Workbook(sourceDir + "Book1.xlsx");

//Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];

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

workbook.Save(outDir + "SetColumnWidthInPixels_Out.xlsx");

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

要为工作表中的所有列设置相同的列宽，请使用Cells收藏的标准宽度财产。

// 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 directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
    System.IO.Directory.CreateDirectory(dataDir);

// Creating a file stream containing the Excel file to be opened
FileStream fstream = new FileStream(dataDir + "book1.xls", FileMode.Open);

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

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Setting the width of all columns in the worksheet to 20.5
worksheet.Cells.StandardWidth = 20.5;

// Saving the modified Excel file
workbook.Save(dataDir + "output.out.xls");

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

推进主题

• 自动调整行和列
• 使用 Aspose.Cells 将文本转换为列
• 复制行和列
• 删除工作表中的空白行和列
• 分组和取消分组行和列
• 隐藏和显示行和列
• 在 Excel 工作表中插入或删除行
• 插入和删除Excel文件的行和列
• 删除工作表中的重复行
• 更新其他工作表中的引用，同时删除工作表中的空白列和行