如何使用OpenXml使单元格中的文本变为粗体 [英] How To make some text bold in cell using OpenXml
问题描述
我尝试使用粗体显示特定文本
i have try to make bold the specific text using
Bold fbld = new Bold();
但是它将使霍尔单元格变粗.
but it will make bold hall cell.
上图中的单元格中有一些粗体文本.
Here in above image there is some bold text into the cell.
如何使用C#在OpenXml中做到这一点?
How can I do this in OpenXml using C#?
推荐答案
对于不同样式的文本,您需要使用单独的Run
元素.您可以通过创建RunProperties
元素并向其中添加Bold
元素来添加粗体.
You need to use separate Run
elements for the differently styled pieces of text. You can add the bold by creating a RunProperties
element and adding a Bold
element to that.
以下代码将在没有行的现有电子表格上运行(请注意,我没有添加用于合并的代码,因为这只会增加复杂性-如果您需要帮助,请参阅
The following code will work on an existing spreadsheet that has no rows (note I haven't added the code for merging as that just adds complication - if you need help with that then please see my answer here)
using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(filename, true))
{
WorkbookPart workBookPart = spreadsheetDocument.WorkbookPart;
WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();
SheetData sheetData = worksheetPart.Worksheet.Elements<SheetData>().First();
//create a row
Row row1 = new Row() { RowIndex = 1U };
//create a new inline string cell
Cell cell = new Cell() { CellReference = "A1" };
cell.DataType = CellValues.InlineString;
//create a run for the bold text
Run run1 = new Run();
run1.Append(new Text("ABC"));
//create runproperties and append a "Bold" to them
RunProperties run1Properties = new RunProperties();
run1Properties.Append(new Bold());
//set the first runs RunProperties to the RunProperties containing the bold
run1.RunProperties = run1Properties;
//create a second run for the non-bod text
Run run2 = new Run();
run2.Append(new Text(Environment.NewLine + "XYZ") { Space = SpaceProcessingModeValues.Preserve });
//create a new inline string and append both runs
InlineString inlineString = new InlineString();
inlineString.Append(run1);
inlineString.Append(run2);
//append the inlineString to the cell.
cell.Append(inlineString);
//append the cell to the row
row1.Append(cell);
sheetData.Append(row1);
}
这篇关于如何使用OpenXml使单元格中的文本变为粗体的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!