在字体上应用上标和下标效果

处理上标和下标

通过将Style.Font对象的IsSuperscript属性设置为true来应用上标效果。要应用下标效果,将Style.Font对象的IsSubscript属性设置为true

以下代码示例展示了如何将上标和下标应用于文本。

C#代码将文本应用上标效果

// 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
workbook.Worksheets.Add();
// Obtaining the reference of the newly added 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("Hello");
// Setting the font Superscript
Style style = cell.GetStyle();
style.Font.IsSuperscript = true;
cell.SetStyle(style);
// Saving the Excel file
workbook.Save(dataDir+ "Superscript.out.xls", SaveFormat.Auto);

用C#代码在文本上应用下标效果

// 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
workbook.Worksheets.Add();
// Obtaining the reference of the newly added 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("Hello");
// Setting the font Subscript
Style style = cell.GetStyle();
style.Font.IsSubscript = true;
cell.SetStyle(style);
// Saving the Excel file
workbook.Save(dataDir+ "Subscript.out.xls", SaveFormat.Auto);