Performance issue with rich text · Issue #664 · EPPlusSoftware/EPPlus

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

多情的芒果 · 《战×恋》在线观看_高清全集无修_NT动漫· 3 周前 ·

威武的长颈鹿 · 前端-常用点击事件获取元素的方式及oncli ...· 2 周前 ·

面冷心慈的登山鞋 · 3D ...· 3 月前 ·

风度翩翩的凳子 · python ...· 3 月前 ·

冷冷的萝卜 · 如何在您的 Sony Android ...· 3 月前 ·

开朗的键盘 · 多家银行上调“黄金定投”起存门槛· 4 月前 ·

刚毅的香蕉 · 分類:裁判 - 台灣棒球維基館· 5 月前 ·

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

I'm inserting text with superscript footnote ids into cells and have found and usage of rich text is ~15x slower than plain text

Attached is a benchmark comparing epplus to npoi.

I am inserting 50k rows with two columns, the first column just an int id, the second column:

for plain text: [id] This is the test for id (ie: [1] This is the text for 1)

for rich text: instead of [id] above, just the int id as superscript.

Is there a better way to apply rich text than this that I'm missing?

Code for the benchmark is just a .net 6 console app using benchmark .net

    [SimpleJob(RuntimeMoniker.Net60)]
    [MemoryDiagnoser]
    //[RPlotExporter]
    public class ExcelLibraryCreateTests
        private readonly Dictionary<int, string> items = new();
        [GlobalSetup]
        public void Setup()
            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
            for (int i = 0; i < 50000; i++)
                items.Add(i, "This is text for " + i);
        [Benchmark]
        public byte[] EpplusPlainText()
            using (var file = new ExcelPackage())
                var rowIndex = 1;
                var worksheet = file.Workbook.Worksheets.Add("Data");
                worksheet.Cells[rowIndex, 1].Value = "Key";
                worksheet.Cells[rowIndex, 2].Value = "Value";
                foreach (var item in items)
                    rowIndex++;
                    worksheet.Cells[rowIndex, 1].Value = item.Key;
                    worksheet.Cells[rowIndex, 2].Value = $"[{item.Key}] {item.Value}";
                return file.GetAsByteArray();
        [Benchmark]
        public byte[] EpplusRichText()
            using (var file = new ExcelPackage())
                var rowIndex = 1;
                var worksheet = file.Workbook.Worksheets.Add("Data");
                worksheet.Cells[rowIndex, 1].Value = "Key";
                worksheet.Cells[rowIndex, 2].Value = "Value";
                foreach (var item in items)
                    rowIndex++;
                    worksheet.Cells[rowIndex, 1].Value = item.Key;
                    var richTextCollection = worksheet.Cells[rowIndex, 2].RichText;
                    var richText = richTextCollection.Add(item.Key.ToString());
                    richText.VerticalAlign = ExcelVerticalAlignmentFont.Superscript;
                    richTextCollection.Add(item.Value);
                return file.GetAsByteArray();
        [Benchmark]
        public byte[] NpoiPlainText()
            var workbook = new XSSFWorkbook();
            var sheet = workbook.CreateSheet();
            var rowIndex = 0;
            var header = sheet.CreateRow(0);
            header.CreateCell(0).SetCellValue("Key");
            header.CreateCell(1).SetCellValue("Value");
            foreach (var item in items)
                rowIndex++;
                var row = sheet.CreateRow(rowIndex);
                row.CreateCell(0).SetCellValue(item.Key);
                row.CreateCell(1).SetCellValue($"[{item.Key}]{item.Value}");
            using var ms = new MemoryStream();
            workbook.Write(ms);
            return ms.ToArray();
        [Benchmark]
        public byte[] NpoiRichText()
            var workbook = new XSSFWorkbook();
            var sheet = workbook.CreateSheet();
            var rowIndex = 0;
            var header = sheet.CreateRow(0);
            header.CreateCell(0).SetCellValue("Key");
            header.CreateCell(1).SetCellValue("Value");
            var superscript = workbook.CreateFont();
            superscript.TypeOffset = NPOI.SS.UserModel.FontSuperScript.Super;
            foreach (var item in items)
                rowIndex++;
                var row = sheet.CreateRow(rowIndex);
                row.CreateCell(0).SetCellValue(item.Key);
                var cell = row.CreateCell(1);
                cell.SetCellValue($"{item.Key}{item.Value}");
                cell.RichStringCellValue.ApplyFont(0, 1, superscript);
            using var ms = new MemoryStream();
            workbook.Write(ms);
            return ms.ToArray();