html样式能在excel中生效吗,如何显示HTML样式的文本在Excel单元格中使用的SpreadsheetGear...

的SpreadsheetGear不支持解析和渲染HTML。如果您将这种类型的内容放入单元格中，则会显示原始标记。

的SpreadsheetGear不支持添加富文本(RTF)的细胞，但你需要使用的SpreadsheetGear API使用要做到这一点：

下面的例子将呈现类似这样：

// Create new workbook.

IWorkbook workbook = Factory.GetWorkbook();

IWorksheet worksheet = workbook.ActiveWorksheet;

IRange cells = worksheet.Cells;

// Add text to A1 which we'll format below...

cells["A1"].Value = "This Is My Header\n\nHello World!";

// Format "header" as bold and with a larger font size.

ICharacters charsHeader = cells["A1"].GetCharacters(0, 17);

charsHeader.Font.Bold = true;

charsHeader.Font.Size = 18;

// Format "Hello" text.

ICharacters charsHello = cells["A1"].GetCharacters(19, 5);

charsHello.Font.Italic = true;

charsHello.Font.Color = SpreadsheetGear.Colors.DarkRed;

// Format "World" text.

ICharacters charsWorld = cells["A1"].GetCharacters(25, 5);

charsWorld.Font.Underline = UnderlineStyle.Single;

charsWorld.Font.Color = SpreadsheetGear.Colors.DarkBlue;

// Expand column width to accommodate header text

cells["A:A"].ColumnWidth = 30;

// Save and view in Excel...

workbook.SaveAs(@"c:\temp\rtf.xlsx", FileFormat.OpenXMLWorkbook);

// ...or attach to SpreadsheetGear's WPF WorkbookView to

// confirm RTF is displaying as expected (NOTE: the WinForms

// WorkbookView does not support rendering RTF).

workbookView.ActiveWorkbook = workbook;