Subscript and superscript are commonly used when dealing with Excel files. Spire.XLS specially designed for developers enables you to apply subscript and superscript in Excel file easily. In this article, a solution is introduced to show how to apply subscript and superscript in Excel file using Spire.XLS.
Step 1: Set the rtf value of "B3" to "R100-0.06"
CellRange range = sheet.Range["B3"]; range.RichText.Text = "R100-0.06";
Step 2: Create a font. Set the IsSubscript property of the font to "true". This font can be used to apply subscript.
ExcelFont font = workbook.CreateFont(); font.IsSubscript = true;
Step 3: Set font for specified range of the text in "B3". In this example, "-0.06" will be formatted as subscript.
range.RichText.SetFont(4, 8, font);
Step 4: Set the rtf value of "D3" to "a2 + b2 = c2".
range = sheet.Range["D3"]; range.RichText.Text = "a2 + b2 = c2";
Step 5: Create a font. Set the IsSuperscript property of the font to "true". This font can be used to apply superscript.
font = workbook.CreateFont(); font.IsSuperscript = true;
Step 6: Set font for specified range of the text in "D3". In this example, "2" will be formatted as superscript.
range.RichText.SetFont(5, 8, font);
Full code and screenshots:
using Spire.Xls;
using System.Drawing;
namespace ApplySubscriptandSuperscript
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.Range["B2"].Text = "This is an example of Subscript:";
sheet.Range["D2"].Text = "This is an example of Superscript:";
CellRange range = sheet.Range["B3"];
range.RichText.Text = "R100-0.06";
ExcelFont font = workbook.CreateFont();
font.IsSubscript = true;
font.Color = Color.Green;
range.RichText.SetFont(4, 8, font);
range = sheet.Range["D3"];
range.RichText.Text = "a2 + b2 = c2";
font = workbook.CreateFont();
font.IsSuperscript = true;
range.RichText.SetFont(1, 1, font);
range.RichText.SetFont(6, 6, font);
range.RichText.SetFont(11, 11, font);
sheet.AllocatedRange.AutoFitColumns();
workbook.SaveToFile("result.xls");
}
}
