HTML in cell appears as text
 

I'm generating an excel worksheet from an external application, some data
that I need to insert in it contain html tags such as bold, underline,
colors, line breaks, etc.
How can I make this data rendered "as html" in excel instead of all tags
appearing as plain text ?

data sample: this is my data in <B bold </B

Philippe.

HTML in cell appears as text
 

Here's the way I have found.
Save the data from the application as a .htm file.
Open the .htm file in Excel. The formatting is processed correctly now.
Use Data text to columns if necessary.
Then save it as a workbook .xls file.
--
Allllen


"Philippe" wrote:

I'm generating an excel worksheet from an external application, some data
that I need to insert in it contain html tags such as bold, underline,
colors, line breaks, etc.
How can I make this data rendered "as html" in excel instead of all tags
appearing as plain text ?

data sample: this is my data in <B bold </B

Philippe.

HTML in cell appears as text
 

Of course.
I'll change my code to try your solution. Thanks, Philippe.

"Allllen" wrote:

Here's the way I have found.
Save the data from the application as a .htm file.
Open the .htm file in Excel. The formatting is processed correctly now.
Use Data text to columns if necessary.
Then save it as a workbook .xls file.
--
Allllen


"Philippe" wrote:

I'm generating an excel worksheet from an external application, some data
that I need to insert in it contain html tags such as bold, underline,
colors, line breaks, etc.
How can I make this data rendered "as html" in excel instead of all tags
appearing as plain text ?

data sample: this is my data in <B bold </B

Philippe.