Select substring within cell and set its style

Asked Nov 02 '15 at 22:16

Active Nov 02 '15 at 22:18

Viewed 91 times

I can iterate over cells within worksheet. Each cell contains some text.

How can I select a substring within single cell and set its individual style?

For example underline a specific word (found by pattern or by start/end index of chars) within single cell.

edited Nov 02 '15 at 22:18

pnuts

asked Nov 02 '15 at 22:16

lavrik

I think this might help you: http://stackoverflow.com/questions/5646145/how-can-i-extract-a-string-from-an-excel-cell – Mocanu Bogdan Nov 02 '15 at 22:28
@Mocanu Bogdan your link is about extracting entire cell as string. It;s not possible to set it's style then. – lavrik Nov 03 '15 at 10:00
@Ben Reading cell value, but i can access it as string only. – lavrik Nov 03 '15 at 10:02

0 Answers0