修改现有风格

使用Microsoft Excel

更新Microsoft Excel 97-2003中的样式:

  1. 单击格式菜单上的样式
  2. 样式名称列表中选择要修改的样式。
  3. 单击修改
  4. 使用格式单元格对话框中的选项卡选择要使用的样式选项。
  5. 点击确定
  6. 样式包括下,指定您想要的样式特征。
  7. 单击确定以保存样式并将其应用于所选范围。

使用Aspose.Cells

以下示例演示了如何使用Style.Update方法。

创建和修改样式

该示例创建Style对象,将其应用于一系列单元格,并修改Style对象。所做的修改会自动应用于应用该样式的单元格和范围。

// 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 a workbook.
Workbook workbook = new Workbook();
// Create a new style object.
Style style = workbook.CreateStyle();
// Set the number format.
style.Number = 14;
// Set the font color to red color.
style.Font.Color = System.Drawing.Color.Red;
// Name the style.
style.Name = "Date1";
// Get the first worksheet cells.
Cells cells = workbook.Worksheets[0].Cells;
// Specify the style (described above) to A1 cell.
cells["A1"].SetStyle(style);
// Create a range (B1:D1).
Range range = cells.CreateRange("B1", "D1");
// Initialize styleflag object.
StyleFlag flag = new StyleFlag();
// Set all formatting attributes on.
flag.All = true;
// Apply the style (described above)to the range.
range.ApplyStyle(style, flag);
// Modify the style (described above) and change the font color from red to black.
style.Font.Color = System.Drawing.Color.Black;
// Done! Since the named style (described above) has been set to a cell and range,
// The change would be Reflected(new modification is implemented) to cell(A1) and // Range (B1:D1).
style.Update();
// Save the excel file.
workbook.Save(dataDir+ "book_styles.out.xls");

修改现有样式

此示例使用一个简单的模板Excel文件,其中已经应用了一个名为“Percent”的样式到一个范围中。该示例:

  1. 获取样式,
  2. 创建一个样式对象,并
  3. 修改样式格式。

修改将自动应用于应用了样式的范围。

// 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 a workbook.
* Open a template file.
* In the book1.xls file, we have applied Ms Excel's
* Named style i.e., "Percent" to the range "A1:C8".
*/
Workbook workbook = new Workbook(dataDir+ "book1.xlsx");
// We get the Percent style and create a style object.
Style style = workbook.GetNamedStyle("Percent");
// Change the number format to "0.00%".
style.Number = 11;
// Set the font color.
style.Font.Color = System.Drawing.Color.Red;
// Update the style. so, the style of range "A1:C8" will be changed too.
style.Update();
// Save the excel file.
workbook.Save(dataDir+ "book2.out.xlsx");