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

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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

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>
Cause

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.
Résolution

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.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 2/17/2015
Dernière mise à jour le : 5/7/2023

Titre