Apply Superscript and Subscript Effects on Fonts

Working with Superscript and Subscript

Apply the superscript effect by setting the Style.Font object’s IsSuperscript property to true. To apply subscript, set the Style.Font object’s IsSubscript property to true.

The following code examples show how to apply super and subscript to text.

C# code to Apply Superscript effect on text

// 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# code to Apply Subscript effect on text

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