Exporting Data Set to HTML Table and then pasting to Word, does not display in table format, just as text with HTML tagging. (4308693)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Exporting Data Set to HTML Table and then pasting to Word, does not display in table format, just as text with HTML tagging.
Descripción

When exporting the results of a query to an 'HTML Table' and selecting the output to the Clipboard, the table is not displayed when pasted into a Word document. It just displays as text with the HTML tags. e.g
<TABLE id="" cellSpacing="1" cellPadding="1" width="100%" border="1" ><TR><TD>CUSTID</TD><TD>FNAME</TD><TD>LNAME</TD><TD>ADDID</TD><TD>STATE</TD><TD>NOTES</TD></TR>
<TR><TD>1</TD><TD>Joe</TD><TD>Smith</TD><TD>123</TD><TD>CA</TD><TD>resident</TD></TR>
<TR><TD>2</TD><TD>Jane</TD><TD>Smith</TD><TD>123</TD><TD>CA</TD><TD></TD></TR>
<TR><TD>3</TD><TD>Jack</TD><TD>Smith</TD><TD>123</TD><TD>CA</TD><TD></TD></TR>
</TABLE>
Causa

This is as designed. Notice that the option is to copy to Clipboard or copy to an HTML file. If it is saved as an HTML file and opened up, the tags will be interpreted and a table will be created with the data set. If sent to the Clipboard, then it will be copied as straight text which includes the html tagging. This would be pasted as straight text in Word.
Resolución

Save the dataset as an HTML file. Open the the HTML file in Word, and it should recognize the table structure. The file can now be saved as a Word document (docx) and the table formatting will be retained.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Historial del artículo:: Creado el: 2/17/2015
Última actualización: 5/7/2023

Título