在字体上应用上标和下标效果
Contents
[
Hide
]
Aspose.Cells提供将文本应用上标(文本位于基线上方)和下标(文本位于基线下方)效果的功能。
处理上标和下标
通过将Style.Font对象的IsSuperscript属性设置为true来应用上标效果。要应用下标效果,将Style.Font对象的IsSubscript属性设置为true。
以下代码示例展示了如何将上标和下标应用于文本。
C#代码将文本应用上标效果
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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#代码在文本上应用下标效果
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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); |