更改行或列的字体和颜色

更改列的字体和颜色

要使用Aspose.Cells.GridDesktop更改列的字体和颜色,请按照以下步骤操作:

  • 访问任何所需的工作表
  • 访问要更改其字体和颜色的
  • 创建自定义的字体
  • 字体设置为自定义的字体
  • 最后,将字体颜色设置为任意所需的颜色
 //Accessing the worksheet of the Grid that is currently active

Worksheet sheet = gridDesktop1.GetActiveWorksheet();

//Accessing the first column of the worksheet

GridColumn column = sheet.Columns[0];

//Creating a customized Font object

Font font = new Font("Arial", 10, FontStyle.Bold);

//Setting the font of the column to the customized Font object

column.SetFont(font);

//Setting the font color of the column to Blue

column.SetFontColor(Color.Blue);

更改行的字体和颜色

  • 访问任何所需的工作表
  • 访问要更改其字体和颜色的
  • 创建自定义的字体
  • 字体设置为自定义的字体
  • 最后,将字体颜色设置为任意所需的颜色
 //Accessing the worksheet of the Grid that is currently active

Worksheet sheet = gridDesktop1.GetActiveWorksheet();

//Accessing the first row of the worksheet

GridRow row = sheet.Rows[0];

//Creating a customized Font object

Font font = new Font("Arial", 10, FontStyle.Underline);

//Setting the font of the column to the customized Font object

row.SetFont(font);

//Setting the font color of the column to Green

row.SetFontColor(Color.Green);