Teckensnittsinställningar

Utseendet och känslan av en text kan styras genom att ändra teckensnittsinställningar. Teckensnittsinställningarna kan inkludera namn, stil, storlek, färg och andra effekter av typsnitten. Precis som Microsoft Excel, stöder Aspose.Cells också konfigurering av teckensnittsinställningarna för cellerna.

Konfigurera teckensnittsinställningar

Aspose.Cells tillhandahåller en klass,Arbetsbok som representerar en Microsoft Excel-fil. DeArbetsbok klass innehåller enArbetsblad samling som ger åtkomst till varje kalkylblad i en Excel-fil. Ett arbetsblad representeras avArbetsblad klass. DeArbetsblad klass ger enCells samling. Varje objekt iCells samlingen representerar ett föremål förCellklass.

Aspose.Cells tillhandahållerCell klass'GetStyle ochSetStyle metoder som används för att hämta och ställa in en cells formateringsstil. DeStilclass tillhandahåller egenskaper för att konfigurera teckensnittsinställningar.

Ställa in teckensnittsnamn

Utvecklare kan använda vilket typsnitt som helst på text inuti en cell genom att användaStyle.Font föremålnamnfast egendom.

// 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
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font name to "Times New Roman"
style.Font.Name = "Times New Roman";

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "book1.out.xls", SaveFormat.Excel97To2003);

Ställ in teckensnitt till fet stil

Utvecklare kan göra text fet genom att ställa inStyle.Font föremålIsBold egendom tillSann.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font weight to bold
style.Font.IsBold = true;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save("out.xlsx");

Ställa in teckensnittsstorlek

Ställ in teckenstorleken medStyle.FontföremålStorlekfast egendom.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font size to 14
style.Font.Size = 14;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save("out.xlsx");

Ställa in teckensnittsfärg

AnvändStyle.Font föremålFärgegenskap för att ställa in teckensnittsfärgen. Välj valfri färg från färguppräkningen (en del av ramverket .NET) och tilldela den tillFärgfast egendom.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font color to blue
style.Font.Color = Color.Blue;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save("out.xlsx");
            

Ställa in typsnitt understruken typ

AnvändStyle.FontföremålUnderstrykningegenskap för att understryka text. Aspose.Cells erbjuder olika fördefinierade teckensnittsunderstrykningstyper iFontUnderlineType uppräkning.

Typer av understrykning av teckensnitt	Beskrivning
Bokföring	En enda redovisningsunderstrykning
Dubbel	Dubbel understrykning
Dubbelredovisning	Dubbel redovisningsunderstrykning
Ingen	Ingen understrykning
Enda	En enda understrykning

// 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
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font to be underlined
style.Font.Underline = FontUnderlineType.Single;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "out.xlsx");

Ställa in överstruken effekt

Använd genomstruken genom att ställa inStyle.Font föremålIsStrikeoutegendom tillSann.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the strike out effect on the font
style.Font.IsStrikeout = true;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "out.xlsx");

Ställa in Subscript Effect

Använd prenumeration genom att ställa inStyle.FontföremålIsSubScript egendom tillSann.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting subscript effect
style.Font.IsSubscript = true;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "out.xlsx");

Ställa in upphöjd effekt på teckensnitt

Utvecklare kan tillämpa den upphöjda effekten på teckensnittet genom att ställa inIsSuperscript egendom avStyle.Font protestera motSann.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting superscript effect
style.Font.IsSuperscript = true;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "out.xlsx");

Förhandsämnen

• Använd upphöjda och nedsänkta effekter på teckensnitt
• Få en lista över teckensnitt som används i ett kalkylblad eller en arbetsbok