Write HTML instead of Rich Text

[ali.baghdadi]

Could I simply write html to a cell instead of a rich text?
for example I want to use this: "<span style=\"border-width:thin;border-color:#FFFFFF;\"><font color=#000000 size=8><b>U = Unchanged rate</b></font></span>"

[burning.liu]

Dear ali.baghdadi,

Thanks for your inquiry.

For your requirement, please refer to the code below:

Code: Select all

Workbook workbook = new Workbook();
Document doc = new Document();

StringReader sr = new StringReader("<span style=\"border-width:thin;border-color:#FFFFFF;\"><font color=#000000 size=8><b>U = Unchanged rate</b></font></span>");
doc.LoadHTML(sr, XHTMLValidationType.None);
int index = 0;

foreach (Section section in doc.Sections)
{
    foreach (Paragraph paragraph in section.Paragraphs)
    {
        if (paragraph.Items.Count > 0)
        {
            workbook.Worksheets[0].Range["A4"].RichText.Text += paragraph.Text;
            foreach (var item in paragraph.Items)
            {
                if (item is Spire.Doc.Fields.TextRange)
                {
                    for (int i = index; i < (item as Spire.Doc.Fields.TextRange).Text.Length + index; i++)
                    {
                        Font font = (item as Spire.Doc.Fields.TextRange).CharacterFormat.Font;
                        ExcelFont excelFont = workbook.CreateFont(font);
                        excelFont.Color = (item as Spire.Doc.Fields.TextRange).CharacterFormat.TextColor;
                        workbook.Worksheets[0].Range["A4"].RichText.SetFont(i, i, excelFont);
                    }
                }
                index += (item as Spire.Doc.Fields.TextRange).Text.Length;
            }
        }
    }
}
workbook.Worksheets[0].Range["A4"].AutoFitRows();
workbook.SaveToFile("3846.xlsx", ExcelVersion.Version2010);


Best Regards,
Burning
E-iceblue Support Team

[burning.liu]

Dear ali.baghdadi,

Have you tried the code snippet I provided? Has the problem been resolved?
Please give us some feedback if convenience.

Best Regards,
Burning
E-iceblue Support Team