c# - NPOI how to read richtext from cell

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

I have to read an XLSX with NPOI. In my xlsx there are cells which they have bold words, there is a way to find those words using NPOI?

Thank you

Hi, can you provide some source code that you have tried? Did you get any exception or are you using some documentation for reference? – Nemanja Todorovic May 25, 2020 at 17:09

The only way I found was to loop on each char of the richtext

XSSFRichTextString s = (XSSFRichTextString)c.RichStringCellValue;
for (int t = 0; t < s.Length; t++)
    var myfont = s.GetFontAtIndex(t);
    if (myfont != null && myfont.IsBold)
        boldCharactersIndex.Add(t); // boldCharactersIndex is a list of indexes with bold chars
        Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.

推荐文章

好帅的苦咖啡 · POI(excel)中Cell应用实践总结_row.getcell

2 周前

稳重的佛珠 · Camunda 7工作流引擎 API 以及与Springboot集成实现工作流配置全纪录_camunda7-CSDN博客

6 月前

刚毅的皮带 · 要获取item_list 中的第所有的元素 - CSDN文库

9 月前

谦和的炒粉 · node.js - NPM not working. Cannot find module 'strip ansi' - Stack Overflow

1 年前

果断的乌冬面 · typescript属性“type”在类型“never”上不存在-腾讯云开发者社区-腾讯云

1 年前

傲视众生的山寨机 · 袁萌（浙江智捷元港国际供应链科技有限公司总经理）_百度百科

1 年前