Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) |