格式化单元格

介绍

Aspose.Cells 提供了获取样式和设置样式的方法Cell类，用于获取/设置单元格的格式样式。 Aspose.Cells还提供了风格班级。

使用 GetStyle 和 SetStyle 方法格式化 Cells

在单元格上应用不同类型的格式样式以设置背景或前景色、边框、字体、水平和垂直对齐方式、缩进级别、文本方向、旋转角度等等。

使用 GetStyle 和 SetStyle 方法

如果开发人员需要对不同的单元格应用不同的格式样式，那么最好获取风格细胞使用Cell.GetStyle方法，指定样式属性，然后使用Cell.SetStyle方法。下面给出了一个示例来演示这种在单元格上应用各种格式的方法。

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

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Obtaining the reference of the first worksheet
Worksheet worksheet = workbook.Worksheets[0];

// Accessing the "A1" cell from the worksheet
Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Defining a Style object
Aspose.Cells.Style style;

// Get the style from A1 cell
style = cell.GetStyle();

// Setting the vertical alignment
style.VerticalAlignment = TextAlignmentType.Center;

// Setting the horizontal alignment
style.HorizontalAlignment = TextAlignmentType.Center;

// Setting the font color of the text
style.Font.Color = Color.Green;

// Setting to shrink according to the text contained in it
style.ShrinkToFit = true;

// Setting the bottom border color to red
style.Borders[BorderType.BottomBorder].Color = Color.Red;

// Setting the bottom border type to medium
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Medium;

// Applying the style to A1 cell
cell.SetStyle(style);

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

使用样式对象格式化不同 Cells

如果开发人员需要将相同的格式样式应用于不同的单元格，那么他们可以使用风格目的。请按照以下步骤使用风格目的：

1. 添加一个风格通过调用对象创建样式的方法工作簿班级
2. 访问新添加的风格目的
3. 设置所需的属性/属性风格对象以应用所需的格式设置
4. 分配配置的风格反对你想要的细胞

这种方法可以大大提高应用程序的效率并节省内存。

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

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the first worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");
           
// Adding a new Style
Style style = workbook.CreateStyle();

// Setting the vertical alignment of the text in the "A1" cell
style.VerticalAlignment = TextAlignmentType.Center;

// Setting the horizontal alignment of the text in the "A1" cell
style.HorizontalAlignment = TextAlignmentType.Center;

// Setting the font color of the text in the "A1" cell
style.Font.Color = Color.Green;

// Shrinking the text to fit in the cell
style.ShrinkToFit = true;

// Setting the bottom border color of the cell to red
style.Borders[BorderType.BottomBorder].Color = Color.Red;

// Setting the bottom border type of the cell to medium
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Medium;

// Assigning the Style object to the "A1" cell
cell.SetStyle(style);


// Apply the same style to some other cells
worksheet.Cells["B1"].SetStyle(style);
worksheet.Cells["C1"].SetStyle(style);
worksheet.Cells["D1"].SetStyle(style);


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

使用 Microsoft Excel 2007 预定义样式

如果您需要为 Microsoft Excel 2007 应用不同的格式样式，请使用 Aspose.Cells API 应用样式。下面给出一个示例来演示这种在单元格上应用预定义样式的方法。

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

// Instantiate a new Workbook.
Workbook workbook = new Workbook();

// Create a style object .
Style style = workbook.CreateStyle();

// Input a value to A1 cell.
workbook.Worksheets[0].Cells["A1"].PutValue("Test");

// Apply the style to the cell.
workbook.Worksheets[0].Cells["A1"].SetStyle(style);

// Save the Excel 2007 file.
workbook.Save(dataDir + "book1.out.xlsx");

格式化 Cell 中的选定字符

处理字体设置解释了如何格式化单元格中的文本，但它只解释了如何格式化所有单元格内容。如果您只想格式化选定的字符怎么办？

Aspose.Cells 也支持此功能。本主题说明我们如何有效地使用此功能。

格式化所选字符

Aspose.Cells提供了一个类，工作簿表示 Microsoft Excel 文件。这工作簿类包含工作表允许访问 Excel 文件中每个工作表的集合。工作表由工作表班级。这工作表类提供了Cells收藏。中的每一项Cells集合代表一个对象Cell班级。

这Cell类提供了人物方法采用以下参数来选择单元格内的一系列字符：

• 起始索引，选择开始的字符的索引。
• 字符数要选择的字符数。

这人物方法返回一个实例字体设置允许开发人员以与单元格相同的方式设置字符格式的类，如下面的代码示例所示。在输出文件中，在 A1 单元格中，单词“Visit”的格式将使用默认字体但“Aspose！”是粗体和蓝色。

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

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Obtaining the reference of the first(default) worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];

// Accessing the "A1" cell from the worksheet
Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Visit Aspose!");

// Setting the font of selected characters to bold
cell.Characters(6, 7).Font.IsBold = true;

// Setting the font color of selected characters to blue
cell.Characters(6, 7).Font.Color = Color.Blue;

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

如果您对单元格中的部分富文本格式感兴趣，请考虑使用Cell.GetCharacters & Cell.SetCharacters方法。这[Cell.GetCharacters]方法将用于访问文本的部分，然后可以使用Cell.SetCharacters方法而得到方法返回一个数组字体设置可以操作以设置各种属性的对象，例如字体名称、字体颜色、粗体等，以及放方法可用于应用更改。

格式化行和列

有时，开发人员需要对行或列应用相同的格式。一个一个地对单元格应用格式通常需要更长的时间，这不是一个好的解决方案。 针对这个问题，Aspose.Cells提供了一种简单、快速的方法，本文详细讨论。

格式化行和列

Aspose.Cells提供了一个类，工作簿表示 Microsoft Excel 文件。这工作簿类包含一个工作表允许访问 Excel 文件中每个工作表的集合。工作表由工作表班级。这工作表类提供了Cells收藏。这Cells集合提供了行数收藏。

格式化一行

中的每一项行数集合代表一个排目的。这排对象提供了应用样式用于设置行格式的方法。要对一行应用相同的格式，请使用风格目的。下面的步骤显示了如何使用它。

1. 添加一个风格反对工作簿通过调用它的类创建样式方法。
2. 设置风格对象的属性以应用格式设置。
3. 将相关属性设置为ON风格旗帜目的。
4. 分配配置的风格反对排目的。

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

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Obtaining the reference of the first (default) worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];

// Adding a new Style to the styles
Style style = workbook.CreateStyle();

// Setting the vertical alignment of the text in the "A1" cell
style.VerticalAlignment = TextAlignmentType.Center;

// Setting the horizontal alignment of the text in the "A1" cell
style.HorizontalAlignment = TextAlignmentType.Center;

// Setting the font color of the text in the "A1" cell
style.Font.Color = Color.Green;

// Shrinking the text to fit in the cell
style.ShrinkToFit = true;

// Setting the bottom border color of the cell to red
style.Borders[BorderType.BottomBorder].Color = Color.Red;

// Setting the bottom border type of the cell to medium
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Medium;

// Creating StyleFlag
StyleFlag styleFlag = new StyleFlag();
styleFlag.HorizontalAlignment = true;
styleFlag.VerticalAlignment = true;
styleFlag.ShrinkToFit = true;
styleFlag.Borders = true;
styleFlag.FontColor = true;

// Accessing a row from the Rows collection
Row row = worksheet.Cells.Rows[0];

// Assigning the Style object to the Style property of the row
row.ApplyStyle(style, styleFlag);

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

格式化列

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

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Obtaining the reference of the first (default) worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];           

// Adding a new Style to the styles
Style style = workbook.CreateStyle();

// Setting the vertical alignment of the text in the "A1" cell
style.VerticalAlignment = TextAlignmentType.Center;

// Setting the horizontal alignment of the text in the "A1" cell
style.HorizontalAlignment = TextAlignmentType.Center;

// Setting the font color of the text in the "A1" cell
style.Font.Color = Color.Green;

// Shrinking the text to fit in the cell
style.ShrinkToFit = true;

// Setting the bottom border color of the cell to red
style.Borders[BorderType.BottomBorder].Color = Color.Red;

// Setting the bottom border type of the cell to medium
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Medium;

// Creating StyleFlag
StyleFlag styleFlag = new StyleFlag();
styleFlag.HorizontalAlignment = true;
styleFlag.VerticalAlignment = true;
styleFlag.ShrinkToFit = true;
styleFlag.Borders = true;
styleFlag.FontColor = true;

// Accessing a column from the Columns collection
Column column = worksheet.Cells.Columns[0];

// Applying the style to the column
column.ApplyStyle(style, styleFlag);

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

推进主题

• 对齐设置
• 边框设置
• 设置 Excel 和 ODS 文件的条件格式。
• Excel 主题和颜色
• 填充设置
• 字体设置
• 在工作簿中格式化工作表 Cells
• 实施 1904 日期系统
• 合并和取消合并 Cells
• 号码设置
• 获取和设置单元格样式